bvff1HYP

1drop database if exists PAP;
2create database pap;
3use pap;
4
5create table clothing(
6id_c int(100) primary key auto_increment,
7type varchar(30) not null,
8name varchar(50) not null,
9description varchar(500)not null,
10color varchar(15),
11picture longblob not null,
12price int(10) not null);
13
14
15
16create table clothing_details(
17id_extras int (100) primary auto_increment,
18id_c int(100) not null,
19size varchar(5),
20units int(10)
21FOREIGN KEY (id_c) REFERENCES clothing(id_c)
22);
23
24create table packaging(
25id_p int (100) primary auto_increment,
26id_c int(100) not null,
27adress varchar(100) not null,
28name varchar(50) not null,
29size varchar(5) not null,
30FOREIGN KEY (size) REFERENCES clothing_details(size)
31FOREIGN KEY (units) REFERENCES clothing_details(units)
32FOREIGN KEY (id_c) REFERENCES clothing(id_c)
33);
34
35create table packaging_details(
36id_c int (100),
37id_p int (100),
38size varchar(5),
39units int(10),
40FOREIGN KEY (id_p) REFERENCES packaging(id_p)
41FOREIGN KEY (id_c) REFERENCES clothing(id_c)
42FOREIGN KEY (size) REFERENCES clothing_details(size)
43FOREIGN KEY (units) REFERENCES clothing_details(units)
44);