JC_ID numeric(4) not null, S_ID numeric(4) not null, BX_Date date null, BX_Date_End date null, BX_NR char(100) null, constraint PK_BIAOXIAN primary key clustered (JC_ID, S_ID) );
/*==============================================================*/ /* Index: BiaoXian_PK */
/*==============================================================*/ create unique clustered index BiaoXian_PK on BiaoXian ( JC_ID ASC, S_ID ASC );
/*==============================================================*/ /* Index: BiaoXian_FK */
/*==============================================================*/ create index BiaoXian_FK on BiaoXian ( JC_ID ASC );
/*==============================================================*/ /* Index: BiaoXian2_FK */
/*==============================================================*/ create index BiaoXian2_FK on BiaoXian ( S_ID ASC );
alter table BiaoXian
add constraint FK_BIAOXIAN_BIAOXIAN_JIANGCHE foreign key (JC_ID) references JiangCheng (JC_ID) on update restrict on delete restrict;
alter table BiaoXian
add constraint FK_BIAOXIAN_BIAOXIAN2_STU_INFO foreign key (S_ID) references Stu_Info (S_ID) on update restrict on delete restrict;
（9）Table 课程表
/*==============================================================*/ /* Table: KeCheng */