表名：ZL_Examination












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1ExaIDint40是是 否 试卷ID
2StuUserNamenvarchar2550   是 考生姓名
3Stuidint40   是 考生ID
4Generatedatetime83   是 生成时间
5Starttimedatetime83   是 开始考试时间
6Endtimedatetime83   是 结束考试时间
7Qlistnvarchar5000   是 试题列表(ID)
8Totalint40   是 试卷总数
9Scoreint40   是 考试评分
10Reviewsnvarchar10000   是 考试评语
11Examinersnvarchar2550   是 阅卷人
12RoomIDint40   是 考场ID

简要说明：

在线考试来源表

GO
CREATE TABLE [dbo].[ZL_Examination](
[ExaID] [int] IDENTITY(1,1) NOT NULL,
[StuUserName] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[Stuid] [int] NULL,
[Generate] [datetime] NULL,
[Starttime] [datetime] NULL,
[Endtime] [datetime] NULL,
[Qlist] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[Total] [int] NULL,
[Score] [int] NULL,
[Reviews] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
[Examiners] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[RoomID] [int] NULL,
CONSTRAINT [PK_ZL_Examination] PRIMARY KEY CLUSTERED
(
[ExaID] ASC
) ON [PRIMARY]
) 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_Examination', @level2type=N'COLUMN',@level2name=N'ExaID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考生姓名' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Examination', @level2type=N'COLUMN',@level2name=N'StuUserName'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考生ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Examination', @level2type=N'COLUMN',@level2name=N'Stuid'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'生成时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Examination', @level2type=N'COLUMN',@level2name=N'Generate'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'开始考试时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Examination', @level2type=N'COLUMN',@level2name=N'Starttime'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'结束考试时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Examination', @level2type=N'COLUMN',@level2name=N'Endtime'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'试题列表(ID)' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Examination', @level2type=N'COLUMN',@level2name=N'Qlist'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'试卷总数' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Examination', @level2type=N'COLUMN',@level2name=N'Total'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考试评分' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Examination', @level2type=N'COLUMN',@level2name=N'Score'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考试评语' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Examination', @level2type=N'COLUMN',@level2name=N'Reviews'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'阅卷人' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Examination', @level2type=N'COLUMN',@level2name=N'Examiners'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考场ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Examination', @level2type=N'COLUMN',@level2name=N'RoomID'

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

detele from ZL_Examination

--注意：将删除整个表

drop table ZL_Examination

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

TRUNCATE table ZL_Examination