pb做数据库课程设计关于仓库管理系统

create table dms.dbo.device_in ( code varchar(6) not null, in_date datetime not null, provider varchar(20) null, teleno varchar(11) null, in_number varchar(6) null, price varchar(6) null, buyer varchar(10) null, constraint in_date_pk primary key(in_date) ) go create table dms.dbo.device_out ( code varchar(6) not null, department varchar(20) null, out_date datetime not null, out_state varchar(1) null, out_person varchar(10) null, out_number varchar(6) null, taker varchar(10) null, usage varchar(20) null constraint out_date_pk primary key(out_date) ) go create table dms.dbo.device ( code varchar(6) not null, now_number varchar(6) null, high_number varchar(6) null, low_number varchar(6) null, total_number varchar(6) null, constraint device_code_pk primary key(code) ) go create table dms.dbo.device_need ( code varchar(10) not null, department varchar(10) not null, need_number varchar(6) null, begin_date datetime null, end_date datetime null ) go create table dms.dbo.device_return ( code varchar(6) not null, department varchar(20) null, return_date datetime not null, keeper varchar(10) null, return_number varchar(6) null, return_person varchar(10) null, constraint return_date_pk primary key(return_date) ) go create table dms.dbo.device_wantbuy ( code varchar(6) not null, now_number varchar(6) null, total_number varchar(6) null, max_number varchar(6) null, buy_number varchar(6) null, provider varchar(6) null, buy_date datetime not null, constraint wantnuy_date_pk primary key(buy_date) ) go create table dms.dbo.howdo ( d0_user varchar(10) not null, do_what varchar(40) not null, do_datetime datetime not null )