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
| CREATE TABLE "Detenteur"
( nextval('"Personne_PersonneID_seq"'::regclass),
NULL,
NULL,
CONSTRAINT pk_detenteur PRIMARY KEY ("PersonneID" ),
CONSTRAINT "Detenteur_PersonneID_key" UNIQUE ("PersonneID" ),
CONSTRAINT fk_det_pers FOREIGN KEY ("PersonneID") REFERENCES "Personne" ("PersonneID") MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION
)
INHERITS ("Personne")
);
CREATE TABLE "Personne"
(
"PersonneID" serial NOT NULL,
"Nom" character varying(64) NOT NULL,
"Prenom" character varying(64) NOT NULL,
"Adresse" character varying(128),
CONSTRAINT pk_pers PRIMARY KEY ("PersonneID" )
); |
Partager