library脚本文件.sql

来自「图书管理系统 带源码 文档」· SQL 代码 · 共 73 行

create database Library
go

create database Library
go

use Library
create table Book
(  BNo        varchar(10),
   BName      varchar(50)  not null,
   Type       varchar(10)  not null,
   Status     varchar(10)  not null,
   Author     varchar(40),
   Press      varchar(40),
   PublicDate varchar(20),
   ComeInDate varchar(10)  not null,
   CopyNum    int          not nuLL,
   About      varchar(200),
   primary key(BNo)
)
go

create table Admin
(  ANo       varchar(10),
   AName     varchar(20)   not null,
   PW        varchar(10)   not null,
   Sex       varchar(2)    not null,
   Tel       varchar(20),
   Email     varchar(50),
   Address   varchar(100),
   Demo      varchar(200),
   primary key(ANo)
)
go

create table Reader
(  RNo       varchar(10)   not null,
   PW        varchar(10)   not null,
   RName     varchar(20)   not null,
   Type      varchar(10)   not null,
   Sex       varchar(2),
   Address   varchar(50),
   Tel       varchar(20),
   Pay       float         not null,
   BrNum     int           not null,
   TotalNum  int           not null,
   primary key(RNo)
)
go


create table NewBook
(  NName varchar(50)  not null,
   Type  varchar(10)  not null,
   Author varchar(40),
   Press  varchar(40),
   PublicDate varchar(20),
   About varchar(200),
   primary key(NName)
)
go
use Library
create table Borrow
(  BNo       varchar(10),
   RNo       varchar(10),
   BrTime    varchar(10)   not null,
   MsTime    varchar(10)   not null,
   RtTime    varchar(10),
   primary key(BNo,RNo),
   foreign key(BNo) references Book ON UPDATE CASCADE ON DELETE CASCADE,
   foreign key(RNo) references Reader ON UPDATE CASCADE ON DELETE CASCADE
)
go