-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server Version:               10.3.13-MariaDB - mariadb.org binary distribution
-- Server Betriebssystem:        Win64
-- HeidiSQL Version:             9.5.0.5196
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- Exportiere Datenbank Struktur für processeddata
CREATE DATABASE IF NOT EXISTS `processeddata` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `processeddata`;

-- Exportiere Struktur von Tabelle processeddata.company
CREATE TABLE IF NOT EXISTS `company` (
  `name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `displayName` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employeeCount` int(11) DEFAULT NULL,
  `website` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15400 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Daten Export vom Benutzer nicht ausgewählt
-- Exportiere Struktur von Tabelle processeddata.companyperk
CREATE TABLE IF NOT EXISTS `companyperk` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Daten Export vom Benutzer nicht ausgewählt
-- Exportiere Struktur von Tabelle processeddata.companyperk_joboffer
CREATE TABLE IF NOT EXISTS `companyperk_joboffer` (
  `jobofferId` bigint(20),
  `companyperkId` bigint(20),
  KEY `companyPerkId` (`companyperkId`),
  KEY `fk_jobofferId_companyperkId` (`jobofferId`),
  CONSTRAINT `fk_companyperkId_joboffer` FOREIGN KEY (`companyperkId`) REFERENCES `companyperk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_jobofferId_companyperkId` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Daten Export vom Benutzer nicht ausgewählt
-- Exportiere Struktur von Tabelle processeddata.joboffer
CREATE TABLE IF NOT EXISTS `joboffer` (
  `stepstoneId` bigint(20) NOT NULL,
  `employmentType` varchar(50) DEFAULT NULL,
  `minYears` int(11) DEFAULT NULL,
  `rank` varchar(80) DEFAULT NULL,
  `workingHours` varchar(50) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `location` varchar(200) DEFAULT NULL,
  `salutation` tinyint(4) DEFAULT NULL COMMENT '1=sitzen',
  `companyId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`stepstoneId`),
  KEY `fk_company_joboffer` (`companyId`),
  CONSTRAINT `fk_company_joboffer` FOREIGN KEY (`companyId`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Daten Export vom Benutzer nicht ausgewählt
-- Exportiere Struktur von Tabelle processeddata.keyword
CREATE TABLE IF NOT EXISTS `keyword` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(120) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Daten Export vom Benutzer nicht ausgewählt
-- Exportiere Struktur von Tabelle processeddata.keyword_joboffer
CREATE TABLE IF NOT EXISTS `keyword_joboffer` (
  `keywordId` bigint(20) DEFAULT NULL,
  `jobofferId` bigint(20) DEFAULT NULL,
  KEY `fk_jobofferId_keyword` (`jobofferId`),
  KEY `fk_keywordId_joboffer` (`keywordId`),
  CONSTRAINT `fk_jobofferId_keyword` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_keywordId_joboffer` FOREIGN KEY (`keywordId`) REFERENCES `keyword` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Daten Export vom Benutzer nicht ausgewählt
-- Exportiere Struktur von Tabelle processeddata.location
CREATE TABLE IF NOT EXISTS `location` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Daten Export vom Benutzer nicht ausgewählt
-- Exportiere Struktur von Tabelle processeddata.location_joboffer
CREATE TABLE IF NOT EXISTS `location_joboffer` (
  `locationId` bigint(20) NOT NULL,
  `jobofferId` bigint(20) NOT NULL,
  KEY `fk_locationId_joboffer` (`locationId`),
  KEY `fk_jobofferId_location` (`jobofferId`),
  CONSTRAINT `fk_jobofferId_location` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_locationId_joboffer` FOREIGN KEY (`locationId`) REFERENCES `location` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Daten Export vom Benutzer nicht ausgewählt
-- Exportiere Struktur von Tabelle processeddata.requirement
CREATE TABLE IF NOT EXISTS `requirement` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Daten Export vom Benutzer nicht ausgewählt
-- Exportiere Struktur von Tabelle processeddata.requirement_joboffer
CREATE TABLE IF NOT EXISTS `requirement_joboffer` (
  `requirementId` bigint(20) NOT NULL,
  `jobofferId` bigint(20) NOT NULL,
  KEY `fk_jobofferId_requirement` (`jobofferId`),
  KEY `fk_requirementId_joboffer` (`requirementId`),
  CONSTRAINT `fk_jobofferId_requirement` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_requirementId_joboffer` FOREIGN KEY (`requirementId`) REFERENCES `requirement` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Daten Export vom Benutzer nicht ausgewählt
-- Exportiere Struktur von Tabelle processeddata.technology
CREATE TABLE IF NOT EXISTS `technology` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(120) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Daten Export vom Benutzer nicht ausgewählt
-- Exportiere Struktur von Tabelle processeddata.technology_joboffer
CREATE TABLE IF NOT EXISTS `technology_joboffer` (
  `technologyId` bigint(20) NOT NULL,
  `jobofferId` bigint(20) NOT NULL,
  KEY `fk_technologyId_joboffer` (`technologyId`),
  KEY `fk_jobofferId_technology` (`jobofferId`),
  CONSTRAINT `fk_jobofferId_technology` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_technologyId_joboffer` FOREIGN KEY (`technologyId`) REFERENCES `technology` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Daten Export vom Benutzer nicht ausgewählt
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;