USE [LibraryDatabase]
GO
/****** Object: Table [dbo].[BookingInfo] Script Date: 2022/2/3 10:39:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BookingInfo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ReaderID] [nvarchar](50) NOT NULL,
[Title] [nvarchar](50) NOT NULL,
[BookCode] [nvarchar](50) NOT NULL,
[BookingDate] [nvarchar](100) NOT NULL,
[BookingPeople] [nvarchar](50) NOT NULL,
[BookingEndDate] [nvarchar](100) NOT NULL,
CONSTRAINT [PK_BookingInfo] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Books] Script Date: 2022/2/3 10:39:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Books](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Title] [nvarchar](200) NOT NULL,
[Author] [nvarchar](200) NOT NULL,
[ISBN] [nvarchar](50) NOT NULL,
[PublishingHouse] [nvarchar](200) NOT NULL,
[PublicationDate] [nvarchar](100) NOT NULL,
[BookType] [int] NOT NULL,
[BookCode] [nvarchar](50) NOT NULL,
[NumBorrowed] [int] NOT NULL,
[Picture] [nvarchar](50) NULL,
[IsBorrow] [int] NOT NULL,
[IsBooking] [int] NOT NULL,
CONSTRAINT [PK_Books_1] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[BookType] Script Date: 2022/2/3 10:39:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BookType](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Code] [nvarchar](50) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_BookType] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[HistoryBookingInfo] Script Date: 2022/2/3 10:39:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HistoryBookingInfo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ReaderID] [nvarchar](50) NOT NULL,
[BookingPeople] [nvarchar](50) NOT NULL,
[Title] [nvarchar](50) NOT NULL,
[BookCode] [nvarchar](50) NOT NULL,
[BookingDate] [nvarchar](100) NOT NULL,
[BorrowingBookDate] [nvarchar](100) NOT NULL,
[State] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_HistoryBookingInfo] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[HistoryLendInfo] Script Date: 2022/2/3 10:39:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HistoryLendInfo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ReaderID] [nvarchar](50) NOT NULL,
[ReaderName] [nvarchar](50) NOT NULL,
[Title] [nvarchar](50) NOT NULL,
[BookCode] [nvarchar](50) NOT NULL,
[ISBN] [nvarchar](50) NOT NULL,
[BegintTime] [nvarchar](100) NOT NULL,
[EndTime] [nvarchar](100) NOT NULL,
[ActualTime] [nvarchar](100) NOT NULL,
[IsOverdue] [int] NOT NULL,
[Remark] [nvarchar](200) NULL,
CONSTRAINT [PK_HistoryLendInfo] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[LendInfo] Script Date: 2022/2/3 10:39:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LendInfo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ReaderID] [nvarchar](50) NOT NULL,
[ReaderName] [nvarchar](50) NOT NU�
