6wQk3W3Z

1CREATE TABLE IF NOT EXISTS `mydb`.`organizations` (
2  `id` INT NOT NULL AUTO_INCREMENT,
3  `name` VARCHAR(45) NULL,
4  `inn` VARCHAR(45) NULL,
5  `isActive` TINYINT NULL,
6  `fullName` VARCHAR(45) NULL,
7  `kpp` VARCHAR(45) NULL,
8  `address` VARCHAR(45) NULL,
9  `phone` VARCHAR(45) NULL,
10  PRIMARY KEY (`id`))
11ENGINE = InnoDB;
12
13
14-- -----------------------------------------------------
15-- Table `mydb`.`offices`
16-- -----------------------------------------------------
17CREATE TABLE IF NOT EXISTS `mydb`.`offices` (
18  `id` INT NOT NULL AUTO_INCREMENT,
19  `ordId` INT NULL,
20  `name` VARCHAR(45) NULL,
21  `phone` VARCHAR(45) NULL,
22  `isActive` TINYINT NULL,
23  `address` VARCHAR(45) NULL,
24  PRIMARY KEY (`id`),
25  CONSTRAINT `orgId`
26    FOREIGN KEY (`ordId`)
27    REFERENCES `mydb`.`organizations` (`id`)
28    ON DELETE NO ACTION
29    ON UPDATE NO ACTION)
30ENGINE = InnoDB;
31
32CREATE INDEX `orgId_idx` ON `mydb`.`offices` (`ordId` ASC);
33
34
35-- -----------------------------------------------------
36-- Table `mydb`.`Docs`
37-- -----------------------------------------------------
38CREATE TABLE IF NOT EXISTS `mydb`.`Docs` (
39  `code` INT NOT NULL AUTO_INCREMENT,
40  `Name` VARCHAR(45) NULL,
41  PRIMARY KEY (`code`))
42ENGINE = InnoDB;
43
44
45-- -----------------------------------------------------
46-- Table `mydb`.`Countries`
47-- -----------------------------------------------------
48CREATE TABLE IF NOT EXISTS `mydb`.`Countries` (
49  `code` INT NOT NULL AUTO_INCREMENT,
50  `name` VARCHAR(45) NULL,
51  PRIMARY KEY (`code`))
52ENGINE = InnoDB;
53
54
55-- -----------------------------------------------------
56-- Table `mydb`.`users`
57-- -----------------------------------------------------
58CREATE TABLE IF NOT EXISTS `mydb`.`users` (
59  `id` INT NOT NULL AUTO_INCREMENT,
60  `officeId` INT NULL,
61  `firstName` VARCHAR(45) NULL,
62  `lastName` VARCHAR(45) NULL,
63  `middleName` VARCHAR(45) NULL,
64  `position` VARCHAR(45) NULL,
65  `docCode` INT NULL,
66  `citizenshipCode` INT NULL,
67  `phone` VARCHAR(45) NULL,
68  `docName` VARCHAR(45) NULL,
69  `docNumber` VARCHAR(45) NULL,
70  `docDate` VARCHAR(45) NULL,
71  `citizenshipName` VARCHAR(45) NULL,
72  `isIdentified` TINYINT NULL,
73  PRIMARY KEY (`id`),
74  CONSTRAINT `officeId`
75    FOREIGN KEY (`officeId`)
76    REFERENCES `mydb`.`offices` (`id`)
77    ON DELETE NO ACTION
78    ON UPDATE NO ACTION,
79  CONSTRAINT `docCode`
80    FOREIGN KEY (`docCode`)
81    REFERENCES `mydb`.`Docs` (`code`)
82    ON DELETE NO ACTION
83    ON UPDATE NO ACTION,
84  CONSTRAINT `citizenshipCode`
85    FOREIGN KEY (`citizenshipCode`)
86    REFERENCES `mydb`.`Countries` (`code`)
87    ON DELETE NO ACTION
88    ON UPDATE NO ACTION)
89ENGINE = InnoDB;
90
91CREATE INDEX `officeId_idx` ON `mydb`.`users` (`officeId` ASC);
92
93CREATE INDEX `docCode_idx` ON `mydb`.`users` (`docCode` ASC);
94
95CREATE INDEX `citizenshipCode_idx` ON `mydb`.`users` (`citizenshipCode` ASC);