HB_RTGK
/
sicuan_lims
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
sicuan_lims/sql/init_sql/microservices/0.5.0/train_sqlserver(培训考核).txt

1892 lines
58 KiB
Plaintext
Raw Permalink Blame History

-- --------------------------------------- 2020-03-21 zhangpf begin -----------------
CREATE TABLE [dbo].[t_core_train_plan] (
[ID] bigint NOT NULL,
[TRAINCATEGORY] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[TRAINSCOPE] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[THEME] nvarchar(540) COLLATE Chinese_PRC_CI_AS NULL,
[LECTURER] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL,
[TRAINTIME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL,
[REMARK] nvarchar(540) COLLATE Chinese_PRC_CI_AS NULL,
[STATUS] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[PROCESSSTATUS] nvarchar(18) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDTIME] datetime2(7) NULL,
[CREATEDBYORGID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYORGNAME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL
)
GO
ALTER TABLE [dbo].[t_core_train_plan] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训类型',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'TRAINCATEGORY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'内部/外部(培训范围)',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'TRAINSCOPE'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训主题',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'THEME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训讲师',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'LECTURER'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'TRAINTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'备注说明',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'REMARK'
GO
EXEC sp_addextendedproperty
'MS_Description', N'状态(未提交,审核中,已退回,待实施,已实施)',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'STATUS'
GO
EXEC sp_addextendedproperty
'MS_Description', N'流程状态',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'PROCESSSTATUS'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'CREATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'CREATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'CREATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'CREATEDBYORGID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan',
'COLUMN', N'CREATEDBYORGNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训计划',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan'
GO
ALTER TABLE [dbo].[t_core_train_plan] ADD CONSTRAINT [PK_CORE_TRAIN_PLAN] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_core_train_plan_user] (
[ID] bigint NOT NULL,
[TRAINPLANID] bigint NULL,
[USERID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[USERNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDTIME] datetime2(7) NULL,
[CREATEDBYORGID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYORGNAME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL
)
GO
ALTER TABLE [dbo].[t_core_train_plan_user] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan_user',
'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训计划ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan_user',
'COLUMN', N'TRAINPLANID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训计划培训参与人员编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan_user',
'COLUMN', N'USERID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训计划培训参与人员名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan_user',
'COLUMN', N'USERNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan_user',
'COLUMN', N'CREATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan_user',
'COLUMN', N'CREATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan_user',
'COLUMN', N'CREATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan_user',
'COLUMN', N'CREATEDBYORGID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan_user',
'COLUMN', N'CREATEDBYORGNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训计划参与人员',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_plan_user'
GO
CREATE NONCLUSTERED INDEX [IDX_CORE_TRAIN_PLAN_USER_TRAINPLANID]
ON [dbo].[t_core_train_plan_user] (
[TRAINPLANID] ASC
)
GO
ALTER TABLE [dbo].[t_core_train_plan_user] ADD CONSTRAINT [PK_CORE_PLAN_USER] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_CORE_TRAIN_PLAN', '1', '1');
INSERT INTO T_CORE_TABLE (ID,AUDITABLE,ATTACHMENT )
VALUES ('T_CORE_TRAIN_PLAN_USER', '0', '0');
INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN)
VALUES ('20200306001', 'T_CORE_TRAIN_PLAN_USER', 'T_CORE_TRAIN_PLAN', 'TRAINPLANID');
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG(ID, NAME, TITLE, CATEGORY, URL, WIDTH)
VALUES (NEXT VALUE FOR SEQ_CORE, '培训计划', '培训计划', 'train-plan', '/secure/core/module/train/train-plans/page/choose-list', '');
INSERT INTO T_CORE_MENU_EXT(ID, SERVICENAME, TABLENAME, TYPE, ENABLE, EXT)
VALUES ('9323', '培训计划', 'T_CORE_TRAIN_PLAN', 'audit_def', '1', NULL);
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
VALUES ('coreTrainCategory', '培训类型', 'biz', NULL, '100', NULL, NULL, NULL, NULL);
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '安全培训', 'coreTrainCategory', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'safetyTraining');
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '理论培训', 'coreTrainCategory', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'theoreticalTraining');
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
VALUES ('coreTrainScope', '内部/外部', 'sys', NULL, '101', NULL, NULL, NULL, NULL);
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '内部', 'coreTrainScope', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'internal');
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '外部', 'coreTrainScope', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'external');
INSERT INTO t_core_menu (ID, MENUNAME, HREF, PARENTID, ORDERNO, MENUINITNAME, ICON, TODOICON)
VALUES ('98', '培训考核', NULL, NULL, '98', '培训考核', '017.svg', '');
INSERT INTO t_core_menu (ID, MENUNAME, HREF, PARENTID, ORDERNO, MENUINITNAME, ICON, TODOICON)
VALUES ('9801', '培训计划管理', '/secure/core/module/train/train-plans/page/edit-list', '98', '9801', '培训计划编制列表', '005.svg', '');
INSERT INTO t_core_menu (ID, MENUNAME, HREF, PARENTID, ORDERNO, MENUINITNAME, ICON, TODOICON)
VALUES ('9802', '培训计划审核', '/secure/core/module/train/train-plans/page/audit-list?currentStatusCode=approve', '98', '9802', '培训计划编制列表', '022.svg', '');
CREATE TABLE [dbo].[t_core_train] (
[ID] bigint NOT NULL,
[TRAINPLANID] bigint NULL,
[TRAINMETHOD] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[LOCATION] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL,
[TRAINTIME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL,
[TRAININGMATERIAL] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL,
[ASSESSMENTMETHOD] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[EXAMID] bigint NULL,
[EVALUATION] nvarchar(540) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDTIME] datetime2(7) NULL,
[CREATEDBYORGID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYORGNAME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDFLAG] nvarchar(1) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDTIME] datetime2(7) NULL
)
GO
ALTER TABLE [dbo].[t_core_train] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训计划ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'TRAINPLANID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训方式',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'TRAINMETHOD'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训地点',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'LOCATION'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'TRAINTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训教材',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'TRAININGMATERIAL'
GO
EXEC sp_addextendedproperty
'MS_Description', N'考核方式',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'ASSESSMENTMETHOD'
GO
EXEC sp_addextendedproperty
'MS_Description', N'试卷ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'EXAMID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'考核效果评价',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'EVALUATION'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'CREATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'CREATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'CREATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'CREATEDBYORGID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'CREATEDBYORGNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用标志',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'ACTIVATEDFLAG'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用人ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'ACTIVATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'ACTIVATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_train',
'COLUMN', N'ACTIVATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训实施',
'SCHEMA', N'dbo',
'TABLE', N't_core_train'
GO
CREATE NONCLUSTERED INDEX [IDX_CORE_TRAIN_TRAINPLANID]
ON [dbo].[t_core_train] (
[TRAINPLANID] ASC
)
GO
CREATE NONCLUSTERED INDEX [IDX_CORE_TRAIN_EXAMID]
ON [dbo].[t_core_train] (
[EXAMID] ASC
)
GO
ALTER TABLE [dbo].[t_core_train] ADD CONSTRAINT [PK_CORE_TRAIN] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_core_train_user] (
[ID] bigint NOT NULL,
[TRAINID] bigint NULL,
[USERID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[USERNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDTIME] datetime2(7) NULL,
[CREATEDBYORGID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYORGNAME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDFLAG] nvarchar(1) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDTIME] datetime2(7) NULL,
[SCORE] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL
)
GO
ALTER TABLE [dbo].[t_core_train_user] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训实施ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'TRAINID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训参与人员编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'USERID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训参与人员名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'USERNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'CREATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'CREATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'CREATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'CREATEDBYORGID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'CREATEDBYORGNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用标志/签到标志',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'ACTIVATEDFLAG'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用人ID/签到人ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'ACTIVATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用人名称/签到人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'ACTIVATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用时间/签到时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'ACTIVATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'考核成绩',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user',
'COLUMN', N'SCORE'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训实施参与人员',
'SCHEMA', N'dbo',
'TABLE', N't_core_train_user'
GO
CREATE NONCLUSTERED INDEX [IDX_CORE_TRAIN_USER_TRAINID]
ON [dbo].[t_core_train_user] (
[TRAINID] ASC
)
GO
ALTER TABLE [dbo].[t_core_train_user] ADD CONSTRAINT [PK_CORE_TRAIN_USER] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_CORE_TRAIN', '0', '0');
INSERT INTO T_CORE_TABLE (ID,AUDITABLE,ATTACHMENT )
VALUES ('T_CORE_TRAIN_USER', '0', '0');
INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN)
VALUES ('20200306002', 'T_CORE_TRAIN_USER', 'T_CORE_TRAIN', 'TRAINID');
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
VALUES ('coreTrainMethod', '培训方式', 'sys', NULL, '100', NULL, NULL, NULL, NULL);
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, 'PPT课件', 'coreTrainMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'ppt');
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '实操', 'coreTrainMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'operation');
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '其他', 'coreTrainMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'other');
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
VALUES ('coreAssessmentMethod', '考核方式', 'sys', NULL, '101', NULL, NULL, NULL, NULL);
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '在线考试', 'coreAssessmentMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'testOnline');
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '笔试', 'coreAssessmentMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'writtenExamination');
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '实操', 'coreAssessmentMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'operation');
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '其他', 'coreAssessmentMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'other');
INSERT INTO t_core_menu (ID, MENUNAME, HREF, PARENTID, ORDERNO, MENUINITNAME, ICON, TODOICON)
VALUES ('9803', '培训实施', '/secure/core/module/train/trains/page/edit-list', '98', '9803', '培训实施编制列表', '046.svg', '');
INSERT INTO t_core_menu (ID, MENUNAME, HREF, PARENTID, ORDERNO, MENUINITNAME, ICON, TODOICON)
VALUES ('9804', '培训实施签到', '/secure/core/module/train/trains/page/search-list', '98', '9804', '培训实施查询列表', '008.svg', '');
CREATE TABLE [dbo].[t_core_exam_tmpl] (
[ID] bigint NOT NULL,
[TMPLNAME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL,
[SINGLECHOICEQTY] int NULL,
[SINGLECHOICESCORE] int NULL,
[MULTIPLECHOICEQTY] int NULL,
[MULTIPLECHOICESCORE] int NULL,
[JUDGEMENTQTY] int NULL,
[JUDGEMENTSCORE] int NULL,
[SHORTANSWERQTY] int NULL,
[SHORTANSWERSCORE] int NULL,
[TOTALSCORE] int NULL,
[CITATIONQTY] int NULL,
[CREATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDTIME] datetime2(7) NULL,
[CREATEDBYORGID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYORGNAME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDFLAG] nvarchar(1) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDTIME] datetime2(7) NULL
)
GO
ALTER TABLE [dbo].[t_core_exam_tmpl] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'试卷模板名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'TMPLNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'单选题个数',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'SINGLECHOICEQTY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'单选题分值(/个)',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'SINGLECHOICESCORE'
GO
EXEC sp_addextendedproperty
'MS_Description', N'多选题个数',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'MULTIPLECHOICEQTY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'多选题分值(/个)',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'MULTIPLECHOICESCORE'
GO
EXEC sp_addextendedproperty
'MS_Description', N'判断题个数',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'JUDGEMENTQTY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'判断题分值(/个)',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'JUDGEMENTSCORE'
GO
EXEC sp_addextendedproperty
'MS_Description', N'简答题个数',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'SHORTANSWERQTY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'简答题分值(/个)',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'SHORTANSWERSCORE'
GO
EXEC sp_addextendedproperty
'MS_Description', N'试卷总分',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'TOTALSCORE'
GO
EXEC sp_addextendedproperty
'MS_Description', N'引用次数',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'CITATIONQTY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'CREATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'CREATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'CREATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'CREATEDBYORGID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'CREATEDBYORGNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用标志',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'ACTIVATEDFLAG'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用人ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'ACTIVATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'ACTIVATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl',
'COLUMN', N'ACTIVATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'试卷模板',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_tmpl'
GO
ALTER TABLE [dbo].[t_core_exam_tmpl] ADD CONSTRAINT [PK_CORE_EXAM_TMPL] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_CORE_EXAM_TMPL', '0', '0');
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG(ID, NAME, TITLE, CATEGORY, URL, WIDTH)
VALUES (NEXT VALUE FOR SEQ_CORE, '试卷模板', '试卷模板', 'exam-tmpl', '/secure/core/module/train/exam-tmpls/page/choose-list', '');
INSERT INTO t_core_menu (ID, MENUNAME, HREF, PARENTID, ORDERNO, MENUINITNAME, ICON, TODOICON)
VALUES ('9805', '试卷模板', '/secure/core/module/train/exam-tmpls/page/edit-list', '98', '9805', '试卷模板编制列表', '029.svg', '');
CREATE TABLE [dbo].[t_core_question] (
[ID] bigint NOT NULL,
[QUESTIONCATEGORY] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[QUESTIONTYPE] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[QUESTIONCONTENT] nvarchar(540) COLLATE Chinese_PRC_CI_AS NULL,
[ANSWER] nvarchar(1080) COLLATE Chinese_PRC_CI_AS NULL,
[JUDGEMENTANSWER] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[QUESTIONTYPEORDERNO] int NULL,
[LASTUPDATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[LASTUPDATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[LASTUPDATEDTIME] datetime2(7) NULL,
[LASTSUSPENDEDFLAG] nvarchar(1) COLLATE Chinese_PRC_CI_AS NULL,
[LASTSUSPENDEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[LASTSUSPENDEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[LASTSUSPENDEDTIME] datetime2(7) NULL,
[ACTIVATEDFLAG] nvarchar(1) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDTIME] datetime2(7) NULL,
[CREATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDTIME] datetime2(7) NULL,
[CREATEDBYORGID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYORGNAME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL
)
GO
ALTER TABLE [dbo].[t_core_question] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'题目类别',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'QUESTIONCATEGORY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'题目类型',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'QUESTIONTYPE'
GO
EXEC sp_addextendedproperty
'MS_Description', N'题目内容',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'QUESTIONCONTENT'
GO
EXEC sp_addextendedproperty
'MS_Description', N'答案',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'ANSWER'
GO
EXEC sp_addextendedproperty
'MS_Description', N'判断题答案',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'JUDGEMENTANSWER'
GO
EXEC sp_addextendedproperty
'MS_Description', N'题目类型排序号',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'QUESTIONTYPEORDERNO'
GO
EXEC sp_addextendedproperty
'MS_Description', N'维护人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'LASTUPDATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'维护人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'LASTUPDATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'维护时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'LASTUPDATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'注销标志(逻辑删除标志)(0-正常,1-停用) 默认为0',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'LASTSUSPENDEDFLAG'
GO
EXEC sp_addextendedproperty
'MS_Description', N'注销人ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'LASTSUSPENDEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'注销人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'LASTSUSPENDEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'注销时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'LASTSUSPENDEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用标志',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'ACTIVATEDFLAG'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用人ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'ACTIVATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'ACTIVATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'ACTIVATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'CREATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'CREATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'CREATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'CREATEDBYORGID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_question',
'COLUMN', N'CREATEDBYORGNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'题目',
'SCHEMA', N'dbo',
'TABLE', N't_core_question'
GO
ALTER TABLE [dbo].[t_core_question] ADD CONSTRAINT [PK_CORE_QUESTION] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_core_question_opt] (
[ID] bigint NOT NULL,
[QUESTIONID] bigint NULL,
[OPTCODE] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL,
[OPTCONTENT] nvarchar(540) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDTIME] datetime2(7) NULL,
[CREATEDBYORGID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYORGNAME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL
)
GO
ALTER TABLE [dbo].[t_core_question_opt] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N't_core_question_opt',
'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'题目ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_question_opt',
'COLUMN', N'QUESTIONID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'序号',
'SCHEMA', N'dbo',
'TABLE', N't_core_question_opt',
'COLUMN', N'OPTCODE'
GO
EXEC sp_addextendedproperty
'MS_Description', N'选项内容',
'SCHEMA', N'dbo',
'TABLE', N't_core_question_opt',
'COLUMN', N'OPTCONTENT'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_question_opt',
'COLUMN', N'CREATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_question_opt',
'COLUMN', N'CREATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_question_opt',
'COLUMN', N'CREATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_question_opt',
'COLUMN', N'CREATEDBYORGID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_question_opt',
'COLUMN', N'CREATEDBYORGNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'题目选项',
'SCHEMA', N'dbo',
'TABLE', N't_core_question_opt'
GO
CREATE NONCLUSTERED INDEX [IDX_CORE_QUESTION_OPT_QUESTIONID]
ON [dbo].[t_core_question_opt] (
[QUESTIONID] ASC
)
GO
ALTER TABLE [dbo].[t_core_question_opt] ADD CONSTRAINT [PK_CORE_QUESTION_OPT] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_CORE_QUESTION', '0', '0');
INSERT INTO T_CORE_TABLE (ID,AUDITABLE,ATTACHMENT )
VALUES ('T_CORE_QUESTION_OPT', '0', '0');
INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN)
VALUES ('20200306003', 'T_CORE_QUESTION_OPT', 'T_CORE_QUESTION', 'QUESTIONID');
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
VALUES ('coreQuestionCategory', '题目类别', 'biz', NULL, '100', NULL, NULL, NULL, NULL);
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '安全培训', 'coreQuestionCategory', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'safetyTraining');
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '理论培训', 'coreQuestionCategory', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'theoreticalTraining');
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
VALUES ('coreQuestionType', '题目类型', 'sys', NULL, '100', NULL, NULL, NULL, NULL);
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '单选题', 'coreQuestionType', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'singleChoice');
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '多选题', 'coreQuestionType', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'multipleChoice');
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '判断题', 'coreQuestionType', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'judgement');
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '简答题', 'coreQuestionType', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'shortAnswer');
INSERT INTO t_core_menu (ID, MENUNAME, HREF, PARENTID, ORDERNO, MENUINITNAME, ICON, TODOICON)
VALUES ('9806', '题库管理', '/secure/core/module/train/questions/page/edit-list', '98', '9806', '题目编制列表', '066.svg', '');
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
VALUES ('coreJudgementOption', '判断题选项', 'sys', NULL, '100', NULL, NULL, NULL, NULL);
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '对', 'coreJudgementOption', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'correct');
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '错', 'coreJudgementOption', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'incorrect');
CREATE TABLE [dbo].[t_core_exam] (
[ID] bigint NOT NULL,
[EXAMNAME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL,
[QUESTIONMETHOD] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[EXAMTMPLID] bigint NULL,
[EXAMBEGINTIME] datetime2(7) NULL,
[EXAMENDTIME] datetime2(7) NULL,
[EXAMDURATION] int NULL,
[EXAMCATEGORY] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[SINGLECHOICEQTY] int NULL,
[MULTIPLECHOICEQTY] int NULL,
[JUDGEMENTQTY] int NULL,
[SHORTANSWERQTY] int NULL,
[TMPLSINGLECHOICEQTY] int NULL,
[TMPLMULTIPLECHOICEQTY] int NULL,
[TMPLJUDGEMENTQTY] int NULL,
[TMPLSHORTANSWERQTY] int NULL,
[LASTUPDATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[LASTUPDATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[LASTUPDATEDTIME] datetime2(7) NULL,
[ACTIVATEDFLAG] nvarchar(1) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDTIME] datetime2(7) NULL,
[CREATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDTIME] datetime2(7) NULL,
[CREATEDBYORGID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYORGNAME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL
)
GO
ALTER TABLE [dbo].[t_core_exam] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'试卷名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'EXAMNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'组卷方式',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'QUESTIONMETHOD'
GO
EXEC sp_addextendedproperty
'MS_Description', N'试卷模板ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'EXAMTMPLID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'考试开始时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'EXAMBEGINTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'考试结束时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'EXAMENDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'考试时长',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'EXAMDURATION'
GO
EXEC sp_addextendedproperty
'MS_Description', N'试卷类别',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'EXAMCATEGORY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'单选题个数',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'SINGLECHOICEQTY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'多选题个数',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'MULTIPLECHOICEQTY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'判断题个数',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'JUDGEMENTQTY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'简答题个数',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'SHORTANSWERQTY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'模板单选题个数',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'TMPLSINGLECHOICEQTY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'模板多选题个数',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'TMPLMULTIPLECHOICEQTY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'模板判断题个数',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'TMPLJUDGEMENTQTY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'模板简答题个数',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'TMPLSHORTANSWERQTY'
GO
EXEC sp_addextendedproperty
'MS_Description', N'维护人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'LASTUPDATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'维护人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'LASTUPDATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'维护时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'LASTUPDATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用标志',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'ACTIVATEDFLAG'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用人ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'ACTIVATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'ACTIVATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'ACTIVATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'CREATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'CREATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'CREATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'CREATEDBYORGID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam',
'COLUMN', N'CREATEDBYORGNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'试卷',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam'
GO
CREATE NONCLUSTERED INDEX [IDX_CORE_EXAM_EXAMTMPLID]
ON [dbo].[t_core_exam] (
[EXAMTMPLID] ASC
)
GO
ALTER TABLE [dbo].[t_core_exam] ADD CONSTRAINT [PK_CORE_EXAM] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_core_exam_question] (
[ID] bigint NOT NULL,
[QUESTIONID] bigint NULL,
[EXAMID] bigint NULL,
[CREATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDTIME] datetime2(7) NULL,
[CREATEDBYORGID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYORGNAME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL
)
GO
ALTER TABLE [dbo].[t_core_exam_question] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_question',
'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'题目ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_question',
'COLUMN', N'QUESTIONID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'试卷ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_question',
'COLUMN', N'EXAMID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_question',
'COLUMN', N'CREATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_question',
'COLUMN', N'CREATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_question',
'COLUMN', N'CREATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_question',
'COLUMN', N'CREATEDBYORGID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_question',
'COLUMN', N'CREATEDBYORGNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'试卷题目',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_question'
GO
CREATE NONCLUSTERED INDEX [IDX_CORE_EXAM_QUESTION_QUESTIONID]
ON [dbo].[t_core_exam_question] (
[QUESTIONID] ASC
)
GO
CREATE NONCLUSTERED INDEX [IDX_CORE_EXAM_QUESTION_EXAMID]
ON [dbo].[t_core_exam_question] (
[EXAMID] ASC
)
GO
ALTER TABLE [dbo].[t_core_exam_question] ADD CONSTRAINT [PK_CORE_EXAM_QUESTION] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_CORE_EXAM', '0', '0');
INSERT INTO T_CORE_TABLE (ID,AUDITABLE,ATTACHMENT )
VALUES ('T_CORE_EXAM_QUESTION', '0', '0');
INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN)
VALUES ('20200306004', 'T_CORE_EXAM_QUESTION', 'T_CORE_EXAM', 'EXAMID');
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
VALUES ('coreQuestionMethod', '组卷方式', 'sys', NULL, '100', NULL, NULL, NULL, NULL);
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '系统随机', 'coreQuestionMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'random');
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
VALUES (NEXT VALUE FOR SEQ_CORE, '人工组卷', 'coreQuestionMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'manual');
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG(ID, NAME, TITLE, CATEGORY, URL, WIDTH)
VALUES (NEXT VALUE FOR SEQ_CORE, '试卷', '试卷', 'exam', '/secure/core/module/train/exams/page/choose-list', '');
INSERT INTO t_core_menu (ID, MENUNAME, HREF, PARENTID, ORDERNO, MENUINITNAME, ICON, TODOICON)
VALUES ('9807', '试卷管理', '/secure/core/module/train/exams/page/edit-list', '98', '9807', '试卷编制列表', '055.svg', '');
CREATE TABLE [dbo].[t_core_exam_paper] (
[ID] bigint NOT NULL,
[EXAMID] bigint NULL,
[TRAINID] bigint NULL,
[ACTBEGINTIME] datetime2(7) NULL,
[ACTENDTIME] datetime2(7) NULL,
[SCORE] bigint NULL,
[USERID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[USERNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[STATUS] nvarchar(18) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDTIME] datetime2(7) NULL,
[CREATEDBYORGID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYORGNAME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDFLAG] nvarchar(1) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[ACTIVATEDTIME] datetime2(7) NULL
)
GO
ALTER TABLE [dbo].[t_core_exam_paper] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'试卷ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'EXAMID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'培训实施ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'TRAINID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'开始时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'ACTBEGINTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'结束时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'ACTENDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'考试成绩',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'SCORE'
GO
EXEC sp_addextendedproperty
'MS_Description', N'考卷用户Id',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'USERID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'考卷用户名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'USERNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'考试状态(draft-未考/done-已考)',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'STATUS'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'CREATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'CREATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'CREATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'CREATEDBYORGID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'CREATEDBYORGNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'阅卷完成标志',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'ACTIVATEDFLAG'
GO
EXEC sp_addextendedproperty
'MS_Description', N'阅卷人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'ACTIVATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'阅卷人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'ACTIVATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'启用时间/签到时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper',
'COLUMN', N'ACTIVATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'考卷',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper'
GO
ALTER TABLE [dbo].[t_core_exam_paper] ADD CONSTRAINT [PK_CORE_EXAM_PAPER] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_core_exam_paper_answer] (
[ID] bigint NOT NULL,
[EXAMID] bigint NULL,
[EXAMPAPERID] bigint NULL,
[EXAMQUESTIONID] bigint NULL,
[QUESTIONID] bigint NULL,
[ANSWER] nvarchar(1080) COLLATE Chinese_PRC_CI_AS NULL,
[JUDGEMENTANSWER] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[SCORE] bigint NULL,
[ORDERNO] int NULL,
[CREATEDBYID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYNAME] nvarchar(60) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDTIME] datetime2(7) NULL,
[CREATEDBYORGID] nvarchar(36) COLLATE Chinese_PRC_CI_AS NULL,
[CREATEDBYORGNAME] nvarchar(270) COLLATE Chinese_PRC_CI_AS NULL
)
GO
ALTER TABLE [dbo].[t_core_exam_paper_answer] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'试卷ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'EXAMID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'考卷ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'EXAMPAPERID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'试卷题目ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'EXAMQUESTIONID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'题目ID',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'QUESTIONID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'答案',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'ANSWER'
GO
EXEC sp_addextendedproperty
'MS_Description', N'判断题答案',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'JUDGEMENTANSWER'
GO
EXEC sp_addextendedproperty
'MS_Description', N'得分',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'SCORE'
GO
EXEC sp_addextendedproperty
'MS_Description', N'排序号',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'ORDERNO'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'CREATEDBYID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'CREATEDBYNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单时间',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'CREATEDTIME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位编码',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'CREATEDBYORGID'
GO
EXEC sp_addextendedproperty
'MS_Description', N'制单人单位名称',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer',
'COLUMN', N'CREATEDBYORGNAME'
GO
EXEC sp_addextendedproperty
'MS_Description', N'考卷答案',
'SCHEMA', N'dbo',
'TABLE', N't_core_exam_paper_answer'
GO
CREATE NONCLUSTERED INDEX [IDX_CORE_EXAM_PAPER_ANSWER_EXAMPAPERID]
ON [dbo].[t_core_exam_paper_answer] (
[EXAMPAPERID] ASC
)
GO
ALTER TABLE [dbo].[t_core_exam_paper_answer] ADD CONSTRAINT [PK_CORE_EXAM_PAPER_ANSWER] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('9808', '我的考试', '/secure/core/module/train/exam-papers/page/edit-list', '98', '9808', '009.svg', '我的考试');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('9809', '考试阅卷', '/secure/core/module/train/exam-papers/page/review-list', '98', '9809', '041.svg', '考试阅卷');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_CORE_EXAM_PAPER', '0', '0');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_CORE_EXAM_PAPER_ANSWER', '0', '0');
INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN)
VALUES ('20200306005','T_CORE_EXAM_PAPER_ANSWER', 'T_CORE_EXAM_PAPER', 'EXAMPAPERID');
INSERT INTO t_core_page_view_config VALUES ('T_CORE_EXAM$ACTIVE$0', '{\r\n \"readonly\": false\r\n}');
INSERT INTO t_core_page_view_config VALUES ('T_CORE_EXAM$ACTIVE$1', '{\r\n \"readonly\": true,\r\n \"button\": {\r\n \"core-exam-detail-btn-back\": {\r\n \"hidden\": false\r\n }\r\n }\r\n}');
INSERT INTO t_core_page_view_config VALUES ('T_CORE_EXAM_PAPER$ACTIVE$0', '{\r\n \"readonly\": false\r\n}');
INSERT INTO t_core_page_view_config VALUES ('T_CORE_EXAM_PAPER$ACTIVE$1', '{\r\n \"readonly\": true,\r\n \"button\": {\r\n \"core-exam-paper-review-detail-btn-back\": {\r\n \"hidden\": false\r\n }\r\n }\r\n}');
INSERT INTO t_core_page_view_config VALUES ('T_CORE_EXAM_TMPL$ACTIVE$0', '{\r\n \"readonly\": false\r\n}');
INSERT INTO t_core_page_view_config VALUES ('T_CORE_EXAM_TMPL$ACTIVE$1', '{\r\n \"readonly\": true,\r\n \"button\": {\r\n \"core-exam-tmpl-detail-btn-back\": {\r\n \"hidden\": false\r\n }\r\n }\r\n}');
INSERT INTO t_core_page_view_config VALUES ('T_CORE_QUESTION$ACTIVE$0', '{\r\n \"readonly\": false\r\n}');
INSERT INTO t_core_page_view_config VALUES ('T_CORE_QUESTION$ACTIVE$1', '{\r\n \"readonly\": true\r\n}');
INSERT INTO t_core_page_view_config VALUES ('T_CORE_TRAIN$ACTIVE$0', '{\r\n \"readonly\": false\r\n}');
INSERT INTO t_core_page_view_config VALUES ('T_CORE_TRAIN$ACTIVE$1', '{\r\n \"readonly\": true,\r\n \"button\": {\r\n \"core-train-detail-btn-back\": {\r\n \"hidden\": false\r\n }\r\n },\r\n \"form\": {\r\n \"core-train-detail-base-info-form\": {\r\n \"evaluation\": {\r\n \"readonly\": false\r\n }\r\n }\r\n },\r\n \"grid\": {\r\n \"core-train-detail-user-list-grid\": {\r\n \"score\": {\r\n \"readonly\": false\r\n }\r\n }\r\n }\r\n}');
INSERT INTO t_core_page_view_config VALUES ('T_CORE_TRAIN_PLAN$BPMN$approve', '{\r\n \"readonly\": true,\r\n \"button\": {\r\n \"core-train-plan-detail-btn-pass\": {\r\n \"hidden\": false\r\n },\r\n \"core-train-plan-detail-btn-reject\": {\r\n \"hidden\": false\r\n },\r\n \"core-train-plan-detail-btn-back\": {\r\n \"hidden\": false\r\n }\r\n }\r\n}');
INSERT INTO t_core_page_view_config VALUES ('T_CORE_TRAIN_PLAN$BPMN$draft', '{\r\n \"readonly\": false,\r\n \"button\": {\r\n \"core-train-plan-detail-btn-pass\": {\r\n \"hidden\": true\r\n },\r\n \"core-train-plan-detail-btn-reject\": {\r\n \"hidden\": true\r\n }\r\n }\r\n}');
-- --------------------------------------- 2020-03-21 zhangpf end -----------------
-- --------------------------------------- 2020-04-22 zhangpf begin -----------------
UPDATE T_CORE_PAGE_VIEW_CONFIG
SET CONFIG = '{"readonly": false,"button":{"core-train-plan-detail-btn-pass":{"hidden": true},"core-train-plan-detail-btn-reject": {"hidden": true}}}'
WHERE ID = 'T_CORE_TRAIN_PLAN$BPMN$draft';
UPDATE T_CORE_PAGE_VIEW_CONFIG
SET CONFIG = '{"readonly": true,"button":{"core-train-plan-detail-btn-pass":{"hidden": false},"core-train-plan-detail-btn-reject":{"hidden": false},"core-train-plan-detail-btn-back": {"hidden": false}}}'
WHERE ID = 'T_CORE_TRAIN_PLAN$BPMN$approve';
UPDATE T_CORE_PAGE_VIEW_CONFIG
SET CONFIG = '{"readonly": false}'
WHERE ID = 'T_CORE_TRAIN$ACTIVE$0';
UPDATE T_CORE_PAGE_VIEW_CONFIG
SET CONFIG = '{"readonly": true,"button": {"core-train-detail-btn-back": {"hidden": false}},"form": {"core-train-detail-base-info-form":
{"evaluation": {"readonly": false}}},"grid": {"core-train-detail-user-list-grid": {"score": {"readonly": false}}}}'
WHERE ID = 'T_CORE_TRAIN$ACTIVE$1';
UPDATE T_CORE_PAGE_VIEW_CONFIG
SET CONFIG = '{"readonly": false}'
WHERE ID = 'T_CORE_QUESTION$ACTIVE$0';
UPDATE T_CORE_PAGE_VIEW_CONFIG
SET CONFIG = '{"readonly": true}'
WHERE ID = 'T_CORE_QUESTION$ACTIVE$1';
UPDATE T_CORE_PAGE_VIEW_CONFIG
SET CONFIG = '{"readonly": false}'
WHERE ID = 'T_CORE_EXAM_TMPL$ACTIVE$0';
UPDATE T_CORE_PAGE_VIEW_CONFIG
SET CONFIG = '{"readonly": true,"button": {"core-exam-tmpl-detail-btn-back": {"hidden": false}}}'
WHERE ID = 'T_CORE_EXAM_TMPL$ACTIVE$1';
UPDATE T_CORE_PAGE_VIEW_CONFIG
SET CONFIG = '{"readonly": false}'
WHERE ID = 'T_CORE_EXAM_PAPER$ACTIVE$0';
UPDATE T_CORE_PAGE_VIEW_CONFIG
SET CONFIG = '{"readonly": true,"button": {"core-exam-paper-review-detail-btn-back": {"hidden": false}}}'
WHERE ID = 'T_CORE_EXAM_PAPER$ACTIVE$1';
UPDATE T_CORE_PAGE_VIEW_CONFIG
SET CONFIG = '{"readonly": false}'
WHERE ID = 'T_CORE_EXAM$ACTIVE$0';
UPDATE T_CORE_PAGE_VIEW_CONFIG
SET CONFIG = '{"readonly": true,"button": {"core-exam-detail-btn-back": {"hidden": false}}}'
WHERE ID = 'T_CORE_EXAM$ACTIVE$1';
-- --------------------------------------- 2020-04-22 zhangpf end -----------------
Reference in New Issue View Git Blame Copy Permalink