表名：ZL_Exroom












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1ExrIDint40是是 否 考场ID
2RoomNamenvarchar2550   是 房间名称
3Starttimedatetime83   是 开始考试时间
4Endtimedatetime83   是 结束考试时间
5ExaIDint40   是 模板试卷ID
6AddTimedatetime83   是 安排时间
7Stuidlistntext160   是 考生ID列表

简要说明：

在线考试学生表

GO
CREATE TABLE [dbo].[ZL_Exroom](
[ExrID] [int] IDENTITY(1,1) NOT NULL,
[RoomName] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[Starttime] [datetime] NULL,
[Endtime] [datetime] NULL,
[ExaID] [int] NULL,
[AddTime] [datetime] NULL,
[Stuidlist] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_ZL_Exroom] PRIMARY KEY CLUSTERED
(
[ExrID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考场ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exroom', @level2type=N'COLUMN',@level2name=N'ExrID'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'开始考试时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exroom', @level2type=N'COLUMN',@level2name=N'Starttime'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'结束考试时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exroom', @level2type=N'COLUMN',@level2name=N'Endtime'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'模板试卷ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exroom', @level2type=N'COLUMN',@level2name=N'ExaID'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'安排时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exroom', @level2type=N'COLUMN',@level2name=N'AddTime'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考生ID列表' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exroom', @level2type=N'COLUMN',@level2name=N'Stuidlist'

--注意：将清空全表数据

detele from ZL_Exroom

--注意：将删除整个表

drop table ZL_Exroom

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_Exroom