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'); |
Partager