1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| CREATE TABLE MEMBREA(
NUMMEMBRE NUMBER(4),
NOMMEMBRE CHAR (9) NOT NULL,
MAIL CHAR (20) ,
TELEPHONE NUMBER (3),
COTISATION NUMBER (2),
DATECOT DATE,
CHEFCHANTIER CHAR (3),
NUMCHANTIER NUMBER (4),
NUMMEMBREC NUMBER (4),
NUMDONATEUR NUMBER (4),
CONSTRAINT MEMBREA_FOREIGN_KEY FOREIGN KEY (NUMCHANTIER) REFERENCES CHANTIER (NUMCHANTIER),
CONSTRAINT MEMBREA_FOREIGN_KEY FOREIGN KEY (NUMMEMBREC) REFERENCES MEMBREC (NUMMEMBREC),
CONSTRAINT MEMBREA_FOREIGN_KEY FOREIGN KEY (NUMDONATEUR) REFERENCES DONATEUR (NUMDONATEUR),
CONSTRAINT MEMBREA_PRIMARY_KEY PRIMARY KEY (NUMMEMBRE));
INSERT INTO MEMBREA VALUES (4000,'MULLER','MULLER@WANADOO.FR',110,20,TO_DATE('01-05-2006','dd.mm.yyyy'),'OUI',1001,2003,3000);
INSERT INTO MEMBREA VALUES (4001,'DURAND','DURAND@WANADOO.FR',111,10,TO_DATE('12-08-2006','dd.mm.yyyy'),'NON',1000,2004,3001);
INSERT INTO MEMBREA VALUES (4002,'DUBOIS','DUBOIS@WANADOO.FR',112,5,TO_DATE('23-09-2006','dd.mm.yyyy'),'NON',1001,20 |
Partager