双鱼林图书信息管理系统学习版.zip

/*管理员信息表*/ CREATE TABLE [dbo].[admin] ( [adminUsername] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , /*管理员帐号*/ [adminPassword] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL /*管理员密码*/ ) ON [PRIMARY] /*读者类型信息表*/ CREATE TABLE [dbo].[readerType] ( [readerTypeId] [int] IDENTITY (1, 1) NOT NULL , /*类型编号*/ [readerTypeName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL , /*类型名称*/ [loanNum] [int] NULL , /*可借图书数目*/ [loanDays] [int] NULL , /*可借书天数*/ [continueDays] [int] NULL /*可续借书天数*/ ) ON [PRIMARY] /*读者信息表*/ CREATE TABLE [dbo].[reader] ( [readerId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , /*读者编号*/ [readerPassword] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL , /*读者密码*/ [readerName] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL , /*读者姓名*/ [readerSex] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL , /*读者性别*/ [readerBirthday] [datetime] NULL , /*读者生日*/ [readerTypeId] [int] NULL , /*读者类型*/ [readerPhone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , /*读者电话*/ [readerEmail] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , /*读者Email*/ [readerAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , /*读者地址*/ [readerPhotoUrl] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , /*读者个人照片路径*/ [readerMemo] [ntext] COLLATE Chinese_PRC_CI_AS NULL /*附加信息*/ ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /*图书类别信息*/ CREATE TABLE [dbo].[bookType] ( [bookTypeId] [int] IDENTITY (1, 1) NOT NULL , /*图书类别编号*/ [bookTypeName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL /*图书类别名称*/ ) ON [PRIMARY] /*图书信息表*/ CREATE TABLE [dbo].[books] ( [bookId] [int] IDENTITY (1, 1) NOT NULL , /*图书编号*/ [bookName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL , /*图书名称*/ [bookTypeId] [int] NULL , /*图书类别编号*/ [author] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , /*作者*/ [publishing] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , /*出版社*/ [bookMoney] [float] NULL , /*定价*/ [bookNum] int NULL , /*图书数量*/ [introduction] [text] COLLATE Chinese_PRC_CI_AS NULL /*介绍*/ ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /*图书借用信息表*/ CREATE TABLE [dbo].[loan] ( [loanId] [int] IDENTITY (1, 1) NOT NULL , /*借用编号*/ [readerId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , /*读者编号*/ [bookId] [int] NULL , /*图书编号*/ [borrowTime] [datetime] NULL , /*借阅时间*/ [returnTime] [datetime] NULL , /*归还时间*/ [isReturn] [int] NULL , /*是否已经归还*/ [continueBorrowTime] [datetime] NULL , /*续借时间*/ [isContinue] [int] NULL /*是否续借*/ ) ON [PRIMARY]