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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
| CREATE TABLE tr_nature_cpt
( id_nature_cpt NUMBER NOT NULL
, nature_cpt VARCHAR(25) NOT NULL
, CONSTRAINT
pk_nature_cpt
PRIMARY KEY
( id_nature_cpt
)
, CONSTRAINT
uk_nature_cpt
UNIQUE
( nature_cpt
)
)
;
INSERT INTO tr_nature_cpt
( id_nature_cpt
, nature_cpt
)
SELECT 1, 'compte courant' FROM DUAL UNION
SELECT 2, 'compte epargne' FROM DUAL UNION
SELECT 3, 'compte depot' FROM DUAL
;
CREATE TABLE Compte
( num_cpt VARCHAR(10)
, nature_cpt NUMBER
, solde_cpt NUMBER(10)
, avoir_cpt NUMBER(10)
, code_ag VARCHAR(10)
, mat_emp VARCHAR(10)
, CONSTRAINT pk_Compte
PRIMARY KEY
( num_cpt
)
, CONSTRAINT fk_compte_nature_cpt
FOREIGN KEY
( id_nature_cpt
)
REFERENCES tr_nature_cpt
( id_nature_cpt
)
)
; |
Partager