book.sql

完整的数据库课程设计

create database BookSystem
go
use BookSystem
go
create table Users(Uid char(20) primary key,
                   Uname varchar(20) not null,
                   Upwd varchar(16),
                   Usex char(2) check (Usex in ('男','女')),
                   Uborn datetime,
                   Utel char(13),
                   Uemail varchar(30),
                   Uaddr varchar(50),
                   Uremark varchar(300)
                  )
create table Managers(Mid char(20) primary key,
                   Mname varchar(20) not null,
                   Mpwd varchar(16),
                   Msex char(2) check (Msex in ('男','女')),
                   Mborn datetime,
                   Mtel char(13),
                   Memail varchar(30),
                   Maddr varchar(50),
                   Mremark varchar(300)
                  )
create table Books(Bid char(10) primary key,
                   Bname varchar(50) not null,
                   Bclass varchar(30),
                   Bwriter varchar(50),
                   Bbookman varchar(26),
                   Bborn datetime,
                   Binstr varchar(500)
                  )
create table UB(Uid char(20),
                Bid char(10),
                Borrow_time datetime,
                Return_time datetime,
                Over_time smallint
                primary key (Uid,Bid),
                foreign key (Uid) references Users(Uid),
                foreign key (Bid) references Books(Bid)
               )