预约系统(⼀)数据库设计 预约系统(⼀)数据库设计 数据库sql server 2008 名称:DB_Date_Plan 表:T_bm,T_hys_plan,T_kryy_plan,T_meetingroom,T_room,T_time,T_userInfo 1 USE [DB_Date_Plan] 2 GO 3 /****** Object: Table [dbo].[T_userInfo] Script Date: 07/13/2017 08:38:16 ******/ 4 SET ANSI_NULLS ON 5 GO 6 SET QUOTED_IDENTIFIER ON 7 GO 8 CREATE TABLE [dbo].[T_userInfo]( 9 [id] [int] IDENTITY(1,1) NOT NULL, 10 [userName] [nvarchar](50) NULL, 11 [userPassword] [nvarchar](50) NULL, 12 [userEmail] [nvarchar](50) NULL, 13 [user_BM] [nvarchar](50) NULL, 14 [add_time] [datetime] NULL, 15 [user_FullName] [nvarchar](50) NULL, 16 [user_Power] [nvarchar](50) NULL, 17 CONSTRAINT [PK_T_userInfo] PRIMARY KEY CLUSTERED 18 ( 19 [id] ASC 20 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 21 ) ON [PRIMARY] 22 GO 23 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'⽤户权限,1-⽤户权限,2-管理员权限,3-超级权限' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_userInfo 24 GO 25 /****** Object: Table [dbo].[T_room] Script Date: 07/13/2017 08:38:16 ******/ 26 SET ANSI_NULLS ON 27 GO 28 SET QUOTED_IDENTIFIER ON 29 GO 30 CREATE TABLE [dbo].[T_room]( 31 [id] [bigint] IDENTITY(1,1) NOT NULL, 32 [room_id] [nvarchar](50) NULL, 33 [room_mc] [nvarchar](50) NULL, 34 [adder] [nvarchar](50) NULL, 35 [add_time] [datetime] NULL, 36 CONSTRAINT [PK_T_room] PRIMARY KEY CLUSTERED 37 ( 38 [id] ASC 39 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 40 ) ON [PRIMARY] 41 GO 42 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会议室编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_room', @level2type=N'COLUMN',@level2name 43 GO 44 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会议室名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_room', @level2type=N'CO