DB_51aspx/系统表.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

create database dbLibrary
create table tb_Library(
library_Name varchar(50) not null primary key,
library_Time datetime not null,
library_Addr varchar(100),
library_Leader varchar(20),
library_Tel varchar(13),
library_Describe varchar(100))

create table tb_InfoType(
infoType_Id int not null identity(1,1) primary key ,
infoType_Name varchar(20) not null)

--select book_Number,book_Name,infoType_Name,book_Author,publishingCompany_Name,book_Price,bookShelf_Number,book_NowCount,book_AllCount from tb_Book where book_YuDing=1


create table tb_BookShelf(
bookShelf_Number varchar(10) not null primary key,
infoType_Id int foreign key references tb_InfoType(infoType_Id),
bookShelf_Addr varchar(50),
bookShelf_Comment varchar(100)) 

create table tb_PublishingCompany(
publishingCompany_Name varchar(50) not null primary key,
publishingCompany_User varchar(20),
publishingCompany_Tel varchar(15),
publishingCompany_Comment varchar(100))
--select * from tb_BookId
create table tb_BookId(
bookId_Id int not null identity(1,1) primary key,
bookId_Number varchar(20) not null,
bookId_CanUse bit not null default(1))

create table tb_EveryBookId(
everyBookId_Id int not null identity(1,1) primary key,
everyBookId_Number varchar(20) not null,
everyBookId_CanUse bit not null default(1))

create table tb_Book(
book_Number varchar(20) not null primary key,
book_Name varchar(50) not null,
infoType_Name varchar(20) not null,
book_Author varchar(20) not null,
publishingCompany_Name varchar(50) not null foreign key references tb_PublishingCompany(publishingCompany_Name),
book_Price money not null,
bookShelf_Number varchar(10) foreign key references tb_BookShelf(bookShelf_Number),
book_NowCount int default(0),
book_AllCount int ,
book_EnterTime datetime,
book_YuDing bit not null default(1),
book_CanLend bit not null default(0))

create table tb_BookYu(
bookYu_Id int not null identity(1,1) primary key,
book_Number varchar(20) not null foreign key references tb_Book(book_Number),
bookYu_Time datetime not null default(getdate()))

create table tb_BookZhu(
bookZhu_Id int not null identity(1,1) primary key,
book_Number varchar(20) not null foreign key references tb_Book(book_Number),