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
| create table CHEVAL (
ChevalId numeric(4) not null,
ChevalNom varchar(48) not null,
DateNaissance date not null,
constraint ID_CHEVAL_ID primary key (ChevalId));
create table COURSE (
CourseId numeric(4) not null,
CourseNom varchar(48) not null,
CourseDate date not null,
constraint ID_COURSE_ID primary key (CourseId));
create table JOCKEY (
JockeyId numeric(4) not null,
JockeyNom varchar(48) not null,
JockeyPrenom varchar(48) not null,
constraint ID_JOCKEY_ID primary key (JockeyId));
create table PARTICIPER (
CourseId numeric(4) not null,
ChevalId numeric(4) not null,
JockeyId numeric(4) not null,
Numero numeric(32) not null,
Poids numeric(3,2) not null,
constraint ID_PARTICIPER_ID primary key (CourseId, ChevalId),
constraint SID_PARTICIPER_1_ID unique (CourseId, JockeyId),
constraint SID_PARTICIPER_ID unique (CourseId, Numero));
alter table PARTICIPER add constraint REF_PARTI_JOCKE_FK
foreign key (JockeyId)
references JOCKEY;
alter table PARTICIPER add constraint REF_PARTI_COURS
foreign key (CourseId)
references COURSE;
alter table PARTICIPER add constraint REF_PARTI_CHEVA_FK
foreign key (ChevalId)
references CHEVAL; |
Partager