表名:ZL_Exam_Sys_Papers












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40   
2p_namenvarchar2550    试卷名称
3p_typeint40    出题方式:手工,随机
4p_classint40    科目分类
5p_UseTimefloat80    考试时间
6p_Modusint40    试卷形式:视频(没有时间限制),手工(需要考试时间)
7p_BeginTimedatetime83    有效时间:开始时间
8p_endTimedatetime83    有效时间: 结束时间
9p_Styleint40    试卷类型:1:考试,2:练习,3:作业
10p_Remarknvarchar5000    说明
11p_QuestionIDnvarchar5000    试题ID
12p_rtypeint40    阅卷方式
13QIDSvarchar20000    试题ID
14UserIDint40     
15QuestListnvarchar40000    QuestJson,存储临时分数与排序
16TagKeynvarchar10000    关键字
17IsShareint40    0:不共享,1:共享
18Priceint40    价格

简要说明:

试卷表

GO
CREATE TABLE [dbo].[ZL_Exam_Sys_Papers](
[ID] [int] IDENTITY(1,1) NOT NULL,
[p_name] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NOT NULL,
[p_type] [int] NOT NULL,
[p_class] [int] NULL,
[p_UseTime] [float] NULL,
[p_Modus] [int] NULL,
[p_BeginTime] [datetime] NULL,
[p_endTime] [datetime] NULL,
[p_Style] [int] NULL,
[p_Remark] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[p_QuestionID] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[p_rtype] [int] NULL,
[QIDS] [varchar](2000) NULL,
[UserID] [int] NULL,
[QuestList] [NVarChar](4000) NULL,
[TagKey] [nvarchar](1000) NULL,
[IsShare] [int] NULL,
[Price] [int] NULL,
CONSTRAINT [PK_Exam_Sys_Papers] PRIMARY KEY CLUSTERED
([ID] ASC) ON [PRIMARY]) ON [PRIMARY]

GO
SET IDENTITY_INSERT [ZL_Exam_Sys_Papers] ON
INSERT [ZL_Exam_Sys_Papers] ([ID],[p_name],[p_type],[p_class],[p_UseTime],[p_Modus],[p_BeginTime],[p_endTime],[p_Style],[p_rtype],[QIDS],[UserID],[QuestList],[IsShare],[Price]) VALUES ( 1,N'2015年11月28日a2818in的组卷',1,2,0,0,N'2015/11/28 11:18:53',N'2116/11/28 11:18:53',2,0,N',1,2,3,4,30,29,28,24,40,39,38,34,',1,N'[{"id":1,"score":3,"order":0},{"id":2,"score":3,"order":1},{"id":3,"score":3,"order":2},{"id":4,"score":3,"order":3},{"id":24,"score":3,"order":4},{"id":28,"score":3,"order":5},{"id":29,"score":3,"order":6},{"id":30,"score":3,"order":7},{"id":34,"score":5,"order":8},{"id":39,"score":0,"order":9},{"id":40,"score":0,"order":10},{"id":38,"score":6,"order":11}]',1,0)
SET IDENTITY_INSERT [ZL_Exam_Sys_Papers] OFF

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

detele from ZL_Exam_Sys_Papers

--注意:将删除整个表

drop table ZL_Exam_Sys_Papers

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

TRUNCATE table ZL_Exam_Sys_Papers