1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| create table CompteEnBanque (NumCompte number(20),
SoldeCompte number(30),
Decouvert_autoris number(30),
Date_commande_chequier varchar2(50),
Num_Client number(20),
Type varchar2(20),
constraint CEB_pk primary key (numcompte),
constraint CEB_FK Foreign Key (Num_Client) references Client(Num_Client),
constraint CEB_spec CHECK (Type In ('CompteEpargne','CompteCourant'))
);
create table CompteEpargne (NumCompte number(20),
prime number(30),
constraint CE_pk primary key (numcompte),
constraint CE_FK Foreign Key (NumCompte) references CompteEnBanque(NumCompte)
on delete cascade);
create table CompteCourant (NumCompte number(20),
NumCarte number(30),
Code number(30),
constraint CC_pk primary key (numcompte),
constraint CC_fk Foreign Key (NumCompte) references CompteEnBanque(NumCompte)
on delete cascade); |
Partager