/*ԱϢ*/
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]
