1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
-- -----------------------------------------------------
-- Table `mydb`.`Measure`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Measure` (
`id_Measure` INT NOT NULL ,
`full_name` VARCHAR( 45 ) NOT NULL ,
`abbr_name` VARCHAR( 10 ) NOT NULL ,
PRIMARY KEY (`id_Measure`) )
ENGINE = MyISAM;
-- -----------------------------------------------------
-- Table `mydb`.`GroupProduct`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`GroupProduct` (
`id_Group_Product` INT NOT NULL ,
`name` VARCHAR( 45 ) NOT NULL ,
PRIMARY KEY (`id_Group_Product`) )
ENGINE = MyISAM;
-- -----------------------------------------------------
-- Table `mydb`.`SubGroup`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`SubGroup` (
`id_SubGroup` INT NOT NULL ,
`id_group` INT NULL ,
`name` VARCHAR( 45 ) NOT NULL ,
PRIMARY KEY (`id_SubGroup`, `id_group`) ,
INDEX `fk_SubGroup_1` (`id_group` ASC) ,
CONSTRAINT `fk_SubGroup_1`
FOREIGN KEY (`id_group` )
REFERENCES `mydb`.`GroupProduct` (`id_Group_Product` )
ON DELETE SET NULL
ON UPDATE CASCADE)
ENGINE = MyISAM;
-- -----------------------------------------------------
-- Table `mydb`.`Product`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Product` (
`id_product` INT NOT NULL ,
`name_product` VARCHAR( 100 ) NOT NULL ,
`sybgroup_product` INT NULL ,
`description` VARCHAR( 2000 ) NOT NULL ,
`measure` INT NOT NULL ,
PRIMARY KEY (`id_product`, `sybgroup_product`, `measure`) ,
INDEX `fk_Product_1` (`measure` ASC) ,
INDEX `fk_Product_2` (`sybgroup_product` ASC) ,
CONSTRAINT `fk_Product_1`
FOREIGN KEY (`measure` )
REFERENCES `mydb`.`Measure` (`id_Measure` )
ON DELETE SET NULL
ON UPDATE CASCADE,
CONSTRAINT `fk_Product_2`
FOREIGN KEY (`sybgroup_product` )
REFERENCES `mydb`.`SubGroup` (`id_SubGroup` )
ON DELETE SET NULL
ON UPDATE CASCADE)
ENGINE = MyISAM;
-- -----------------------------------------------------
-- Table `mydb`.`Document_head`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Document_head` (
`id_Document_head` INT NOT NULL ,
`total_count` DOUBLE NOT NULL ,
`status` INT NOT NULL ,
PRIMARY KEY (`id_Document_head`) )
ENGINE = MyISAM;
-- -----------------------------------------------------
-- Table `mydb`.`Warehouse`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Warehouse` (
`id_Warehouse` INT NOT NULL ,
`name_warehouse` VARCHAR( 45 ) NOT NULL ,
`address_warehouse` VARCHAR( 450 ) NOT NULL ,
`city_warehouse` VARCHAR( 100 ) NOT NULL ,
`phone_warehouse` VARCHAR( 15 ) NOT NULL ,
PRIMARY KEY (`id_Warehouse`) )
ENGINE = MyISAM;
-- -----------------------------------------------------
-- Table `mydb`.`Contragent`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Contragent` (
`id_Contragent` INT NOT NULL ,
`full_name` VARCHAR( 45 ) NOT NULL ,
`name` VARCHAR( 45 ) NOT NULL ,
`address` VARCHAR( 45 ) NOT NULL ,
`city` VARCHAR( 45 ) NOT NULL ,
`phone` VARCHAR( 45 ) NOT NULL ,
PRIMARY KEY (`id_Contragent`) )
ENGINE = MyISAM;
-- -----------------------------------------------------
-- Table `mydb`.`Journal`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Journal` (
`id_Journal` INT NOT NULL ,
`id_part` INT NOT NULL ,
`id_document` INT NOT NULL ,
`date_document` DATETIME NOT NULL ,
`type_document` INT NOT NULL ,
`from_warehouse` INT NOT NULL ,
`to_warehouse` INT NULL ,
`from_contragent` INT NULL ,
`to_contragent` INT NOT NULL ,
`count` DOUBLE NOT NULL ,
`summa` DOUBLE NOT NULL ,
PRIMARY KEY (`from_warehouse`, `to_warehouse`, `from_contragent`, `to_contragent`, `id_Journal`, `id_document`) ,
INDEX `fk_Journal_1` (`id_document` ASC) ,
INDEX `fk_Journal_2` (`from_warehouse` ASC, `to_warehouse` ASC) ,
INDEX `fk_Journal_3` (`from_contragent` ASC, `to_contragent` ASC) ,
CONSTRAINT `fk_Journal_1`
FOREIGN KEY (`id_document` )
REFERENCES `mydb`.`Document_head` (`id_Document_head` )
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `fk_Journal_2`
FOREIGN KEY (`from_warehouse` , `to_warehouse` )
REFERENCES `mydb`.`Warehouse` (`id_Warehouse` , `id_Warehouse` )
ON DELETE SET NULL
ON UPDATE CASCADE,
CONSTRAINT `fk_Journal_3`
FOREIGN KEY (`from_contragent` , `to_contragent` )
REFERENCES `mydb`.`Contragent` (`id_Contragent` , `id_Contragent` )
ON DELETE SET NULL
ON UPDATE CASCADE)
ENGINE = MyISAM;
-- -----------------------------------------------------
-- Table `mydb`.`BindExpenseInvoice`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`BindExpenseInvoice` (
`id_BindExpenseInvoice` INT NOT NULL ,
`id_expense_part` INT NOT NULL ,
`id_invoice_part` INT NOT NULL ,
`count` DOUBLE NOT NULL ,
PRIMARY KEY (`id_BindExpenseInvoice`, `id_expense_part`, `id_invoice_part`) ,
INDEX `fk_BindExpenseInvoice_1` (`id_expense_part` ASC, `id_invoice_part` ASC) ,
CONSTRAINT `fk_BindExpenseInvoice_1`
FOREIGN KEY (`id_expense_part` , `id_invoice_part` )
REFERENCES `mydb`.`Journal` (`id_part` , `id_part` )
ON DELETE CASCADE
ON UPDATE CASCADE)
ENGINE = MyISAM;
-- -----------------------------------------------------
-- Table `mydb`.`Price`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Price` (
`id_Price` INT NOT NULL ,
`date_price` DATETIME NOT NULL ,
`product` INT NOT NULL ,
`invoice_price_rozn` DOUBLE NOT NULL ,
`expense_price_rozn` DOUBLE NOT NULL ,
`invoice_optom` DOUBLE NOT NULL ,
`expense_optom` DOUBLE NOT NULL ,
PRIMARY KEY (`id_Price`, `product`) ,
INDEX `fk_Price_1` (`product` ASC) ,
CONSTRAINT `fk_Price_1`
FOREIGN KEY (`product` )
REFERENCES `mydb`.`Product` (`id_product` )
ON DELETE CASCADE
ON UPDATE CASCADE)
ENGINE = MyISAM;
-- -----------------------------------------------------
-- Table `mydb`.`Document`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Document` (
`id_Document_head` INT NOT NULL ,
`id` INT NOT NULL ,
`id_product` INT NOT NULL ,
`id_price` INT NOT NULL ,
`count` DOUBLE NOT NULL ,
PRIMARY KEY (`id_Document_head`, `id`, `id_price`, `id_product`) ,
INDEX `fk_Document_1` (`id_Document_head` ASC) ,
INDEX `fk_Document_2` (`id_product` ASC) ,
INDEX `fk_Document_3` (`id_price` ASC) ,
CONSTRAINT `fk_Document_1`
FOREIGN KEY (`id_Document_head` )
REFERENCES `mydb`.`Document_head` (`id_Document_head` )
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `fk_Document_2`
FOREIGN KEY (`id_product` )
REFERENCES `mydb`.`Product` (`id_product` )
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `fk_Document_3`
FOREIGN KEY (`id_price` )
REFERENCES `mydb`.`Price` (`id_Price` )
ON DELETE SET NULL
ON UPDATE CASCADE)
ENGINE = MyISAM;
