学生住宿管理系统(9)

学生住宿管理系统

StuHome char(10) StuBorth Datetime StuETime Datetime StuPerfect char(20) StuClass int RNo char(6) DorNo smallint

not null,

not null, not null, not null, not null, not null, not null,

DorCampus char(4) not null, DorLocation char(4) not null, primary key(StuNo),

foreign key(RNo) references Room(RNo),

foreign key(DorNo， DorCampus， DorLocation) references Dormitory(DorNo，DorCampus，DorLocation), check(StuClass>0 and StuClass<=10);

（6）宿舍楼物品出入基本信息表的建立：

create table ArticalInOut

StuNo char(9) not null, AIOArtical char(16) null, AIOPrin char(9) not null, AIODate datetime AIONo int

not null,

not null unique,

DorNo smallint not null, DorCampus char(4) not null, DorLocation char(4) not null, primary key(AIONo,AIODate),

foreign key(StuNo) references Student(StuNo), foreign key(AIOPrin) references Worker(WorNo),

foreign key(DorNo， DorCampus， DorLocation) references Dormitory(DorNo，DorCampus，DorLocation),

check(AIONo > 0);

（7）宿舍配备物品损坏基本信息表的建立：

create table FitmentDestruction

FitName char(16) StuNo char(9) RNo char(6) FDFitNum int DorNo smallint

not null unique, not null, not null, not null, not null,

DorCampus char(4) not null, DorLocation char(4) not null,

foreign key(DorNo， DorCampus， DorLocation) references Dormitory(DorNo，DorCampus，DorLocation), foreign key(FitName) references Fitment(FitName), foreign key(StuNo) references Student(StuNo), foreign key(RNo) references Room(RNo),