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
| CREATE TABLE "Assuré" (
"ID_Assuré" varchar(15) not null,
"Nom" varchar(30) not null,
"Prenom" varchar(25) ,
"adr.rue" varchar(30) ,
"adr.num" integer ,
"adr.boite" integer ,
"adr.CP" integer not null,
"adr.localite" varchar(20) not null,
"adr.pays" varchar(15) not null,
"langue" varchar(10) not null,
"appelation" varchar(4) ,
"sexe" char(1) ,
"n°telephone" numeric(15) not null,
"n°fax" numeric(15) ,
"n°gsm" numeric(15) ,
"date de naissance" date not null,
"etat civil" varchar(15) ,
"profession" varchar(25) ,
"nationalite" varchar(25) ,
"remarque" varchar(40) ,
"ID_Conducteur" integer ,
Primary Key ("ID_Assuré"),
UNIQUE ("ID_Conducteur"));
CREATE TABLE "Attacher" (
"ID_Assuré" varchar(15) not null,
"ID_Client" varchar(15) not null,
"relation" varchar(20) ,
Primary Key ("ID_Assuré", "ID_Client")); |
Partager