x22LmANM

1CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
2USE `mydb` ;
3 
4 
5CREATE TABLE IF NOT EXISTS `mydb`.`placement` (
6  `idplacement` INT NOT NULL AUTO_INCREMENT,
7  `searcher` VARCHAR(45) NULL,
8  `jobvacancy` VARCHAR(45) NULL,
9  `company` VARCHAR(45) NULL,
10  `date` DATE NOT NULL,
11  PRIMARY KEY (`idplacement`))
12ENGINE = InnoDB;
13 
14 
15CREATE TABLE IF NOT EXISTS `mydb`.`jobvacancy` (
16  `idjobvacancy` INT NOT NULL AUTO_INCREMENT,
17  `firm` VARCHAR(45) NULL,
18  `workingconditions` VARCHAR(100) NULL,
19  `payment` VARCHAR(45) NULL,
20  `requirements` VARCHAR(100) NULL,
21  `placement_idplacement` INT NOT NULL,
22  PRIMARY KEY (`idjobvacancy`, `placement_idplacement`),
23  INDEX `fk_jobvacancy_placement1_idx` (`placement_idplacement` ASC),
24  CONSTRAINT `fk_jobvacancy_placement1`
25    FOREIGN KEY (`placement_idplacement`)
26    REFERENCES `mydb`.`placement` (`idplacement`))
27ENGINE = InnoDB;
28 
29 
30CREATE TABLE IF NOT EXISTS `mydb`.`company` (
31  `idcompany` INT NOT NULL AUTO_INCREMENT,
32  `adress` VARCHAR(45) NULL,
33  PRIMARY KEY (`idcompany`))
34ENGINE = InnoDB;
35 
36CREATE TABLE IF NOT EXISTS `mydb`.`searcher` (
37  `idsearcher` INT NOT NULL AUTO_INCREMENT,
38  `fullname` VARCHAR(45) NULL,
39  `specialty` VARCHAR(45) NULL,
40  `position` VARCHAR(45) NULL,
41  `education` VARCHAR(45) NULL,
42  `salary` BIGINT(20) NULL,
43  `telephone` VARCHAR(45) NULL,
44  `company_idcompany` INT NOT NULL,
45  PRIMARY KEY (`idsearcher`, `company_idcompany`),
46  INDEX `fk_searcher_company_idx` (`company_idcompany` ASC),
47  CONSTRAINT `fk_searcher_company`
48    FOREIGN KEY (`company_idcompany`)
49    REFERENCES `mydb`.`company` (`idcompany`))
50ENGINE = InnoDB;
51 
52 
53CREATE TABLE IF NOT EXISTS `mydb`.`jobvacancyoncompany` (
54  `jobvacancy_idjobvacancy` INT NOT NULL AUTO_INCREMENT,
55  `jobvacancy_placement_idplacement` INT NOT NULL,
56  `company_idcompany` INT NOT NULL,
57  PRIMARY KEY (`jobvacancy_idjobvacancy`, `jobvacancy_placement_idplacement`, `company_idcompany`),
58  INDEX `fk_jobvacancy_has_company_comp_idx` (`company_idcompany` ASC),
59  INDEX `fk_jobvacancy_has_company_vacancy1_idx` (`jobvacancy_idjobvacancy` ASC, `jobvacancy_placement_idjobvacancyoncompany` ASC),
60  CONSTRAINT `fk_jobvacancy_has_company_vacancy2`
61    FOREIGN KEY (`jobvacancy_idjobvacancy` , `jobvacancy_jobvacancyoncmpany_idplacement`)
62    REFERENCES `mydb`.`jobvacancy` (`idjobvacancy` , `jobvacancyoncompany_idjobvacancyoncompany`)
63  CONSTRAINT `fk_jobvacancy_has_company_company2`
64    FOREIGN KEY (`company_idcompany`)
65    REFERENCES `mydb`.`company` (`idcompany`))
66ENGINE = InnoDB;