/*==============================================================*/ create index RenZhi_FK on Stu_Info ( ZW_ID ASC );
/*==============================================================*/ /* Index: Relationship_5_FK */
/*==============================================================*/ create index Relationship_5_FK on Stu_Info ( BJ_ID ASC );
alter table Stu_Info
add constraint FK_STU_INFO_RELATIONS_BANJI foreign key (BJ_ID) references BanJi (BJ_ID) on update restrict on delete restrict;
alter table Stu_Info
add constraint FK_STU_INFO_RENZHI_ZHIWU foreign key (ZW_ID) references ZhiWu (ZW_ID) on update restrict on delete restrict;
（4）Table 年级表
/*==============================================================*/ /* Table: NianJi */
/*==============================================================*/ create table NianJi (
NianJi_ID numeric(4) not null, BJ_ID numeric(4) null, NianJi char(10) null, ZuZhang numeric(4) null, BJ_BiYe smallint null, constraint PK_NIANJI primary key (NianJi_ID) );
/*==============================================================*/ /* Index: NianJi_PK */
/*==============================================================*/ create unique index NianJi_PK on NianJi ( NianJi_ID ASC );