· 6 years ago · Jun 18, 2019, 08:04 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server Version: 10.3.13-MariaDB - mariadb.org binary distribution
4-- Server Betriebssystem: Win64
5-- HeidiSQL Version: 9.5.0.5196
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Exportiere Datenbank Struktur für processeddata
16CREATE DATABASE IF NOT EXISTS `processeddata` /*!40100 DEFAULT CHARACTER SET utf8 */;
17USE `processeddata`;
18
19-- Exportiere Struktur von Tabelle processeddata.company
20CREATE TABLE IF NOT EXISTS `company` (
21 `name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
22 `displayName` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
23 `city` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
24 `employeeCount` int(11) DEFAULT NULL,
25 `website` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
26 `id` bigint(20) NOT NULL AUTO_INCREMENT,
27 PRIMARY KEY (`id`)
28) ENGINE=InnoDB AUTO_INCREMENT=15400 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
29
30-- Daten Export vom Benutzer nicht ausgewählt
31-- Exportiere Struktur von Tabelle processeddata.companyperk
32CREATE TABLE IF NOT EXISTS `companyperk` (
33 `id` bigint(20) NOT NULL AUTO_INCREMENT,
34 `name` varchar(80) DEFAULT NULL,
35 PRIMARY KEY (`id`)
36) ENGINE=InnoDB DEFAULT CHARSET=utf8;
37
38-- Daten Export vom Benutzer nicht ausgewählt
39-- Exportiere Struktur von Tabelle processeddata.companyperk_joboffer
40CREATE TABLE IF NOT EXISTS `companyperk_joboffer` (
41 `jobofferId` bigint(20),
42 `companyperkId` bigint(20),
43 KEY `companyPerkId` (`companyperkId`),
44 KEY `fk_jobofferId_companyperkId` (`jobofferId`),
45 CONSTRAINT `fk_companyperkId_joboffer` FOREIGN KEY (`companyperkId`) REFERENCES `companyperk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
46 CONSTRAINT `fk_jobofferId_companyperkId` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE
47) ENGINE=InnoDB DEFAULT CHARSET=utf8;
48
49-- Daten Export vom Benutzer nicht ausgewählt
50-- Exportiere Struktur von Tabelle processeddata.joboffer
51CREATE TABLE IF NOT EXISTS `joboffer` (
52 `stepstoneId` bigint(20) NOT NULL,
53 `employmentType` varchar(50) DEFAULT NULL,
54 `minYears` int(11) DEFAULT NULL,
55 `rank` varchar(80) DEFAULT NULL,
56 `workingHours` varchar(50) DEFAULT NULL,
57 `title` varchar(200) DEFAULT NULL,
58 `location` varchar(200) DEFAULT NULL,
59 `salutation` tinyint(4) DEFAULT NULL COMMENT '1=sitzen',
60 `companyId` bigint(20) DEFAULT NULL,
61 PRIMARY KEY (`stepstoneId`),
62 KEY `fk_company_joboffer` (`companyId`),
63 CONSTRAINT `fk_company_joboffer` FOREIGN KEY (`companyId`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
64) ENGINE=InnoDB DEFAULT CHARSET=utf8;
65
66-- Daten Export vom Benutzer nicht ausgewählt
67-- Exportiere Struktur von Tabelle processeddata.keyword
68CREATE TABLE IF NOT EXISTS `keyword` (
69 `id` bigint(20) NOT NULL AUTO_INCREMENT,
70 `name` varchar(120) DEFAULT NULL,
71 PRIMARY KEY (`id`)
72) ENGINE=InnoDB DEFAULT CHARSET=utf8;
73
74-- Daten Export vom Benutzer nicht ausgewählt
75-- Exportiere Struktur von Tabelle processeddata.keyword_joboffer
76CREATE TABLE IF NOT EXISTS `keyword_joboffer` (
77 `keywordId` bigint(20) DEFAULT NULL,
78 `jobofferId` bigint(20) DEFAULT NULL,
79 KEY `fk_jobofferId_keyword` (`jobofferId`),
80 KEY `fk_keywordId_joboffer` (`keywordId`),
81 CONSTRAINT `fk_jobofferId_keyword` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE,
82 CONSTRAINT `fk_keywordId_joboffer` FOREIGN KEY (`keywordId`) REFERENCES `keyword` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
83) ENGINE=InnoDB DEFAULT CHARSET=utf8;
84
85-- Daten Export vom Benutzer nicht ausgewählt
86-- Exportiere Struktur von Tabelle processeddata.location
87CREATE TABLE IF NOT EXISTS `location` (
88 `id` bigint(20) NOT NULL AUTO_INCREMENT,
89 `name` varchar(100) DEFAULT NULL,
90 PRIMARY KEY (`id`)
91) ENGINE=InnoDB DEFAULT CHARSET=utf8;
92
93-- Daten Export vom Benutzer nicht ausgewählt
94-- Exportiere Struktur von Tabelle processeddata.location_joboffer
95CREATE TABLE IF NOT EXISTS `location_joboffer` (
96 `locationId` bigint(20) NOT NULL,
97 `jobofferId` bigint(20) NOT NULL,
98 KEY `fk_locationId_joboffer` (`locationId`),
99 KEY `fk_jobofferId_location` (`jobofferId`),
100 CONSTRAINT `fk_jobofferId_location` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE,
101 CONSTRAINT `fk_locationId_joboffer` FOREIGN KEY (`locationId`) REFERENCES `location` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
102) ENGINE=InnoDB DEFAULT CHARSET=utf8;
103
104-- Daten Export vom Benutzer nicht ausgewählt
105-- Exportiere Struktur von Tabelle processeddata.requirement
106CREATE TABLE IF NOT EXISTS `requirement` (
107 `id` bigint(20) NOT NULL AUTO_INCREMENT,
108 `name` varchar(100) NOT NULL,
109 PRIMARY KEY (`id`)
110) ENGINE=InnoDB DEFAULT CHARSET=utf8;
111
112-- Daten Export vom Benutzer nicht ausgewählt
113-- Exportiere Struktur von Tabelle processeddata.requirement_joboffer
114CREATE TABLE IF NOT EXISTS `requirement_joboffer` (
115 `requirementId` bigint(20) NOT NULL,
116 `jobofferId` bigint(20) NOT NULL,
117 KEY `fk_jobofferId_requirement` (`jobofferId`),
118 KEY `fk_requirementId_joboffer` (`requirementId`),
119 CONSTRAINT `fk_jobofferId_requirement` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE,
120 CONSTRAINT `fk_requirementId_joboffer` FOREIGN KEY (`requirementId`) REFERENCES `requirement` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
121) ENGINE=InnoDB DEFAULT CHARSET=utf8;
122
123-- Daten Export vom Benutzer nicht ausgewählt
124-- Exportiere Struktur von Tabelle processeddata.technology
125CREATE TABLE IF NOT EXISTS `technology` (
126 `id` bigint(20) NOT NULL AUTO_INCREMENT,
127 `name` varchar(120) NOT NULL,
128 PRIMARY KEY (`id`)
129) ENGINE=InnoDB DEFAULT CHARSET=utf8;
130
131-- Daten Export vom Benutzer nicht ausgewählt
132-- Exportiere Struktur von Tabelle processeddata.technology_joboffer
133CREATE TABLE IF NOT EXISTS `technology_joboffer` (
134 `technologyId` bigint(20) NOT NULL,
135 `jobofferId` bigint(20) NOT NULL,
136 KEY `fk_technologyId_joboffer` (`technologyId`),
137 KEY `fk_jobofferId_technology` (`jobofferId`),
138 CONSTRAINT `fk_jobofferId_technology` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE,
139 CONSTRAINT `fk_technologyId_joboffer` FOREIGN KEY (`technologyId`) REFERENCES `technology` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
140) ENGINE=InnoDB DEFAULT CHARSET=utf8;
141
142-- Daten Export vom Benutzer nicht ausgewählt
143/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
144/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
145/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;