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
| Create table hotels
(
numh integer,
nomh varchar(30),
etoiles number,
adresse varchar(40),
code_postal char(5),
ville varchar(30),
Constraint pk_hotel primary key (numh)
);
Create table clients
(
numcli integer,
nomcli varchar(30),
adrcli varchar(50),
codepostcli char(5),
villecli varchar(30),
telcli char(15),
Contraint pk_cli primary key (numcli)
);
Create table categories
(
numcat integer,
nbplace integer,
nblits integer,
sdb char(1),
prix float,
Constraint pk_cat primary key (numcat)
);
Create table chambres
(
numch integer,
numh integer,
exposition varchar(20),
priseTV char(1),
telephone char(15),
categorie number,
Constraint pk_ch primary key (numh, numch),
Constraint fk_chcat foreign key (categorie) references categories (numcat)
) ;
Create table reservations
(
numres integer,
datereserv char(8),
debut char(8),
fin char(8),
nbpers integer,
client integer,
hotel integer,
chambre integer,
Constraint pkres primary key (numres),
Constraint fk_rescli foreign key (client) references clients (numcli) ,
Constraint fk_reshot foreign key (hotel) references chambres (numh) ,
Constraint fk_resch foreign key (chambre) references chambres (numch)
) ;
Create table demandes
(
numdem integer,
datedemande char(8),
debut char(8),
fin char(8),
nbpers integer,
region varchar(20),
refus char(1),
client integer,
categorie integer,
hotel number,
Constraint pk_dem primary key (numdem),
Constraint fk_demcli foreign key (client) references clients (numcli) ,
Constraint fk_demcat foreign key (categorie) references categories (numcat) ,
Constraint fk_demhot foreign key (hotel) references hotels (numh)
); |
Partager