what about 2 primary key for another tables like table a and table b and table c has the key of a and key b how ?
CREATE TABLE INTERVENANTS (
NUMINTERVENTION INT,
NUMEMPLOYE INT,
DATEDEBUT DATE,
DATEFIN DATE,
CONSTRAINT pk_NUMINTERVENTION PRIMARY KEY(NUMINTERVENTION) REFERENCES INTERVENTIONS (NUMINTERVENTION),
CONSTRAINT pk_NUMEMPLOYE PRIMARY KEY(NUMEMPLOYE) REFERENCES EMPLOYE1 (NUMEMPLOYE )
);
New contributor
Khairy Abdallahi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.