· 6 years ago · Jul 15, 2019, 08:30 PM
1-- MySQL Script generated by MySQL Workbench
2-- Mon Jul 15 23:24:31 2019
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`Manager`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`Manager` (
24 `id` INT NOT NULL,
25 `name` VARCHAR(45) NULL,
26 `rang` VARCHAR(45) NULL,
27 `salary` INT NULL,
28 `data_start` DATETIME NULL,
29 PRIMARY KEY (`id`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`Contract`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `mydb`.`Contract` (
37 `id` INT NOT NULL,
38 `data` DATETIME NULL,
39 `Manager_id` INT NOT NULL,
40 PRIMARY KEY (`id`, `Manager_id`),
41 INDEX `fk_Contract_Manager1_idx` (`Manager_id` ASC) VISIBLE,
42 CONSTRAINT `fk_Contract_Manager1`
43 FOREIGN KEY (`Manager_id`)
44 REFERENCES `mydb`.`Manager` (`id`)
45 ON DELETE NO ACTION
46 ON UPDATE NO ACTION)
47ENGINE = InnoDB;
48
49
50-- -----------------------------------------------------
51-- Table `mydb`.`Client`
52-- -----------------------------------------------------
53CREATE TABLE IF NOT EXISTS `mydb`.`Client` (
54 `id` INT NOT NULL,
55 `name` VARCHAR(45) NULL,
56 `pasport_number` INT NULL,
57 `tel_numb` VARCHAR(45) NULL,
58 `Contract_id` INT NOT NULL,
59 PRIMARY KEY (`id`, `Contract_id`),
60 INDEX `fk_Client_Contract_idx` (`Contract_id` ASC) VISIBLE,
61 CONSTRAINT `fk_Client_Contract`
62 FOREIGN KEY (`Contract_id`)
63 REFERENCES `mydb`.`Contract` (`id`)
64 ON DELETE NO ACTION
65 ON UPDATE NO ACTION)
66ENGINE = InnoDB;
67
68
69-- -----------------------------------------------------
70-- Table `mydb`.`Traner`
71-- -----------------------------------------------------
72CREATE TABLE IF NOT EXISTS `mydb`.`Traner` (
73 `id` INT NOT NULL,
74 `experience` INT NULL,
75 `salary` INT NULL,
76 `rang` VARCHAR(45) NULL,
77 PRIMARY KEY (`id`))
78ENGINE = InnoDB;
79
80
81-- -----------------------------------------------------
82-- Table `mydb`.`Visiting`
83-- -----------------------------------------------------
84CREATE TABLE IF NOT EXISTS `mydb`.`Visiting` (
85 `id` INT NOT NULL,
86 `date` DATETIME NULL,
87 `Traner_id` INT NOT NULL,
88 `Client_id` INT NOT NULL,
89 `Client_Contract_id` INT NOT NULL,
90 PRIMARY KEY (`id`, `Traner_id`, `Client_id`, `Client_Contract_id`),
91 INDEX `fk_Visiting_Traner1_idx` (`Traner_id` ASC) VISIBLE,
92 INDEX `fk_Visiting_Client1_idx` (`Client_id` ASC, `Client_Contract_id` ASC) VISIBLE,
93 CONSTRAINT `fk_Visiting_Traner1`
94 FOREIGN KEY (`Traner_id`)
95 REFERENCES `mydb`.`Traner` (`id`)
96 ON DELETE NO ACTION
97 ON UPDATE NO ACTION,
98 CONSTRAINT `fk_Visiting_Client1`
99 FOREIGN KEY (`Client_id` , `Client_Contract_id`)
100 REFERENCES `mydb`.`Client` (`id` , `Contract_id`)
101 ON DELETE NO ACTION
102 ON UPDATE NO ACTION)
103ENGINE = InnoDB;
104
105
106SET SQL_MODE=@OLD_SQL_MODE;
107SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
108SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;