CREATE TABLE `tmp_mazg_l_r` (
  `school_code` varchar(20) NOT NULL,
  `school_term_id` int(11) NOT NULL,
  `diagnostician_id` char(13) NOT NULL,
  `diag_obj_id` char(12) NOT NULL,
  `naire_answer_rec_id` char(32) NOT NULL,
  `q_id` char(10) NOT NULL,
  `q_naire_question_id` char(11) DEFAULT NULL,
  `school_seq` smallint(6) NOT NULL,
  `score` decimal(17,4) DEFAULT NULL,
  `is_max_answer` int(1) DEFAULT NULL,
  `is_min_answer` int(1) DEFAULT NULL,
  KEY `diagnostician_id` (`diagnostician_id`) BLOCK_SIZE 16384 LOCAL,
  KEY `naire_answer_rec_id` (`naire_answer_rec_id`) BLOCK_SIZE 16384 LOCAL,
  KEY `q_id` (`q_id`) BLOCK_SIZE 16384 LOCAL
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0

;
CREATE TABLE `dw_question` (
  `q_id` char(6) NOT NULL COMMENT '题目ID',
  `diag_module` varchar(50) DEFAULT NULL COMMENT '诊断模块名称',
  `school_type` varchar(50) DEFAULT NULL COMMENT '学校类型名称',
  `q_answer_code` varchar(100) DEFAULT NULL COMMENT '题目答案编号',
  `q_code` varchar(50) DEFAULT NULL COMMENT '题目业务编号',
  `YS` varchar(50) DEFAULT NULL COMMENT '要素编码',
  `YS_name` varchar(100) DEFAULT NULL COMMENT '要素名称',
  `YS_show_seq` int(11) DEFAULT NULL COMMENT '要素显示顺序',
  `YS_desc` varchar(1000) DEFAULT NULL COMMENT '要素说明',
  `GCD` varchar(50) DEFAULT NULL COMMENT '观测点编码',
  `GCD_name` varchar(100) DEFAULT NULL COMMENT '观测点名称',
  `GCD_show_seq` int(11) DEFAULT NULL COMMENT '观测点显示顺序',
  `GCD_desc` varchar(1000) DEFAULT NULL COMMENT '观测点说明',
  `YZ` varchar(50) DEFAULT NULL COMMENT '因子编码',
  `YZ_name` varchar(100) DEFAULT NULL COMMENT '因子名称',
  `YZ_show_seq` int(11) DEFAULT NULL COMMENT '因子显示顺序',
  `YZ_desc` varchar(1000) DEFAULT NULL COMMENT '因子说明',
  `question` varchar(2000) DEFAULT NULL COMMENT '题目',
  `question2` varchar(2000) DEFAULT NULL COMMENT '题目2',
  `is_public` tinyint(1) DEFAULT '0' COMMENT '是否公共题',
  `is_lie_detection` tinyint(1) DEFAULT '0' COMMENT '是否测谎题',
  `lie_detection_answer` varchar(100) DEFAULT NULL COMMENT '测谎题正确答案',
  `is_reversed` tinyint(1) DEFAULT '0' COMMENT '是否反向题',
  `is_mutually_exclusive` tinyint(1) DEFAULT '0' COMMENT '是否反向互斥',
  `q_answer_code_for_rpt` varchar(100) DEFAULT NULL COMMENT '报告显示用题目答案',
  `answer_count` int(11) DEFAULT NULL COMMENT '案选项数量',
  `q_desc` varchar(200) DEFAULT NULL COMMENT '题目说明',
  `show_desc` tinyint(1) DEFAULT NULL COMMENT '是否显示说明',
  `is_vip` tinyint(1) DEFAULT NULL COMMENT '是否需要重点标示',
  `must_do` tinyint(1) DEFAULT NULL COMMENT '是否必填',
  `q_type` varchar(20) DEFAULT NULL COMMENT '单选、多选、主观、量表',
  `for_diagnostician_type` varchar(500) DEFAULT NULL COMMENT '适用诊断者类别',
  `for_diag_obj` varchar(500) DEFAULT NULL COMMENT '适用诊断对象类别',
  `q_comment` varchar(500) DEFAULT NULL COMMENT '可自由输入的备注，给题目打标签方便查询',
  `q_status` varchar(20) DEFAULT NULL COMMENT '草稿、有效、无效、修改',
  `q_last_mod_time` datetime DEFAULT NULL COMMENT '最后修改时间',
  `q_last_mod_comment` varchar(500) DEFAULT NULL COMMENT '最后修改说明',
  `q_last_modifier` varchar(50) DEFAULT NULL COMMENT '最后修改人',
  `show_seq` int(11) DEFAULT NULL COMMENT '诊断对象的默认显示顺序',
  `n_q_id` int(11) DEFAULT NULL COMMENT '题目ID_数值',
  `v_q_id` varchar(100) DEFAULT NULL COMMENT '题目ID_字符',
  `lang` char(2) DEFAULT NULL COMMENT '语言',
  `correct_option` varchar(20) DEFAULT NULL COMMENT '题目正确选项',
  PRIMARY KEY (`q_id`),
  KEY `q_id` (`q_id`) BLOCK_SIZE 16384 LOCAL,
  KEY `idx_m_q` (`diag_module`, `q_id`) BLOCK_SIZE 16384 LOCAL,
  KEY `idx_m_g_q` (`diag_module`, `GCD`, `q_id`) BLOCK_SIZE 16384 LOCAL,
  KEY `idx_y_q` (`diag_module`, `YZ`, `q_id`) BLOCK_SIZE 16384 LOCAL,
  KEY `q_answer_code` (`q_answer_code`) BLOCK_SIZE 16384 LOCAL,
  KEY `q_answer_code_for_rpt` (`q_answer_code_for_rpt`) BLOCK_SIZE 16384 LOCAL
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = COMPACT COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
;

CREATE TABLE `dw_naire_answer_rec` (
  `school_code` varchar(20) NOT NULL DEFAULT 'bj12z' COMMENT '学校编码',
  `school_term_id` int(11) NOT NULL DEFAULT '152' COMMENT '学期编码',
  `diagnostician_id` char(13) NOT NULL COMMENT '诊断者ID',
  `school_seq` smallint(6) NOT NULL COMMENT '学校序号',
  `naire_answer_rec_id` char(32) NOT NULL COMMENT '答题记录ID',
  `q_naire_id` varchar(60) DEFAULT NULL COMMENT '问卷ID',
  `diag_code` varchar(70) DEFAULT NULL COMMENT '诊断码',
  `answer_start_time` datetime DEFAULT NULL COMMENT '答题开始时间',
  `answer_end_time` datetime DEFAULT NULL COMMENT '答题结束时间',
  `totalTime` int(11) DEFAULT NULL COMMENT '答题总时长',
  `client_ip` varchar(100) DEFAULT NULL COMMENT '客户端IP',
  `warn_num` int(11) DEFAULT NULL COMMENT '过快警告次数',
  `q_count` int(11) DEFAULT NULL COMMENT '问卷题目数量',
  `prize_seq` int(11) DEFAULT '-1' COMMENT '中奖序号',
  `user_agent` varchar(4000) DEFAULT NULL COMMENT '客户端UserAgent',
  `agent_type` varchar(100) DEFAULT NULL COMMENT 'agent_type',
  `agent_name` varchar(100) DEFAULT NULL COMMENT 'agent_name',
  `agent_version` varchar(100) DEFAULT NULL COMMENT 'agent_version',
  `os_type` varchar(100) DEFAULT NULL COMMENT 'os_type',
  `os_name` varchar(100) DEFAULT NULL COMMENT 'os_name',
  `os_versionName` varchar(100) DEFAULT NULL COMMENT 'os_versionName',
  `os_versionNumber` varchar(100) DEFAULT NULL COMMENT 'os_versionNumber',
  `linux_distibution` varchar(100) DEFAULT NULL COMMENT 'linux_distibution',
  `naire_answer_file` varchar(100) DEFAULT NULL COMMENT '问卷答案文件',
  `old_naire_answer_rec_id` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`naire_answer_rec_id`, `school_code`),
  KEY `school_code` (`school_code`) BLOCK_SIZE 16384 LOCAL,
  KEY `diagnostician_id` (`diagnostician_id`) BLOCK_SIZE 16384 LOCAL,
  KEY `school_seq` (`school_seq`) BLOCK_SIZE 16384 LOCAL,
  KEY `naire_answer_rec_id` (`naire_answer_rec_id`) BLOCK_SIZE 16384 LOCAL,
  KEY `school_term_id` (`school_term_id`) BLOCK_SIZE 16384 LOCAL
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
 partition by key(`school_code`)
(partition `p0`,
partition `p1`,
partition `p10`,
partition `p11`,
partition `p12`,
partition `p13`,
partition `p14`,
partition `p15`,
partition `p16`,
partition `p17`,
partition `p18`,
partition `p19`,
partition `p2`,
partition `p20`,
partition `p21`,
partition `p22`,
partition `p23`,
partition `p24`,
partition `p25`,
partition `p26`,
partition `p27`,
partition `p28`,
partition `p29`,
partition `p3`,
partition `p30`,
partition `p31`,
partition `p32`,
partition `p33`,
partition `p34`,
partition `p35`,
partition `p36`,
partition `p37`,
partition `p38`,
partition `p39`,
partition `p4`,
partition `p40`,
partition `p41`,
partition `p42`,
partition `p43`,
partition `p44`,
partition `p45`,
partition `p46`,
partition `p47`,
partition `p48`,
partition `p49`,
partition `p5`,
partition `p50`,
partition `p51`,
partition `p52`,
partition `p53`,
partition `p54`,
partition `p55`,
partition `p56`,
partition `p57`,
partition `p58`,
partition `p59`,
partition `p6`,
partition `p60`,
partition `p61`,
partition `p62`,
partition `p63`,
partition `p64`,
partition `p65`,
partition `p66`,
partition `p67`,
partition `p68`,
partition `p69`,
partition `p7`,
partition `p70`,
partition `p71`,
partition `p72`,
partition `p73`,
partition `p74`,
partition `p75`,
partition `p76`,
partition `p77`,
partition `p78`,
partition `p79`,
partition `p8`,
partition `p80`,
partition `p81`,
partition `p82`,
partition `p83`,
partition `p84`,
partition `p85`,
partition `p86`,
partition `p87`,
partition `p88`,
partition `p89`,
partition `p9`,
partition `p90`,
partition `p91`,
partition `p92`,
partition `p93`,
partition `p94`,
partition `p95`,
partition `p96`,
partition `p97`,
partition `p98`,
partition `p99`)