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
|
create table ORGANISMES(
NUMERO_ORG VARCHAR(5) NOT NULL,
NOM_ORG VARCHAR(30) NOT NULL,
ADRESSE_ORG VARCHAR(25) NOT NULL,
TELEPHONE_ORG VARCHAR(15) NOT NULL,
FAXE_ORG VARCHAR(15) NOT NULL,
MATIERES_PREMIERES VARCHAR(160) NOT NULL,
NOM_DIRIGEANT VARCHAR(30) NOT NULL,
SITUATION_GEOGRAPHIQUE VARCHAR(40) NOT NULL,
NUMEROTORG varchar(5) not null,
constraint PK_organismes primary key (NUMERO_ORG)
);
create table DEMANDES(
NUMERO_DEM VARCHAR(5) NOT NULL,
LIBELLE VARCHAR(60) NOT NULL,
NOM_DEMANDEUR VARCHAR(20) NOT NULL,
PRIORITE_DE_LA_DEMANDE INTEGER,
constraint PK_demandes primary key (NUMERO_DEM)
);
create table FAIRE(
NUMERO_DEM VARCHAR(5) NOT NULL,
NUMERO_ORG VARCHAR(5) NOT NULL,
constraint PK_faire primary key (NUMERO_DEM, NUMERO_ORG)
); |
Partager