表名：ZL_ExAnswer












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1AnswerIDint40是是 否 答题ID
2ExaIDint40   是 试卷ID
3Stuidint40   是 考生ID
4Answernvarchar10000   是 考生答案
5AnswerTimedatetime83   是 答题时间
6Fractionint40   是 试题分数
7Scoresint40   是 所得分数
8Examinersnvarchar2550   是 阅卷人
9RoomIDint40   是 考场ID
10StuNamenvarchar2550   是 考生姓名

简要说明：

在线考试回复表

GO
CREATE TABLE [dbo].[ZL_ExAnswer](
[AnswerID] [int] IDENTITY(1,1) NOT NULL,
[ExaID] [int] NULL,
[Stuid] [int] NULL,
[Answer] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
[AnswerTime] [datetime] NULL,
[Fraction] [int] NULL,
[Scores] [int] NULL,
[Examiners] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[RoomID] [int] NULL,
[StuName] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_ZL_ExAnswer] PRIMARY KEY CLUSTERED
(
[AnswerID] 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_ExAnswer', @level2type=N'COLUMN',@level2name=N'AnswerID'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'试卷ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExAnswer', @level2type=N'COLUMN',@level2name=N'ExaID'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考生ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExAnswer', @level2type=N'COLUMN',@level2name=N'Stuid'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考生答案' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExAnswer', @level2type=N'COLUMN',@level2name=N'Answer'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'答题时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExAnswer', @level2type=N'COLUMN',@level2name=N'AnswerTime'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'试题分数' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExAnswer', @level2type=N'COLUMN',@level2name=N'Fraction'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'所得分数' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExAnswer', @level2type=N'COLUMN',@level2name=N'Scores'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'阅卷人' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExAnswer', @level2type=N'COLUMN',@level2name=N'Examiners'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考场ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExAnswer', @level2type=N'COLUMN',@level2name=N'RoomID'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考生姓名' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExAnswer', @level2type=N'COLUMN',@level2name=N'StuName'

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

detele from ZL_ExAnswer

--注意：将删除整个表

drop table ZL_ExAnswer

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

TRUNCATE table ZL_ExAnswer