1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| create table Organisation (
id INT ,
raison_sociale varchar(100) not null,
adresseRue1 varchar(100),
adresseRue2 varchar(100),
codePostal int(10),
ville varchar(100),
adresseFacturation1 varchar(100),
adresseFacturation2 varchar(100),
codePostalFacturation int(10),
villeFacturation varchar(100),
commentaire varchar(500),
adresseEmail varchar(100),
PRIMARY KEY (id)
)ENGINE=INNODB;
create table Exposant (
id int ,
commentaire varchar(500),
code varchar,
idOrganisation int ,
PRIMARY KEY (id),
FOREIGN KEY (idOrganisation) REFERENCES Organisation(id)
)ENGINE=INNODB |
Partager