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