预约系统（一）数据库设计

最新推荐文章于 2024-07-05 09:26:08 发布

weixin_34128501

最新推荐文章于 2024-07-05 09:26:08 发布

阅读量3.1k

点赞数 1

文章标签：数据库数据结构与算法测试

原文链接：http://www.cnblogs.com/youguess/p/7158654.html

版权

这篇博客介绍了使用SQL Server 2008设计的一个预约系统数据库，包括了部门表T_bm、会议室预约详细表T_hys_plan、会议室表T_room、用户表T_userInfo等核心数据结构，阐述了如何构建预约系统的数据基础。

摘要由CSDN通过智能技术生成

数据库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', @level2type=N'COLUMN',@level2name=N'user_Power'
 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=N'room_id'
 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'COLUMN',@level2name=N'room_mc'
 45 GO
 46 /****** Object:  Table [dbo].[T_kryy_plan]    Script Date: 07/13/2017 08:38:16 ******/
 47 SET ANSI_NULLS ON
 48 GO
 49 SET QUOTED_IDENTIFIER ON
 50 GO
 51 CREATE TABLE [dbo].[T_kryy_plan](
 52     [id] [bigint] IDENTITY(1,1) NOT NULL,
 53     [adder] [nvarchar](50) NULL,
 54     [add_time] [datetime] NULL,
 55     [rq] [nvarchar](50) NULL,
 56     [sjd] [nvarchar](50) NULL,
 57     [yyr] [nvarchar](50) NULL,
 58     [yybm] [nvarchar](50) NULL,
 59     [in_time] [datetime] NULL,
 60     [out_time] [datetime] NULL,
 61     [krxm] [nvarchar](50) NULL,
 62     [krgs] [nvarchar](50) NULL,
 63     [mqzt] [nvarchar](50) NULL,
 64     [ztsj] [nvarchar](50) NULL,
 65     [bz] [nvarchar](50) NULL,
 66     [flax] [nvarchar](50) NULL,
 67     [time_begin] [nvarchar](50) NULL,
 68     [time_end] [nvarchar](50) NULL,
 69  CONSTRAINT [PK_T_kryy_plan] PRIMARY KEY CLUSTERED 
 70 (
 71     [id] ASC
 72 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 73 ) ON [PRIMARY]
 74 GO
 75 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预约日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'rq'
 76 GO
 77 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'时间段' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'sjd'
 78 GO
 79 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预约人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy_plan', @level2type=N'COLUMN',@level2name=N'yyr'
 80 GO
 81 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预约人部门' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_kryy