图书管理系统
来源:互联网 发布:路老膏方 常见网络骗 编辑:程序博客网 时间:2024/05/24 07:29
使用PowerDesigner建摸,图书管理系统。
下面是SQL脚本代码
USE [master]GO/****** Object: Database [LibDBTest] Script Date: 2016/6/27 20:23:17 ******/CREATE DATABASE [LibDBTest] CONTAINMENT = NONE ON PRIMARY ( NAME = N'LibDBTest', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\LibDBTest.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'LibDBTest_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\LibDBTest_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)GOALTER DATABASE [LibDBTest] SET COMPATIBILITY_LEVEL = 110GOIF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))beginEXEC [LibDBTest].[dbo].[sp_fulltext_database] @action = 'enable'endGOALTER DATABASE [LibDBTest] SET ANSI_NULL_DEFAULT OFF GOALTER DATABASE [LibDBTest] SET ANSI_NULLS OFF GOALTER DATABASE [LibDBTest] SET ANSI_PADDING OFF GOALTER DATABASE [LibDBTest] SET ANSI_WARNINGS OFF GOALTER DATABASE [LibDBTest] SET ARITHABORT OFF GOALTER DATABASE [LibDBTest] SET AUTO_CLOSE OFF GOALTER DATABASE [LibDBTest] SET AUTO_CREATE_STATISTICS ON GOALTER DATABASE [LibDBTest] SET AUTO_SHRINK OFF GOALTER DATABASE [LibDBTest] SET AUTO_UPDATE_STATISTICS ON GOALTER DATABASE [LibDBTest] SET CURSOR_CLOSE_ON_COMMIT OFF GOALTER DATABASE [LibDBTest] SET CURSOR_DEFAULT GLOBAL GOALTER DATABASE [LibDBTest] SET CONCAT_NULL_YIELDS_NULL OFF GOALTER DATABASE [LibDBTest] SET NUMERIC_ROUNDABORT OFF GOALTER DATABASE [LibDBTest] SET QUOTED_IDENTIFIER OFF GOALTER DATABASE [LibDBTest] SET RECURSIVE_TRIGGERS OFF GOALTER DATABASE [LibDBTest] SET DISABLE_BROKER GOALTER DATABASE [LibDBTest] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GOALTER DATABASE [LibDBTest] SET DATE_CORRELATION_OPTIMIZATION OFF GOALTER DATABASE [LibDBTest] SET TRUSTWORTHY OFF GOALTER DATABASE [LibDBTest] SET ALLOW_SNAPSHOT_ISOLATION OFF GOALTER DATABASE [LibDBTest] SET PARAMETERIZATION SIMPLE GOALTER DATABASE [LibDBTest] SET READ_COMMITTED_SNAPSHOT OFF GOALTER DATABASE [LibDBTest] SET HONOR_BROKER_PRIORITY OFF GOALTER DATABASE [LibDBTest] SET RECOVERY FULL GOALTER DATABASE [LibDBTest] SET MULTI_USER GOALTER DATABASE [LibDBTest] SET PAGE_VERIFY CHECKSUM GOALTER DATABASE [LibDBTest] SET DB_CHAINING OFF GOALTER DATABASE [LibDBTest] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GOALTER DATABASE [LibDBTest] SET TARGET_RECOVERY_TIME = 0 SECONDS GOEXEC sys.sp_db_vardecimal_storage_format N'LibDBTest', N'ON'GOUSE [LibDBTest]GO/****** Object: StoredProcedure [dbo].[overdueMoney] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate procedure [dbo].[overdueMoney] @WReturnId varchar(100) --创建一个存储过程asbegin declare @Id varchar(100) declare @d int declare WorkRId cursor for --声明游标WorKRId select WorkReturnId,Datediff(day,convert(int,BorrowDate),RReturnDate)-30 from BorrowBook,ReturnBook where BorrowBook.WorkBorrowId=ReturnBook.WorkReturnId open WorKRId fetch next from WorkId into @Id,@d while @@fetch_status=0 begin if @d>0 --计算借书日期和实际还书日期之间天数和30的差值,大于零说明超期,差值即为超期天数 update ReturnBook set Moneny=0.3*@d where WorkReturnId=@Id fetch next from WorkId into @Id,@d end close WorkRId deallocate WorkRIdreturn endGO/****** Object: Table [dbo].[AdminInfo] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[AdminInfo]( [AdminId] [varchar](20) NOT NULL, [Adm_AdminId] [varchar](20) NULL, [PassWord] [varchar](30) NOT NULL, [Name] [varchar](20) NOT NULL, [Sex] [varchar](10) NULL, [PhoneNum] [varchar](30) NOT NULL, [Email] [varchar](30) NOT NULL, [StarDate] [datetime] NOT NULL, [EndDate] [datetime] NOT NULL, [Note] [varchar](100) NULL, CONSTRAINT [PK_ADMININFO] PRIMARY KEY CLUSTERED ( [AdminId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[BookCollectInfo] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[BookCollectInfo]( [BookCollectId] [varchar](30) NOT NULL, [BookCollectName] [varchar](50) NOT NULL, [BookCollectFloor] [varchar](30) NOT NULL, [BookCollectNote] [varchar](100) NULL, CONSTRAINT [PK_BOOKCOLLECTINFO] PRIMARY KEY NONCLUSTERED ( [BookCollectId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[BookInfo] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[BookInfo]( [BookId] [varchar](50) NOT NULL, [BookCollectId] [varchar](30) NOT NULL, [IsLibaryId] [varchar](20) NOT NULL, [BookTypeId] [varchar](20) NOT NULL, [ISBN] [varchar](30) NOT NULL, [BookName] [varchar](50) NOT NULL, [BookAuthor] [varchar](30) NOT NULL, [BookPress] [varchar](50) NOT NULL, [PublicationDate] [datetime] NOT NULL, [Profiles] [varchar](200) NOT NULL, [BookNum] [varchar](20) NOT NULL, [BookInfoNote] [varchar](100) NULL, CONSTRAINT [PK_BOOKINFO] PRIMARY KEY NONCLUSTERED ( [BookId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[BookType] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[BookType]( [BookTypeId] [varchar](20) NOT NULL, [BookTypeName] [varchar](40) NOT NULL, [BookTypeNote] [varchar](100) NULL, CONSTRAINT [PK_BOOKTYPE] PRIMARY KEY NONCLUSTERED ( [BookTypeId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[BorrowBook] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[BorrowBook]( [WorkBorrowId] [varchar](100) NOT NULL, [BookId] [varchar](50) NOT NULL, [ReaderId] [varchar](20) NULL, [BorrowDate] [datetime] NOT NULL, [SReturnDate] [datetime] NOT NULL, [BookStateId] [varchar](20) NULL, [ReaderBookNote] [varchar](100) NULL, CONSTRAINT [PK_BORROWBOOK] PRIMARY KEY CLUSTERED ( [WorkBorrowId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[BorrowBookState] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[BorrowBookState]( [BookStateId] [varchar](20) NOT NULL, [BookStateName] [varchar](50) NOT NULL, [BookStateNote] [varchar](100) NULL, CONSTRAINT [PK_BORROWBOOKSTATE] PRIMARY KEY CLUSTERED ( [BookStateId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[CollegeInfo] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[CollegeInfo]( [CollegeId] [varchar](20) NOT NULL, [CollegeName] [varchar](50) NOT NULL, [CollegeProfiles] [varchar](200) NULL, [CollegeNote] [varchar](100) NULL, CONSTRAINT [PK_COLLEGEINFO] PRIMARY KEY NONCLUSTERED ( [CollegeId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[IsLibaryState] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[IsLibaryState]( [IsLibaryId] [varchar](20) NOT NULL, [IsLibaryName] [varchar](50) NOT NULL, [IsLibaryNote] [varchar](100) NULL, CONSTRAINT [PK_ISLIBARYSTATE] PRIMARY KEY NONCLUSTERED ( [IsLibaryId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[ManageBook] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ManageBook]( [ManageBookInfoId] [varchar](100) NOT NULL, [AdminId] [varchar](20) NOT NULL, [BookId] [varchar](50) NOT NULL, [ManageBookDate] [datetime] NOT NULL, [ManageBookNote] [varchar](100) NULL, CONSTRAINT [PK_MANAGEBOOK] PRIMARY KEY CLUSTERED ( [ManageBookInfoId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[ManageBorrow] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ManageBorrow]( [WorkBorrowInfoId] [varchar](100) NOT NULL, [AdminId] [varchar](20) NOT NULL, [ReaderId] [varchar](20) NULL, [ManageBorrowDate] [datetime] NOT NULL, [ManageBorrowNote] [varchar](100) NULL, CONSTRAINT [PK_MANAGEBORROW] PRIMARY KEY CLUSTERED ( [WorkBorrowInfoId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[ManageReader] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ManageReader]( [WorkReaderInfoId] [varchar](50) NOT NULL, [AdminId] [varchar](20) NOT NULL, [ReaderId] [varchar](20) NULL, [ManageReaderDate] [datetime] NOT NULL, [ManageReaderNote] [varchar](100) NULL, CONSTRAINT [PK_MANAGEREADER] PRIMARY KEY CLUSTERED ( [WorkReaderInfoId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[ReaderInfo] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ReaderInfo]( [ReaderId] [varchar](20) NOT NULL, [CollegeId] [varchar](20) NOT NULL, [PassWord] [varchar](30) NOT NULL, [Name] [varchar](20) NOT NULL, [Sex] [varchar](10) NULL, [PhoneNum] [varchar](30) NOT NULL, [Email] [varchar](30) NOT NULL, [StarDate] [date] NOT NULL, [EndDate] [date] NOT NULL, [Note] [varchar](100) NULL, CONSTRAINT [PK_READERINFO] PRIMARY KEY NONCLUSTERED ( [ReaderId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[ReturnBook] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ReturnBook]( [WorkReturnId] [varchar](100) NOT NULL, [BookId] [varchar](50) NOT NULL, [ReaderId] [varchar](20) NULL, [SReturnDate] [datetime] NOT NULL, [RReturnDate] [datetime] NOT NULL, [Moneny] [varchar](50) NULL, [ReturnBookNote] [varchar](100) NULL, CONSTRAINT [PK_RETURNBOOK] PRIMARY KEY CLUSTERED ( [WorkReturnId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: View [dbo].[BookInfo_view] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate view [dbo].[BookInfo_view] (索书号,书名,作者,出版社,图书简介,图书状态,馆藏信息,地点) as select BookId,BookName,BookAuthor,BookPress,Profiles,IsLibaryName,BookCollectName,BookCollectFloor from BookInfo,IsLibaryState,BookCollectInfo where BookInfo.IsLibaryId=IsLibaryState.IsLibaryId --连接图书信息表和图书状态表 and BookInfo.BookCollectId=BookCollectInfo.BookCollectId --图书信息表和馆藏信息表GO/****** Object: View [dbo].[BorrowBook_view] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate view [dbo].[BorrowBook_view] (读者编号,读者姓名,索书号,书名,作者,借阅时间,应还日期,图书状态) as select ReaderInfo.ReaderId,ReaderInfo.Name,BookInfo.BookId,BookInfo.BookName, BookAuthor,BorrowDate,SReturnDate,BookStateName from BorrowBook,ReaderInfo,BookInfo,BorrowBookState where BorrowBook.ReaderId =ReaderInfo.ReaderId and BorrowBook.BookId=BookInfo.BookId and BorrowBook.BookStateId=BorrowBookState.BookStateIdGO/****** Object: View [dbo].[HisBorrowBook_view] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate view [dbo].[HisBorrowBook_view] (读者编号,读者姓名,索书号,书名,作者,借阅时间,还书日期) as select ReaderInfo.ReaderId,ReaderInfo.Name,BookInfo.BookId,BookInfo.BookName, BookAuthor,RReturnDate,SReturnDate from ReturnBook,ReaderInfo,BookInfo where ReturnBook.ReaderId=ReaderInfo.ReaderId and ReturnBook.BookId=BookInfo.BookIdGO/****** Object: View [dbo].[ReaderInfo_view] Script Date: 2016/6/27 20:23:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate view [dbo].[ReaderInfo_view](读者编号,姓名,性别,学院,电话,邮箱,生效日期,失效日期) as select ReaderId,Name,Sex,CollegeName,PhoneNum,Email,StarDate,EndDate from ReaderInfo,CollegeInfo where ReaderInfo.CollegeId=CollegeInfo.CollegeIdGOSET ANSI_PADDING ONGO/****** Object: Index [Manage_Admin_FK] Script Date: 2016/6/27 20:23:17 ******/CREATE NONCLUSTERED INDEX [Manage_Admin_FK] ON [dbo].[AdminInfo]( [Adm_AdminId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOSET ANSI_PADDING ONGO/****** Object: Index [Book_CollectInfo_FK] Script Date: 2016/6/27 20:23:17 ******/CREATE NONCLUSTERED INDEX [Book_CollectInfo_FK] ON [dbo].[BookInfo]( [BookCollectId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOSET ANSI_PADDING ONGO/****** Object: Index [BookIsLibaryState_FK] Script Date: 2016/6/27 20:23:17 ******/CREATE NONCLUSTERED INDEX [BookIsLibaryState_FK] ON [dbo].[BookInfo]( [IsLibaryId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOSET ANSI_PADDING ONGO/****** Object: Index [BookType_FK] Script Date: 2016/6/27 20:23:17 ******/CREATE NONCLUSTERED INDEX [BookType_FK] ON [dbo].[BookInfo]( [BookTypeId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOSET ANSI_PADDING ONGO/****** Object: Index [Reader_Book_FK] Script Date: 2016/6/27 20:23:17 ******/CREATE NONCLUSTERED INDEX [Reader_Book_FK] ON [dbo].[BorrowBook]( [BookId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOSET ANSI_PADDING ONGO/****** Object: Index [Reader_Book2_FK] Script Date: 2016/6/27 20:23:17 ******/CREATE NONCLUSTERED INDEX [Reader_Book2_FK] ON [dbo].[BorrowBook]( [ReaderId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOSET ANSI_PADDING ONGO/****** Object: Index [ManageBook_FK] Script Date: 2016/6/27 20:23:17 ******/CREATE NONCLUSTERED INDEX [ManageBook_FK] ON [dbo].[ManageBook]( [AdminId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOSET ANSI_PADDING ONGO/****** Object: Index [ManageBorrow_FK] Script Date: 2016/6/27 20:23:17 ******/CREATE NONCLUSTERED INDEX [ManageBorrow_FK] ON [dbo].[ManageBorrow]( [AdminId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOSET ANSI_PADDING ONGO/****** Object: Index [ManageReader_FK] Script Date: 2016/6/27 20:23:17 ******/CREATE NONCLUSTERED INDEX [ManageReader_FK] ON [dbo].[ManageReader]( [AdminId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOSET ANSI_PADDING ONGO/****** Object: Index [ReaderCollege_FK] Script Date: 2016/6/27 20:23:17 ******/CREATE NONCLUSTERED INDEX [ReaderCollege_FK] ON [dbo].[ReaderInfo]( [CollegeId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOSET ANSI_PADDING ONGO/****** Object: Index [ReturnBook_FK] Script Date: 2016/6/27 20:23:17 ******/CREATE NONCLUSTERED INDEX [ReturnBook_FK] ON [dbo].[ReturnBook]( [BookId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOSET ANSI_PADDING ONGO/****** Object: Index [ReturnBook2_FK] Script Date: 2016/6/27 20:23:17 ******/CREATE NONCLUSTERED INDEX [ReturnBook2_FK] ON [dbo].[ReturnBook]( [ReaderId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOALTER TABLE [dbo].[AdminInfo] WITH CHECK ADD CONSTRAINT [FK_ADMININF_MANAGE_AD_ADMININF] FOREIGN KEY([Adm_AdminId])REFERENCES [dbo].[AdminInfo] ([AdminId])GOALTER TABLE [dbo].[AdminInfo] CHECK CONSTRAINT [FK_ADMININF_MANAGE_AD_ADMININF]GOALTER TABLE [dbo].[BookInfo] WITH CHECK ADD CONSTRAINT [FK_BOOKINFO_BOOK_COLL_BOOKCOLL] FOREIGN KEY([BookCollectId])REFERENCES [dbo].[BookCollectInfo] ([BookCollectId])GOALTER TABLE [dbo].[BookInfo] CHECK CONSTRAINT [FK_BOOKINFO_BOOK_COLL_BOOKCOLL]GOALTER TABLE [dbo].[BookInfo] WITH CHECK ADD CONSTRAINT [FK_BOOKINFO_BOOKISLIB_ISLIBARY] FOREIGN KEY([IsLibaryId])REFERENCES [dbo].[IsLibaryState] ([IsLibaryId])GOALTER TABLE [dbo].[BookInfo] CHECK CONSTRAINT [FK_BOOKINFO_BOOKISLIB_ISLIBARY]GOALTER TABLE [dbo].[BookInfo] WITH CHECK ADD CONSTRAINT [FK_BOOKINFO_BOOKTYPE_BOOKTYPE] FOREIGN KEY([BookTypeId])REFERENCES [dbo].[BookType] ([BookTypeId])GOALTER TABLE [dbo].[BookInfo] CHECK CONSTRAINT [FK_BOOKINFO_BOOKTYPE_BOOKTYPE]GOALTER TABLE [dbo].[BorrowBook] WITH CHECK ADD CONSTRAINT [FK_BORROWBO_READER_BO_BOOKINFO] FOREIGN KEY([BookId])REFERENCES [dbo].[BookInfo] ([BookId])GOALTER TABLE [dbo].[BorrowBook] CHECK CONSTRAINT [FK_BORROWBO_READER_BO_BOOKINFO]GOALTER TABLE [dbo].[BorrowBook] WITH CHECK ADD CONSTRAINT [FK_BORROWBO_READER_BO_READERIN] FOREIGN KEY([ReaderId])REFERENCES [dbo].[ReaderInfo] ([ReaderId])GOALTER TABLE [dbo].[BorrowBook] CHECK CONSTRAINT [FK_BORROWBO_READER_BO_READERIN]GOALTER TABLE [dbo].[BorrowBook] WITH CHECK ADD CONSTRAINT [FK_BORROWBO_REFERENCE_BORROWBO] FOREIGN KEY([BookStateId])REFERENCES [dbo].[BorrowBookState] ([BookStateId])GOALTER TABLE [dbo].[BorrowBook] CHECK CONSTRAINT [FK_BORROWBO_REFERENCE_BORROWBO]GOALTER TABLE [dbo].[ManageBook] WITH CHECK ADD CONSTRAINT [FK_MANAGEBO_MANAGEBOO_ADMININF] FOREIGN KEY([AdminId])REFERENCES [dbo].[AdminInfo] ([AdminId])GOALTER TABLE [dbo].[ManageBook] CHECK CONSTRAINT [FK_MANAGEBO_MANAGEBOO_ADMININF]GOALTER TABLE [dbo].[ManageBook] WITH CHECK ADD CONSTRAINT [FK_MANAGEBO_MANAGEBOO_BOOKINFO] FOREIGN KEY([BookId])REFERENCES [dbo].[BookInfo] ([BookId])GOALTER TABLE [dbo].[ManageBook] CHECK CONSTRAINT [FK_MANAGEBO_MANAGEBOO_BOOKINFO]GOALTER TABLE [dbo].[ManageBorrow] WITH CHECK ADD CONSTRAINT [FK_MANAGEBO_MANAGEBOR_ADMININF] FOREIGN KEY([AdminId])REFERENCES [dbo].[AdminInfo] ([AdminId])GOALTER TABLE [dbo].[ManageBorrow] CHECK CONSTRAINT [FK_MANAGEBO_MANAGEBOR_ADMININF]GOALTER TABLE [dbo].[ManageBorrow] WITH CHECK ADD CONSTRAINT [FK_MANAGEBO_MANAGEBOR_READERIN] FOREIGN KEY([ReaderId])REFERENCES [dbo].[ReaderInfo] ([ReaderId])GOALTER TABLE [dbo].[ManageBorrow] CHECK CONSTRAINT [FK_MANAGEBO_MANAGEBOR_READERIN]GOALTER TABLE [dbo].[ManageReader] WITH CHECK ADD CONSTRAINT [FK_MANAGERE_MANAGEREA_ADMININF] FOREIGN KEY([AdminId])REFERENCES [dbo].[AdminInfo] ([AdminId])GOALTER TABLE [dbo].[ManageReader] CHECK CONSTRAINT [FK_MANAGERE_MANAGEREA_ADMININF]GOALTER TABLE [dbo].[ManageReader] WITH CHECK ADD CONSTRAINT [FK_MANAGERE_MANAGEREA_READERIN] FOREIGN KEY([ReaderId])REFERENCES [dbo].[ReaderInfo] ([ReaderId])GOALTER TABLE [dbo].[ManageReader] CHECK CONSTRAINT [FK_MANAGERE_MANAGEREA_READERIN]GOALTER TABLE [dbo].[ReaderInfo] WITH CHECK ADD CONSTRAINT [FK_READERIN_READERCOL_COLLEGEI] FOREIGN KEY([CollegeId])REFERENCES [dbo].[CollegeInfo] ([CollegeId])GOALTER TABLE [dbo].[ReaderInfo] CHECK CONSTRAINT [FK_READERIN_READERCOL_COLLEGEI]GOALTER TABLE [dbo].[ReturnBook] WITH CHECK ADD CONSTRAINT [FK_RETURNBO_RETURNBOO_BOOKINFO] FOREIGN KEY([BookId])REFERENCES [dbo].[BookInfo] ([BookId])GOALTER TABLE [dbo].[ReturnBook] CHECK CONSTRAINT [FK_RETURNBO_RETURNBOO_BOOKINFO]GOALTER TABLE [dbo].[ReturnBook] WITH CHECK ADD CONSTRAINT [FK_RETURNBO_RETURNBOO_READERIN] FOREIGN KEY([ReaderId])REFERENCES [dbo].[ReaderInfo] ([ReaderId])GOALTER TABLE [dbo].[ReturnBook] CHECK CONSTRAINT [FK_RETURNBO_RETURNBOO_READERIN]GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理员编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminInfo', @level2type=N'COLUMN',@level2name=N'AdminId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理员编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminInfo', @level2type=N'COLUMN',@level2name=N'Adm_AdminId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminInfo', @level2type=N'COLUMN',@level2name=N'PassWord'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminInfo', @level2type=N'COLUMN',@level2name=N'Name'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminInfo', @level2type=N'COLUMN',@level2name=N'Sex'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminInfo', @level2type=N'COLUMN',@level2name=N'PhoneNum'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮箱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminInfo', @level2type=N'COLUMN',@level2name=N'Email'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生效日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminInfo', @level2type=N'COLUMN',@level2name=N'StarDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'失效日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminInfo', @level2type=N'COLUMN',@level2name=N'EndDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminInfo', @level2type=N'COLUMN',@level2name=N'Note'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理员信息实体继承与用户实体的属性' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminInfo'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书馆藏信息编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookCollectInfo', @level2type=N'COLUMN',@level2name=N'BookCollectId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书馆藏信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookCollectInfo', @level2type=N'COLUMN',@level2name=N'BookCollectName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'楼层编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookCollectInfo', @level2type=N'COLUMN',@level2name=N'BookCollectFloor'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookCollectInfo', @level2type=N'COLUMN',@level2name=N'BookCollectNote'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'馆藏信息,例如该馆在几楼,编号多少' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookCollectInfo'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检索号,主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookInfo', @level2type=N'COLUMN',@level2name=N'BookId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书馆藏信息编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookInfo', @level2type=N'COLUMN',@level2name=N'BookCollectId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookInfo', @level2type=N'COLUMN',@level2name=N'BookTypeId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ISBN号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookInfo', @level2type=N'COLUMN',@level2name=N'ISBN'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookInfo', @level2type=N'COLUMN',@level2name=N'BookName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书作者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookInfo', @level2type=N'COLUMN',@level2name=N'BookAuthor'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出版社' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookInfo', @level2type=N'COLUMN',@level2name=N'BookPress'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书出版日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookInfo', @level2type=N'COLUMN',@level2name=N'PublicationDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书简介' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookInfo', @level2type=N'COLUMN',@level2name=N'Profiles'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书馆藏数目' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookInfo', @level2type=N'COLUMN',@level2name=N'BookNum'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookInfo', @level2type=N'COLUMN',@level2name=N'BookInfoNote'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookInfo'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookType', @level2type=N'COLUMN',@level2name=N'BookTypeId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookType', @level2type=N'COLUMN',@level2name=N'BookTypeName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookType', @level2type=N'COLUMN',@level2name=N'BookTypeNote'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书类别表,存放各种类别信息,例如,科学类,人文类,历史类,工科类等信息。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookType'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'借阅工作号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BorrowBook', @level2type=N'COLUMN',@level2name=N'WorkBorrowId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检索号,主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BorrowBook', @level2type=N'COLUMN',@level2name=N'BookId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者编号,主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BorrowBook', @level2type=N'COLUMN',@level2name=N'ReaderId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'借阅日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BorrowBook', @level2type=N'COLUMN',@level2name=N'BorrowDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'应还日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BorrowBook', @level2type=N'COLUMN',@level2name=N'SReturnDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书状态编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BorrowBook', @level2type=N'COLUMN',@level2name=N'BookStateId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BorrowBook', @level2type=N'COLUMN',@level2name=N'ReaderBookNote'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书状态编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BorrowBookState', @level2type=N'COLUMN',@level2name=N'BookStateId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书状态名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BorrowBookState', @level2type=N'COLUMN',@level2name=N'BookStateName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BorrowBookState', @level2type=N'COLUMN',@level2name=N'BookStateNote'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用来存放当前在借图书信息。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BorrowBookState'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学院编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollegeInfo', @level2type=N'COLUMN',@level2name=N'CollegeId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学院名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollegeInfo', @level2type=N'COLUMN',@level2name=N'CollegeName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学院简介' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollegeInfo', @level2type=N'COLUMN',@level2name=N'CollegeProfiles'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollegeInfo', @level2type=N'COLUMN',@level2name=N'CollegeNote'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学院信息表,不同编号对应不同学院' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CollegeInfo'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用来存放图书状态 ,遗失,破损撤销等信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'IsLibaryState'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理图书工作号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageBook', @level2type=N'COLUMN',@level2name=N'ManageBookInfoId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理员编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageBook', @level2type=N'COLUMN',@level2name=N'AdminId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检索号,主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageBook', @level2type=N'COLUMN',@level2name=N'BookId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作图书时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageBook', @level2type=N'COLUMN',@level2name=N'ManageBookDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageBook', @level2type=N'COLUMN',@level2name=N'ManageBookNote'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理员对图书进行管理' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageBook'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理借阅信息工作号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageBorrow', @level2type=N'COLUMN',@level2name=N'WorkBorrowInfoId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理员编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageBorrow', @level2type=N'COLUMN',@level2name=N'AdminId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者编号,主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageBorrow', @level2type=N'COLUMN',@level2name=N'ReaderId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作借阅时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageBorrow', @level2type=N'COLUMN',@level2name=N'ManageBorrowDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageBorrow', @level2type=N'COLUMN',@level2name=N'ManageBorrowNote'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理员管理用户借阅情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageBorrow'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理读者信息工作号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageReader', @level2type=N'COLUMN',@level2name=N'WorkReaderInfoId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理员编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageReader', @level2type=N'COLUMN',@level2name=N'AdminId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者编号,主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageReader', @level2type=N'COLUMN',@level2name=N'ReaderId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageReader', @level2type=N'COLUMN',@level2name=N'ManageReaderDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageReader', @level2type=N'COLUMN',@level2name=N'ManageReaderNote'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'管理读者信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ManageReader'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者编号,主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderInfo', @level2type=N'COLUMN',@level2name=N'ReaderId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学院编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderInfo', @level2type=N'COLUMN',@level2name=N'CollegeId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderInfo', @level2type=N'COLUMN',@level2name=N'PassWord'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderInfo', @level2type=N'COLUMN',@level2name=N'Name'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderInfo', @level2type=N'COLUMN',@level2name=N'Sex'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderInfo', @level2type=N'COLUMN',@level2name=N'PhoneNum'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮箱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderInfo', @level2type=N'COLUMN',@level2name=N'Email'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生效日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderInfo', @level2type=N'COLUMN',@level2name=N'StarDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'失效日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderInfo', @level2type=N'COLUMN',@level2name=N'EndDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderInfo', @level2type=N'COLUMN',@level2name=N'Note'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作归还号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReturnBook', @level2type=N'COLUMN',@level2name=N'WorkReturnId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检索号,主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReturnBook', @level2type=N'COLUMN',@level2name=N'BookId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者编号,主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReturnBook', @level2type=N'COLUMN',@level2name=N'ReaderId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'应还日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReturnBook', @level2type=N'COLUMN',@level2name=N'SReturnDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'实际还书日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReturnBook', @level2type=N'COLUMN',@level2name=N'RReturnDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReturnBook', @level2type=N'COLUMN',@level2name=N'ReturnBookNote'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'归还图书,查询同一用户借阅表和归还表中图书差别就是暂未归还图书。归还表中图书就是借阅历史,两表之间差别就是当前借阅' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReturnBook'GOUSE [master]GOALTER DATABASE [LibDBTest] SET READ_WRITE GO
同样也能够从资源中下载 传送门
0 0
- 图书管理系统论文
- 图书管理系统(1)
- 图书管理系统(2)
- 图书管理系统(3)
- java-图书管理系统
- 图书管理系统
- 图书管理系统
- 简单图书管理系统
- 图书管理系统
- 图书管理系统
- 图书仓库管理系统
- 《图书管理系统》毕业论文
- 图书管理系统
- 图书管理系统
- 图书管理系统
- 图书管理系统
- 图书管理系统
- 图书管理系统
- Xcode 编译之Other link flag
- 携程工作感言(一)(6.30)
- 一个小白从零基础自学Android编程笔记之如何创建菜单
- DataUtilitls.java
- Servlet中获得JSP四大作用域的方法
- 图书管理系统
- 线段树学习小结
- android的样式与主题【普通窗体】
- 嵌入式透明传输应用
- Calendar 类详解
- fio开源工具使用
- mac上加入mysql指令
- iOS --- UIView中的坐标转换
- SVN 版本控制工具