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
| CREATE DATABASE `carnet` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `carnet`;
CREATE TABLE note(
id_note int ,
text_note nvarchar(1000) ,
date_note datetime ,
id_activite int ,
CONSTRAINT PK_note PRIMARY KEY (id_note));
CREATE TABLE personne(
id_personne int ,
nom_personne nvarchar(50) ,
prenom_personne nvarchar(50) ,
login_personne nvarchar(50) ,
pwd_personne nvarchar(10) ,
role_personne nvarchar(50) ,
date_naiss_personne datetime ,
CONSTRAINT PK_personne PRIMARY KEY (id_personne));
CREATE TABLE activite(
id_activite int ,
id_Domaine_activite int,
non_activite nvarchar(50) ,
dure_activite int ,
cout_activite float ,
disponibilite_activite nchar(10) ,
CONSTRAINT PK_sous_activite PRIMARY KEY (id_activite));
CREATE TABLE jour_sejour(
id_jour int ,
id_sejour int ,
date_jour datetime ,
CONSTRAINT PK_jour_sejour PRIMARY KEY(id_jour));
CREATE TABLE domaine_activite(
id_Domaine_activite int ,
nom_activite nvarchar(50) ,
CONSTRAINT PK_activite PRIMARY KEY (id_Domaine_activite));
CREATE TABLE sejour(
id_sejour int ,
nom_sejour nvarchar(50) ,
dure_sejour int ,
date_debut_sejour datetime ,
CONSTRAINT PK_sejour PRIMARY KEY (id_sejour));
CREATE TABLE visiteur(
id_sejour int ,
id_visiteur int ,
CONSTRAINT PK_visiteur PRIMARY KEY (id_visiteur));
ALTER TABLE visiteur ADD CONSTRAINT FK_visiteur_personne FOREIGN KEY(id_visiteur)
REFERENCES personne (id_personne);
ALTER TABLE note ADD CONSTRAINT FK_activite_note FOREIGN KEY(id_activite)
REFERENCES activite (id_activite);
ALTER TABLE activite ADD CONSTRAINT FK_activite_domain FOREIGN KEY(id_Domaine_activite )
REFERENCES domaine_activite(id_Domaine_activite );
ALTER TABLE jour_sejour ADD CONSTRAINT FK_jour_sejour FOREIGN KEY(id_sejour)
REFERENCES sejour (id_sejour);
ALTER TABLE visiteur ADD CONSTRAINT FK_visiteur_sejour FOREIGN KEY(id_sejour)
REFERENCES sejour (id_sejour); |
