createtable.sql

自己做的影碟碟出租管理系统

use DiscRent
create table disc
(dname varchar(15)not null primary key,
role char(20) ,
area char(4),
time char(4),
type char(4),
currentnumber int check(currentnumber>=0 ),
totlenumber int check(totlenumber>=0),
price int check(price>0)
);
create table userinfo
(
userID varchar(10)not null primary key ,
userpassword char(10),
usercredit int

);
create table admininfo
(
adminID varchar(10) not null primary key,
adminpassword char(10),

);
create table rent
(
userID varchar(10) not null constraint r_f_p foreign key references userinfo(userID),
dname varchar(15) not null constraint r_f_p1 foreign key references disc(dname),
renttime datetime,
constraint r_p primary key(userID,dname)
);

select *from disc
select *from rent
select *from userinfo
select *from admininfo