序号 | 列名 | 数据类型 | 长度 | 小数位 | 标识 | 主键 | 外键 | 允许空 | 默认值 | 说明 |
1 | ID | int | 4 | 0 | 是 | 是 | 否 | |||
2 | p_name | nvarchar | 255 | 0 | 否 | 试卷名称 | ||||
3 | p_type | int | 4 | 0 | 否 | 出题方式:手工,随机 | ||||
4 | p_class | int | 4 | 0 | 是 | 科目分类 | ||||
5 | p_UseTime | float | 8 | 0 | 是 | 考试时间 | ||||
6 | p_Modus | int | 4 | 0 | 是 | 试卷形式:视频(没有时间限制),手工(需要考试时间) | ||||
7 | p_BeginTime | datetime | 8 | 3 | 是 | 有效时间:开始时间 | ||||
8 | p_endTime | datetime | 8 | 3 | 是 | 有效时间: 结束时间 | ||||
9 | p_Style | int | 4 | 0 | 是 | 试卷类型:1:考试,2:练习,3:作业 | ||||
10 | p_Remark | nvarchar | 500 | 0 | 是 | 说明 | ||||
11 | p_QuestionID | nvarchar | 500 | 0 | 是 | 试题ID | ||||
12 | p_rtype | int | 4 | 0 | 是 | 阅卷方式 | ||||
13 | QIDS | varchar | 2000 | 0 | 是 | 试题ID | ||||
14 | UserID | int | 4 | 0 | 是 | |||||
15 | QuestList | nvarchar | 4000 | 0 | 是 | QuestJson,存储临时分数与排序 | ||||
16 | TagKey | nvarchar | 1000 | 0 | 是 | 关键字 | ||||
17 | IsShare | int | 4 | 0 | 是 | 0:不共享,1:共享 | ||||
18 | Price | int | 4 | 0 | 是 | 价格 |
试卷表
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
TRUNCATE table ZL_Exam_Sys_Papers