1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| CREATE TABLE "MEHDI"."AVANCE" (
"NUMAVANCE" VARCHAR2(7) NOT NULL primary key,
"MATRICULE" VARCHAR2(5) ,
"DIRECTION" VARCHAR2(4) ,
"NATUREAVCE" VARCHAR2(1),
"ETATAVCE" VARCHAR2(1) ,
"MONTANT" NUMBER(8) ,
"DTSAISIE" DATE ,
"CODECAISSE" VARCHAR2(2),
"CORPS" VARCHAR2(3) ,
"ECHELLE" VARCHAR2(2),
"DTBONS" DATE ,
"NUMBORD" VARCHAR2(6),
constraint F_K_MA foreign key (MATRICULE) references PERSONNEL(MATRICULE) ON DELETE CASCADE ON UPDATE CASCADE,
constraint F_K_CORPS1 foreign key (CORPS) references CORPS(CODE)ON DELETE CASCADE ON UPDATE CASCADE,
constraint F_D foreign key (DIRECTION) references DIRECTION(CODE)ON DELETE CASCADE ON UPDATE CASCADE); |
Partager