文件名称：课程设计—仓库设备管理
文件大小：246KB
文件格式：DOC
更新时间：2017-01-17 17:42:22
仓库设备管理
课程设计—仓库设备管理系统.doc 创建基本表的SQL代码： create table Equipment ( Eno char (4) primary key, Ename char(20) not null, Emade char(20) not null , Edate datetime ) create table Instorage ( Eno char (4) not null , Indate datetime not null , Usno char (4) not null ) create table Outstorage ( Eno char (4) not null , Outdate datetime not null , Usno char (4) not null ) create table Stock ( Eno char (4) not null , Buydate datetime not null , Econ char (4) not null check(Econ in('库存','出库','报废')), Outtime datetime ) create table Users ( Usno char(4) primary key, Usname char(10) not null, Uscode char(6) not null， Uscon char(2) not null check(Uscon in( '是','否')), ) alter table Instorage add constraint Eno1 foreign key (Eno) references Equipment(Eno) on update cascade on delete cascade alter table Outstorage add constraint Eno2 foreign key (Eno) references Equipment(Eno) on update cascade on delete cascade alter table Instorage add constraint Usno1 foreign key(Usno) references Users(Usno) on update cascade on delete cascade alter table Outstorage add constraint Usno2 foreign key(Usno) references Users(Usno) on update cascade on delete cascade alter table Stock add constraint Eno3 foreign key(Eno) references Equipment(Eno) on update cascade on delete cascade