MYeEum92

1DROP TABLE IF EXISTS Articles;
2DROP TABLE IF EXISTS Magasins;
3DROP TABLE IF EXISTS Ventes_magasins;
4
5CREATE TABLE IF NOT EXISTS  Articles(
6	Article_id int,
7    Article_label varchar(200),
8    Category varchar(200),
9    Sale_price decimal(10,2),
10    Family_name varchar(50),
11    Family_code varchar(50),
12    primary key (Article_id)
13);
14
15CREATE TABLE IF NOT EXISTS Magasins (
16	Shop_id int,
17    Shop_name varchar(100),
18    Adress_1 varchar(100),
19    Manager varchar(50),
20    Date_open datetime,
21    Floor_space varchar(10),
22    Zip_code varchar(10),
23    City varchar(100),
24    State varchar(50),
25    PRIMARY KEY (Shop_id)
26);
27
28CREATE TABLE IF NOT EXISTS Ventes_magasins (
29	Shop_facts_id int,
30    Article_id int,
31    Color_code int,
32    Week_id int,
33    Shop_id int,
34    Margin decimal(10,2),
35    Amount_sold decimal(10,2),
36    Quantity_sold int,
37    PRIMARY KEY (Article_id, Shop_id)
38);