录播教室预约系统(一)-数据库表

录播教室预约系统(一)-数据库表

 

数据库用的是mssql2005.

数据库表如下：

 

USE [RoomSchedule]
GO
/****** 对象:  Table [dbo].[ClassRoom]    脚本日期: 02/07/2015 22:41:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ClassRoom](
    [Id] [int] IDENTITY(1000,1) NOT NULL,
    [RoomName] [nvarchar](200) NULL,
    [DepID] [int] NULL,
    [Department] [nvarchar](200) NULL,
PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

ClassRoom表

USE [RoomSchedule]
GO
/****** 对象:  Table [dbo].[ClassRoomConfig]    脚本日期: 02/07/2015 22:42:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ClassRoomConfig](
    [Id] [int] IDENTITY(1000,1) NOT NULL,
    [DaySpan] [int] NULL,
    [StopTime] [int] NULL,
    [RoomID] [int] NULL,
    [RoomName] [nvarchar](200) NULL,
    [ModifyDate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

ClassRoomConfig表

USE [RoomSchedule]
GO
/****** 对象:  Table [dbo].[DepTable]    脚本日期: 02/07/2015 22:43:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DepTable](
    [Id] [int] IDENTITY(100,1) NOT NULL,
    [Department] [nvarchar](200) NULL,
PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

DepTable表

USE [RoomSchedule]
GO
/****** 对象:  Table [dbo].[Operate]    脚本日期: 02/07/2015 22:44:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Operate](
    [Id] [int] IDENTITY(10000,1) NOT NULL,
    [DateKey] [int] NULL,
    [UserID] [nvarchar](100) NULL,
    [UserName] [nvarchar](200) NULL,
    [Comments] [nvarchar](800) NULL,
    [StartTime] [int] NULL,
    [EndTime] [int] NULL,
    [Department] [nvarchar](100) NULL,
    [RoomID] [int] NULL,
    [RoomName] [nvarchar](100) NULL,
    [UpdateTime] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

Operate表

USE [RoomSchedule]
GO
/****** 对象:  Table [dbo].[OperateRecord]    脚本日期: 02/07/2015 22:44:26 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OperateRecord](
    [Id] [int] IDENTITY(10000,1) NOT NULL,
    [StartTime] [int] NULL,
    [EndTime] [int] NULL,
    [DateKey] [int] NULL,
    [RoomID] [int] NULL,
    [RoomName] [nvarchar](200) NULL,
    [Department] [nvarchar](100) NULL,
    [UserID] [nvarchar](100) NULL,
    [UserName] [nvarchar](200) NULL,
    [DeleteDate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

OperateRecord表

USE [RoomSchedule]
GO
/****** 对象:  Table [dbo].[Users]    脚本日期: 02/07/2015 22:44:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Users](
    [Id] [int] IDENTITY(10000,1) NOT NULL,
    [UserID] [nvarchar](200) NULL,
    [Name] [nvarchar](200) NULL,
    [Password] [nvarchar](200) NULL,
    [Declaring] [nvarchar](200) NULL CONSTRAINT [rcUsersdefaultDeclaring]  DEFAULT (''),
    [Status] [int] NULL CONSTRAINT [UsersdefaultStatus]  DEFAULT ((0)),
    [IsMale] [bit] NULL CONSTRAINT [UsersdefaultIsMale]  DEFAULT ((1)),
    [UserLevel] [int] NULL CONSTRAINT [UsersdefaultUserLevel]  DEFAULT ((1)),
    [Enabled] [bit] NULL CONSTRAINT [UsersdefaultEnabled]  DEFAULT ((1)),
    [RegisterTime] [datetime] NULL CONSTRAINT [UsersdefaultRegisterTime]  DEFAULT (getdate()),
    [LastLoginTime] [datetime] NULL CONSTRAINT [UsersdefaultLastLoginTime]  DEFAULT (getdate()),
    [DepID] [int] NULL,
    [Department] [nvarchar](100) NULL,
PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

Users表

 

www.cnblogs.com/networkcomms

www.networkcomms.cn