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
| CREATE TABLE artiste (
id SERIAL PRIMARY KEY,
nom character varying(30) NOT NULL,
prenom character varying(30),
sexe character(1) CHECK (sexe IN ('h','f'))
);
CREATE TABLE film (
id SERIAL PRIMARY KEY,
titre character varying(50) NOT NULL,
annee INTEGER NOT NULL,
resume TEXT
);
CREATE TABLE role (
idFilm INTEGER NOT NULL REFERENCES film(id),
idArtiste INTEGER NOT NULL REFERENCES artiste(id),
job character varying(12) CHECK (job IN('Realisateur','Acteur')),
PRIMARY KEY (idFilm, idArtiste)
);
SET SEARCH_PATH=films,PG_CATALOG;
INSERT INTO artiste (nom, prenom, sexe) VALUES ('Nolan','Christopher','h');
INSERT INTO artiste (nom, prenom, sexe) VALUES ('Bale','Christian','h');
INSERT INTO artiste (nom, prenom, sexe) VALUES ('Hathaway','Anne','f');
INSERT INTO artiste (nom, prenom, sexe) VALUES ('Hardy','Tom','h');
INSERT INTO film (titre,annee, resume) VALUES ('Batman Begins',2005,'');
INSERT INTO role (idFilm,idArtiste,job) VALUES (1,1,'Realisateur'); |
