AKeX6w8e

1-- -----------------------------------------------------
2-- Schema mall
3-- -----------------------------------------------------
4CREATE SCHEMA IF NOT EXISTS `mall` DEFAULT CHARACTER SET utf8 ;
5USE `mall` ;
6
7-- -----------------------------------------------------
8-- Table `mall`.`category_tovarov`
9-- -----------------------------------------------------
10CREATE TABLE IF NOT EXISTS `mall`.`category_tovarov` (
11`idcategory_tovarov` INT(11) NOT NULL AUTO_INCREMENT,
12`name` VARCHAR(105) NOT NULL,
13PRIMARY KEY (`idcategory_tovarov`))
14ENGINE = InnoDB
15AUTO_INCREMENT = 84
16DEFAULT CHARACTER SET = utf8;
17
18-- -----------------------------------------------------
19-- Table `mall`.`type_company`
20-- -----------------------------------------------------
21CREATE TABLE IF NOT EXISTS `mall`.`type_company` (
22`idtype_company` INT(11) NOT NULL AUTO_INCREMENT,
23`name` VARCHAR(45) NOT NULL,
24PRIMARY KEY (`idtype_company`))
25ENGINE = InnoDB
26AUTO_INCREMENT = 5
27DEFAULT CHARACTER SET = utf8;
28-- -----------------------------------------------------
29-- Table `mall`.`arendator`
30-- -----------------------------------------------------
31CREATE TABLE IF NOT EXISTS `mall`.`arendator` (
32`idarendator` INT(11) NOT NULL AUTO_INCREMENT,
33`name_company` VARCHAR(45) NOT NULL,
34`idtype_company` INT(11) NOT NULL,
35`category_tovarov` INT(11) NOT NULL,
36`phone` VARCHAR(13) NOT NULL,
37`FIO` VARCHAR(150) NOT NULL,
38`adres` VARCHAR(150) NOT NULL,
39PRIMARY KEY (`idarendator`),
40INDEX `tc_fk_idx` (`idtype_company` ASC) VISIBLE,
41INDEX `tc_fk_idx1` (`category_tovarov` ASC) VISIBLE,
42CONSTRAINT `ct_fk`
43FOREIGN KEY (`category_tovarov`)
44REFERENCES `mall`.`category_tovarov` (`idcategory_tovarov`),
45CONSTRAINT `tc_fk`
46FOREIGN KEY (`idtype_company`)
47REFERENCES `mall`.`type_company` (`idtype_company`))
48ENGINE = InnoDB
49AUTO_INCREMENT = 174
50DEFAULT CHARACTER SET = utf8;
51
52-- -----------------------------------------------------
53-- Table `mall`.`dogovor`
54-- -----------------------------------------------------
55CREATE TABLE IF NOT EXISTS `mall`.`dogovor` (
56`iddogovor` INT(11) NOT NULL AUTO_INCREMENT,
57`idt_tochki` INT(11) NOT NULL,
58`idarendator` INT(11) NOT NULL,
59`tsena_arendy_kv_m` FLOAT NOT NULL,
60`data_nachala` DATE NOT NULL,
61`data_okonchaniya` DATE NOT NULL,
62PRIMARY KEY (`iddogovor`),
63INDEX `idarenda_idx` (`idarendator` ASC) VISIBLE,
64CONSTRAINT `idarenda`
65FOREIGN KEY (`idarendator`)
66REFERENCES `mall`.`arendator` (`idarendator`)
67ON DELETE CASCADE
68ON UPDATE CASCADE)
69ENGINE = InnoDB
70AUTO_INCREMENT = 185
71DEFAULT CHARACTER SET = utf8;
72
73-- -----------------------------------------------------
74-- Table `mall`.`status`
75-- -----------------------------------------------------
76CREATE TABLE IF NOT EXISTS `mall`.`status` (
77`idstatus` INT(11) NOT NULL AUTO_INCREMENT,
78`name` VARCHAR(45) NOT NULL,
79PRIMARY KEY (`idstatus`))
80ENGINE = InnoDB
81AUTO_INCREMENT = 4
82DEFAULT CHARACTER SET = utf8;
83
84-- -----------------------------------------------------
85-- Table `mall`.`type`
86-- -----------------------------------------------------
87CREATE TABLE IF NOT EXISTS `mall`.`type` (
88`idtype` INT(11) NOT NULL AUTO_INCREMENT,
89`name` VARCHAR(45) NOT NULL,
90PRIMARY KEY (`idtype`))
91ENGINE = InnoDB
92AUTO_INCREMENT = 3
93DEFAULT CHARACTER SET = utf8;
94
95-- -----------------------------------------------------
96-- Table `mall`.`t_tochka`
97-- -----------------------------------------------------
98CREATE TABLE IF NOT EXISTS `mall`.`t_tochka` (
99`idt_tochki` INT(11) NOT NULL AUTO_INCREMENT,
100`etazh` INT(11) NOT NULL,
101`ploshchad` FLOAT NOT NULL,
102`konditsioner` TINYINT(4) NULL DEFAULT NULL,
103`idtype` INT(11) NULL DEFAULT NULL,
104`idstatus` INT(11) NULL DEFAULT NULL,
105PRIMARY KEY (`idt_tochki`),
106INDEX `idstatus_idx` (`idstatus` ASC) VISIBLE,
107INDEX `idtype_idx` (`idtype` ASC) VISIBLE,
108CONSTRAINT `idstatus`
109FOREIGN KEY (`idstatus`)
110REFERENCES `mall`.`status` (`idstatus`)
111ON DELETE CASCADE
112ON UPDATE CASCADE,
113CONSTRAINT `idtype`
114FOREIGN KEY (`idtype`)
115REFERENCES `mall`.`type` (`idtype`)
116ON DELETE CASCADE
117ON UPDATE CASCADE)
118ENGINE = InnoDB
119AUTO_INCREMENT = 199
120DEFAULT CHARACTER SET = utf8;
121
122-- -----------------------------------------------------
123-- Table `mall`.`magazine`
124-- -----------------------------------------------------
125CREATE TABLE IF NOT EXISTS `mall`.`magazine` (
126`idmagazine` INT(11) NOT NULL AUTO_INCREMENT,
127`idt_tochki` INT(11) NOT NULL,
128`idcategory_tovarov` INT(11) NOT NULL,
129`name` VARCHAR(20) NOT NULL,
130`work_time` VARCHAR(26) NOT NULL,
131`site` VARCHAR(150) NULL DEFAULT NULL,
132PRIMARY KEY (`idmagazine`),
133INDEX `magaz_fk_t_tchk_idx` (`idt_tochki` ASC) VISIBLE,
134INDEX `idcategory_tovarov_idx` (`idcategory_tovarov` ASC) VISIBLE,
135CONSTRAINT `idcategory_tovarov`
136FOREIGN KEY (`idcategory_tovarov`)
137REFERENCES `mall`.`category_tovarov` (`idcategory_tovarov`),
138CONSTRAINT `magaz_fk_t_tchk`
139FOREIGN KEY (`idt_tochki`)
140REFERENCES `mall`.`t_tochka` (`idt_tochki`)
141ON DELETE CASCADE
142ON UPDATE CASCADE)
143ENGINE = InnoDB
144AUTO_INCREMENT = 173
145DEFAULT CHARACTER SET = utf8;
146
147USE `mall` ;