sql.txt

图书馆信息系统

/*管理员信息表*/
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]