1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| CREATE TABLE REPRESENTATION
(
PphyId INT NOT NULL,
PmorId INT NOT NULL,
FonctionId INT NOT NULL,
DateDebut DATETIME NOT NULL
, CONSTRAINT REPRESENTATION_PK PRIMARY KEY (PphyId, PmorId, FonctionId)
, CONSTRAINT REPRESENTATION_P_PHYSIQUE_FK FOREIGN KEY (PphyId)
REFERENCES P_PHYSIQUE
, CONSTRAINT REPRESENTATION_MANDAT_FK FOREIGN KEY (PmorId, FonctionId)
REFERENCES MANDAT
) ;
INSERT INTO REPRESENTATION (PphyId, PmorId, FonctionId, DateDebut) VALUES (1, 2, 1, '2013-09-03') ;
INSERT INTO REPRESENTATION (PphyId, PmorId, FonctionId, DateDebut) VALUES (1, 4, 4, '2013-10-01') ;
INSERT INTO REPRESENTATION (PphyId, PmorId, FonctionId, DateDebut) VALUES (3, 4, 4, '2013-11-01') ;
INSERT INTO REPRESENTATION (PphyId, PmorId, FonctionId, DateDebut) VALUES (5, 2, 3, '2013-11-02') ;
INSERT INTO REPRESENTATION (PphyId, PmorId, FonctionId, DateDebut) VALUES (5, 2, 2, '2013-11-02') ;
INSERT INTO REPRESENTATION (PphyId, PmorId, FonctionId, DateDebut) VALUES (1, 6, 1, '2013-09-03') ;
INSERT INTO REPRESENTATION (PphyId, PmorId, FonctionId, DateDebut) VALUES (9, 8, 5, '2013-09-21') ;
INSERT INTO REPRESENTATION (PphyId, PmorId, FonctionId, DateDebut) VALUES (11, 8, 5, '2013-09-21') ;
SELECT ''AS REPRESENTATION,* FROM REPRESENTATION ; |
Partager