/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50724
Source Host           : 127.0.0.1:3306
Source Database       : dfmea_v2_test

Target Server Type    : MYSQL
Target Server Version : 50724
File Encoding         : 65001

Date: 2022-02-22 17:41:57
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_rdfm_action
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_action`;
CREATE TABLE `t_rdfm_action` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `IN_FMEA_FLAG` char(1) DEFAULT NULL,
  `IN_FMEDA_FLAG` char(1) DEFAULT NULL,
  `IN_PLAN_FLAG` char(1) DEFAULT NULL,
  `ACTION_TYPE` char(2) DEFAULT NULL,
  `OCCURRENCE` smallint(6) DEFAULT NULL,
  `DETECTION` smallint(6) DEFAULT NULL,
  `USER_DEFINE_ATTR` tinyint(4) DEFAULT NULL,
  `RESPONSIBLE` char(9) DEFAULT NULL,
  `TEST_NAME` varchar(1024) DEFAULT NULL,
  `TEST_METHOD` varchar(512) DEFAULT NULL,
  `TEST_STANDARD` varchar(512) DEFAULT NULL,
  `TEST_PLACE` varchar(512) DEFAULT NULL,
  `SAMPLE_RANGE` varchar(512) DEFAULT NULL,
  `STATE` char(2) DEFAULT NULL,
  `PLAN_DATE` datetime DEFAULT NULL,
  `TRACK_TASK_ID` char(32) DEFAULT NULL,
  `REVISION_FLAG` char(1) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  `MERGE_ID` char(32) DEFAULT NULL,
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`FMEA_ID`,`STRU_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_api_warehouse
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_api_warehouse`;
CREATE TABLE `t_rdfm_api_warehouse` (
  `WAREHOUSE_ID` char(32) NOT NULL COMMENT '接口库主键',
  `DEFAULT_DFLAG` char(6) DEFAULT NULL COMMENT '默认引用（空：非默认 1：默认）',
  `NAME` varchar(255) NOT NULL COMMENT '库名',
  `STATE` char(5) DEFAULT NULL COMMENT '状态（0：启用 1：禁用）',
  `INSERT_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `INSERT_USER_ID` char(10) DEFAULT NULL COMMENT '创建者id',
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(10) DEFAULT NULL,
  `REMARK` varchar(255) DEFAULT NULL COMMENT '注释',
  PRIMARY KEY (`WAREHOUSE_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_api_warehouse_link
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_api_warehouse_link`;
CREATE TABLE `t_rdfm_api_warehouse_link` (
  `LINK_ID` char(32) NOT NULL COMMENT '接口连接方式表主键',
  `WAREHOUSE_ID` char(32) NOT NULL COMMENT '接口库表主键',
  `LINK_NAME` varchar(255) NOT NULL COMMENT '连接名',
  `LINK_TYPE` char(10) DEFAULT NULL COMMENT '连接类型（P:物理接触 E：能量传递 I：信息交换 M：物质传递 HM：人机交互）',
  `LINK_CODE` tinyint(10) DEFAULT NULL COMMENT '连接编号',
  `INSERT_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `INSERT_USER_ID` char(10) DEFAULT NULL COMMENT '创建者id',
  `UPDATE_TIME` datetime DEFAULT NULL COMMENT '修改时间',
  `UPDATE_USER_ID` char(10) DEFAULT NULL COMMENT '修改者id',
  PRIMARY KEY (`LINK_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_attachment
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_attachment`;
CREATE TABLE `t_rdfm_attachment` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `ATTACHMENT_ID` char(32) NOT NULL,
  `STORAGE_NAME` varchar(255) DEFAULT NULL,
  `ATTACHMENT_NAME` varchar(255) DEFAULT NULL,
  `ATTACHMENT_TYPE` varchar(32) DEFAULT NULL,
  `ATTACHMENT_PATH` varchar(255) DEFAULT NULL,
  `ATTACHMENT_SIZE` int(11) DEFAULT NULL,
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`,`ATTACHMENT_ID`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`STRU_ID`,`FMEA_ID`,`ATTACHMENT_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_boundary_map
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_boundary_map`;
CREATE TABLE `t_rdfm_boundary_map` (
  `STRU_ID` char(32) CHARACTER SET utf8 NOT NULL COMMENT '主键',
  `FMEA_ID` char(32) CHARACTER SET utf8 NOT NULL COMMENT 'FMEAID标识',
  `CHART_FLAG` tinyint(5) DEFAULT NULL COMMENT '边界图上展示/隐藏（0：隐藏 1：显示 ）',
  `COORDINATE` text COLLATE utf8_bin,
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for t_rdfm_chart_connect
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_chart_connect`;
CREATE TABLE `t_rdfm_chart_connect` (
  `CONNECT_ID` char(32) CHARACTER SET utf8 NOT NULL COMMENT '主键',
  `FMEA_ID` char(32) CHARACTER SET utf8 NOT NULL COMMENT 'FMEAID标识',
  `FROM_STRU_ID` char(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '起始节点',
  `TO_STRU_ID` char(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '目标节点',
  `LINK_NAME` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '连接名',
  `LINK_TYPE` char(10) COLLATE utf8_bin DEFAULT NULL COMMENT '连接类型',
  `LINK_METHOD` char(32) COLLATE utf8_bin DEFAULT NULL COMMENT '连接方式',
  `LINK_DIRECT` tinyint(5) DEFAULT NULL COMMENT '连接方向',
  `LINK_PROPERTY` tinyint(5) DEFAULT NULL COMMENT '连接性质',
  `ARROW_TYPE` varchar(128) CHARACTER SET utf8 DEFAULT NULL COMMENT '功能类别',
  `LINE_TYPE` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT '线的类别',
  `BORDER_SIZE` tinyint(11) DEFAULT NULL COMMENT '状态周期',
  `COLOR` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '颜色',
  `INSERT_USER_ID` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '添加者id',
  `INSERT_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `UPDATE_USER_ID` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '修改者id',
  `UPDATE_TIME` datetime DEFAULT NULL,
  `VERSION_NO` tinyint(11) DEFAULT NULL COMMENT '版本',
  `REMARK` varchar(300) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`CONNECT_ID`,`FMEA_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for t_rdfm_chart_data
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_chart_data`;
CREATE TABLE `t_rdfm_chart_data` (
  `FMEA_ID` char(32) NOT NULL,
  `CHART_DATA` longtext,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  `INTERNAL_FLAG` char(1) DEFAULT NULL,
  `EXTERNAL_FLAG` char(1) DEFAULT '1',
  PRIMARY KEY (`FMEA_ID`) USING BTREE,
  UNIQUE KEY `FMEA_ID` (`FMEA_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_editor_change_log
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_editor_change_log`;
CREATE TABLE `t_rdfm_editor_change_log` (
  `EDITOR_CHANGE_ID` char(32) NOT NULL,
  `EDITOR_USER_ID` char(9) NOT NULL,
  `TARGET_USER_ID` char(9) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`EDITOR_CHANGE_ID`,`EDITOR_USER_ID`,`TARGET_USER_ID`,`FMEA_ID`) USING BTREE,
  UNIQUE KEY `EDITOR_CHANGE_ID` (`EDITOR_CHANGE_ID`,`EDITOR_USER_ID`,`TARGET_USER_ID`,`FMEA_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_export_log
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_export_log`;
CREATE TABLE `t_rdfm_export_log` (
  `EXPORT_LOG_ID` char(32) NOT NULL,
  `USER_ID` char(9) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `EXPORT_FILE_TYPE` char(2) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`EXPORT_LOG_ID`,`USER_ID`,`FMEA_ID`) USING BTREE,
  UNIQUE KEY `EXPORT_LOG_ID` (`EXPORT_LOG_ID`,`USER_ID`,`FMEA_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_fault
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_fault`;
CREATE TABLE `t_rdfm_fault` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `SIGNIFIC` smallint(6) DEFAULT NULL,
  `USER_DEFINE_ATTR` tinyint(4) DEFAULT NULL,
  `CLASSIFY_ID` char(32) DEFAULT NULL,
  `SOURCE_TYPE` char(2) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`FMEA_ID`,`STRU_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_fault_net
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_fault_net`;
CREATE TABLE `t_rdfm_fault_net` (
  `FMEA_ID` char(32) NOT NULL,
  `FAULT_ID` char(32) NOT NULL,
  `PARENT_FAULT_ID` char(32) NOT NULL,
  PRIMARY KEY (`FMEA_ID`,`FAULT_ID`,`PARENT_FAULT_ID`) USING BTREE,
  UNIQUE KEY `FMEA_ID` (`FMEA_ID`,`FAULT_ID`,`PARENT_FAULT_ID`) USING BTREE,
  KEY `FMEA_ID1` (`FMEA_ID`) USING BTREE,
  KEY `PARENT_FAULT_ID` (`PARENT_FAULT_ID`) USING BTREE,
  KEY `FAULT_ID` (`FAULT_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_function
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_function`;
CREATE TABLE `t_rdfm_function` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `CATEGORY` char(32) DEFAULT NULL,
  `USER_DEFINE_ATTR` tinyint(4) DEFAULT NULL,
  `CLASSIFY_ID` char(32) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`FMEA_ID`,`STRU_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_function_net
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_function_net`;
CREATE TABLE `t_rdfm_function_net` (
  `FMEA_ID` char(32) NOT NULL,
  `FUNCTION_ID` char(32) NOT NULL,
  `PARENT_FUNCTION_ID` char(32) NOT NULL,
  PRIMARY KEY (`FMEA_ID`,`FUNCTION_ID`,`PARENT_FUNCTION_ID`) USING BTREE,
  UNIQUE KEY `FMEA_ID` (`FMEA_ID`,`FUNCTION_ID`,`PARENT_FUNCTION_ID`) USING BTREE,
  KEY `FMEA_ID1` (`FMEA_ID`) USING BTREE,
  KEY `FUNCTION_ID` (`FUNCTION_ID`) USING BTREE,
  KEY `PARENT_FUNCTION_ID` (`PARENT_FUNCTION_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_group
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_group`;
CREATE TABLE `t_rdfm_group` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `OCCURRENCE` smallint(6) DEFAULT NULL,
  `DETECTION` smallint(6) DEFAULT NULL,
  `USER_DEFINE_ATTR` tinyint(4) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`FMEA_ID`,`STRU_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_info
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_info`;
CREATE TABLE `t_rdfm_info` (
  `FMEA_ID` char(32) NOT NULL,
  `OBJECT_CODE` varchar(256) DEFAULT NULL,
  `ATTR_ID` char(32) DEFAULT NULL,
  `PDUCT_CLASSIFY_ID` char(32) DEFAULT NULL,
  `STANDARD_ID` char(32) DEFAULT NULL,
  `AP_ID` char(32) DEFAULT NULL,
  `LKEY` tinyint(4) DEFAULT NULL,
  `LIFE_STATE` char(2) DEFAULT NULL,
  `RELEASE_TIME` datetime DEFAULT NULL,
  `WAREHOUSE_ID` char(32) DEFAULT NULL COMMENT '接口库id',
  `VERSION_CODE` varchar(128) DEFAULT NULL,
  `DEL_FLAG` char(1) NOT NULL DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  `LIBRARY_ID` char(32) DEFAULT NULL,
  `OWNER_ID` char(9) DEFAULT NULL,
  `IS_UPGRADE` char(1) DEFAULT NULL,
  `UPGRADE_ID` char(32) DEFAULT NULL,
  `CREATE_LKEY` int(11) DEFAULT NULL,
  `CUSTOM_VERSION` varchar(20) DEFAULT NULL COMMENT '自定义版本信息',
  PRIMARY KEY (`FMEA_ID`) USING BTREE,
  UNIQUE KEY `FMEA_ID` (`FMEA_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_info_nls
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_info_nls`;
CREATE TABLE `t_rdfm_info_nls` (
  `FMEA_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  `FMEA_NAME` varchar(512) DEFAULT NULL,
  `OBJECT_NAME` varchar(512) DEFAULT NULL,
  `DESCRIPTION` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`FMEA_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `FMEA_ID` (`FMEA_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_line_function
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_line_function`;
CREATE TABLE `t_rdfm_line_function` (
  `STRU_ID` char(32) CHARACTER SET utf8 NOT NULL COMMENT '主键',
  `FMEA_ID` char(32) CHARACTER SET utf8 NOT NULL COMMENT 'FMEAID标识',
  `CONNECT_ID` char(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '连线id',
  `PARENT_STRU_ID` char(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '父节点id',
  `STATUS` tinyint(5) DEFAULT NULL COMMENT '状态（0：未分析，1：已分析）',
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for t_rdfm_log_manage_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_log_manage_detail`;
CREATE TABLE `t_rdfm_log_manage_detail` (
  `LOG_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `ACT_TYPE` char(2) DEFAULT NULL,
  `ACT_DETAIL` varchar(3000) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`LOG_ID`,`FMEA_ID`) USING BTREE,
  UNIQUE KEY `LOG_ID` (`LOG_ID`,`FMEA_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_measure
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_measure`;
CREATE TABLE `t_rdfm_measure` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `OCCURRENCE` smallint(6) DEFAULT NULL,
  `DETECTION` smallint(6) DEFAULT NULL,
  `USER_DEFINE_ATTR` tinyint(4) DEFAULT NULL,
  `CLASSIFY_ID` char(7) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`FMEA_ID`,`STRU_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_nls
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_nls`;
CREATE TABLE `t_rdfm_nls` (
  `FMEA_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  PRIMARY KEY (`FMEA_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `FMEA_ID` (`FMEA_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_pd
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_pd`;
CREATE TABLE `t_rdfm_pd` (
  `pd_id` char(32) NOT NULL COMMENT '标识',
  `stru_id` char(32) NOT NULL COMMENT '节点标识',
  `fmea_id` char(32) NOT NULL COMMENT 'fmea标识',
  `name` varchar(1500) NOT NULL COMMENT '名称',
  `feature_logic` char(2) DEFAULT NULL COMMENT '数值逻辑',
  `feature_value` varchar(512) DEFAULT NULL COMMENT '数值',
  `unit` varchar(90) DEFAULT NULL COMMENT '单位',
  `tolerance` varchar(90) DEFAULT NULL COMMENT '公差',
  `pd_code` char(2) NOT NULL COMMENT '类型编码',
  `insert_time` datetime NOT NULL COMMENT '创建时间',
  `insert_user_id` char(9) NOT NULL COMMENT '创建者',
  `insert_pgm_id` char(9) NOT NULL COMMENT '创建程序ID',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_user_id` char(9) DEFAULT NULL COMMENT '更新者',
  `update_pgm_id` char(9) DEFAULT NULL COMMENT '更新程序ID',
  `version_no` int(11) NOT NULL DEFAULT '0' COMMENT '版本号',
  PRIMARY KEY (`pd_id`,`stru_id`,`fmea_id`) USING BTREE,
  UNIQUE KEY `pd_id` (`pd_id`,`stru_id`,`fmea_id`) USING BTREE,
  KEY `pd_code` (`stru_id`,`fmea_id`,`pd_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='P图';

-- ----------------------------
-- Table structure for t_rdfm_pd_stru
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_pd_stru`;
CREATE TABLE `t_rdfm_pd_stru` (
  `pd_id` char(32) NOT NULL COMMENT '标识',
  `stru_id` char(32) NOT NULL COMMENT '节点标识',
  `fmea_id` char(32) NOT NULL COMMENT 'fmea标识',
  PRIMARY KEY (`pd_id`,`stru_id`,`fmea_id`) USING BTREE,
  UNIQUE KEY `pd_id` (`pd_id`,`stru_id`,`fmea_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='结构树P图关系表';

-- ----------------------------
-- Table structure for t_rdfm_person
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_person`;
CREATE TABLE `t_rdfm_person` (
  `FMEA_ID` char(32) NOT NULL,
  `USER_ID` char(9) NOT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  `EDIT_FLAG` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`FMEA_ID`,`USER_ID`) USING BTREE,
  UNIQUE KEY `FMEA_ID` (`FMEA_ID`,`USER_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_product_feature
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_product_feature`;
CREATE TABLE `t_rdfm_product_feature` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `CATEGORY` char(32) DEFAULT NULL,
  `IN_FMEA_FLAG` char(1) DEFAULT NULL,
  `PLAN_FLAG` char(1) DEFAULT NULL,
  `USER_DEFINE_ATTR` tinyint(4) DEFAULT NULL,
  `FEATURE_LOGIC` char(2) DEFAULT NULL,
  `FEATURE_VALUE` varchar(512) DEFAULT NULL,
  `UNIT` varchar(90) DEFAULT NULL,
  `TOLERANCE` varchar(90) DEFAULT NULL,
  `CLASSIFY_ID` char(32) DEFAULT NULL,
  `EQUIPMENT_ID` char(7) DEFAULT NULL,
  `SAMPLE_RANGE` varchar(36) DEFAULT NULL,
  `SAMPLE_FREQUENCY` varchar(36) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`FMEA_ID`,`STRU_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_project
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_project`;
CREATE TABLE `t_rdfm_project` (
  `FMEA_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  `FMEA_NO` varchar(600) DEFAULT NULL,
  `MODEL_PRO` varchar(600) DEFAULT NULL,
  `COMPANY` varchar(600) DEFAULT NULL,
  `DEPT` varchar(600) DEFAULT NULL,
  `PRO_ADDRESS` varchar(600) DEFAULT NULL,
  `CUSTOMER` varchar(600) DEFAULT NULL,
  `SYS_CODE` varchar(600) DEFAULT NULL,
  `SYS_NAME` varchar(600) DEFAULT NULL,
  `SUB_SYS` varchar(600) DEFAULT NULL,
  `PART_NUMBER` varchar(600) DEFAULT NULL,
  `PART_NAME` varchar(600) DEFAULT NULL,
  `ESTABLISH` varchar(32) DEFAULT NULL,
  `DESIGN_RESPLE` varchar(600) DEFAULT NULL,
  `SECURITY` varchar(600) DEFAULT NULL,
  `DRBFM_NO` varchar(600) DEFAULT NULL,
  `DVP_NO` varchar(600) DEFAULT NULL,
  `VENDOR_ID` varchar(600) DEFAULT NULL,
  `VENDOR_NAME` varchar(600) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  `PROJECT` varchar(600) DEFAULT NULL COMMENT '项目名称',
  PRIMARY KEY (`FMEA_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `FMEA_ID` (`FMEA_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_require
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_require`;
CREATE TABLE `t_rdfm_require` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `CATEGORY` char(32) DEFAULT NULL,
  `IN_FMEA_FLAG` char(1) DEFAULT NULL,
  `USER_DEFINE_ATTR` tinyint(4) DEFAULT NULL,
  `FEATURE_LOGIC` char(2) DEFAULT NULL,
  `FEATURE_VALUE` varchar(512) DEFAULT NULL,
  `UNIT` varchar(90) DEFAULT NULL,
  `TOLERANCE` varchar(90) DEFAULT NULL,
  `CLASSIFY_ID` char(32) DEFAULT NULL,
  `EQUIPMENT_ID` char(7) DEFAULT NULL,
  `SAMPLE_RANGE` varchar(36) DEFAULT NULL,
  `SAMPLE_FREQUENCY` varchar(36) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`FMEA_ID`,`STRU_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_stru_attribute
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_stru_attribute`;
CREATE TABLE `t_rdfm_stru_attribute` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `USER_DEFINE_ID` char(32) NOT NULL,
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`,`USER_DEFINE_ID`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`FMEA_ID`,`STRU_ID`,`USER_DEFINE_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_stru_element
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_stru_element`;
CREATE TABLE `t_rdfm_stru_element` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `PART_NUMBER` varchar(256) DEFAULT NULL,
  `USER_DEFINE_ATTR` tinyint(4) DEFAULT NULL,
  `MACHINE_ID` char(7) DEFAULT NULL,
  `PROCESS_ICON_ID` char(7) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  `EFFECT` int(11) DEFAULT NULL,
  `JOIN_TYPE` varchar(20) DEFAULT NULL,
  `JOIN_WAY` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`FMEA_ID`,`STRU_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_stru_id_temp
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_stru_id_temp`;
CREATE TABLE `t_rdfm_stru_id_temp` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `NEW_STRU_ID` char(32) DEFAULT NULL,
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_stru_nls
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_stru_nls`;
CREATE TABLE `t_rdfm_stru_nls` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  `NAME` varchar(1500) DEFAULT NULL,
  `DESCRIPTION` varchar(1024) DEFAULT NULL,
  `NAME_TRANSLATE` char(1) DEFAULT NULL,
  `DESC_TRANSLATE` char(1) DEFAULT NULL,
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`FMEA_ID`,`STRU_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_stru_tree
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_stru_tree`;
CREATE TABLE `t_rdfm_stru_tree` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `PARENT_STRU_ID` char(32) NOT NULL,
  `STRU_TYPE_CODE` char(2) NOT NULL,
  `SERIES_NO` varchar(64) DEFAULT NULL,
  `DEEP` smallint(2) NOT NULL,
  `LEFT_NO` int(11) NOT NULL,
  `RIGHT_NO` int(11) NOT NULL,
  `TYPE` char(1) NOT NULL,
  `NAME` varchar(1500) DEFAULT NULL,
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`FMEA_ID`,`STRU_ID`) USING BTREE,
  KEY `idx_fmea_code` (`FMEA_ID`,`STRU_TYPE_CODE`) USING BTREE,
  KEY `idx_lr_no` (`FMEA_ID`,`LEFT_NO`,`RIGHT_NO`) USING BTREE,
  KEY `idx_pid` (`FMEA_ID`,`PARENT_STRU_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_stru_tree_copy
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_stru_tree_copy`;
CREATE TABLE `t_rdfm_stru_tree_copy` (
  `STRU_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `PARENT_STRU_ID` char(32) NOT NULL,
  `STRU_TYPE_CODE` char(2) NOT NULL,
  `SERIES_NO` varchar(64) DEFAULT NULL,
  `DEEP` smallint(2) NOT NULL,
  `LEFT_NO` int(11) NOT NULL,
  `RIGHT_NO` int(11) NOT NULL,
  `TYPE` char(1) NOT NULL,
  `NAME` varchar(1500) DEFAULT NULL,
  PRIMARY KEY (`STRU_ID`,`FMEA_ID`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`FMEA_ID`,`STRU_ID`) USING BTREE,
  KEY `idx_fmea_code` (`FMEA_ID`,`STRU_TYPE_CODE`) USING BTREE,
  KEY `idx_lr_no` (`FMEA_ID`,`LEFT_NO`,`RIGHT_NO`) USING BTREE,
  KEY `idx_pid` (`FMEA_ID`,`PARENT_STRU_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_upgrade
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_upgrade`;
CREATE TABLE `t_rdfm_upgrade` (
  `UPGRADE_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `ORDER_NO` int(11) NOT NULL,
  `PARENT_FMEA_ID` char(32) DEFAULT NULL,
  `LAST_HISTORY_URL` varchar(256) DEFAULT NULL,
  `LOG_URL` varchar(256) DEFAULT NULL,
  `LKEY` int(11) DEFAULT NULL,
  `UPGRADE_TIME` datetime DEFAULT NULL,
  `UPGRADE_USER_ID` char(9) DEFAULT NULL,
  `UPGRADE_TYPE` char(1) DEFAULT NULL,
  PRIMARY KEY (`UPGRADE_ID`,`FMEA_ID`,`ORDER_NO`) USING BTREE,
  UNIQUE KEY `UPGRADE_ID` (`UPGRADE_ID`,`FMEA_ID`,`ORDER_NO`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_upgrade_change
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_upgrade_change`;
CREATE TABLE `t_rdfm_upgrade_change` (
  `CHANGE_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `UPGRADE_ID` char(32) NOT NULL,
  `ORDER_NO` int(11) NOT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`CHANGE_ID`,`FMEA_ID`,`UPGRADE_ID`,`ORDER_NO`) USING BTREE,
  UNIQUE KEY `CHANGE_ID` (`CHANGE_ID`,`FMEA_ID`,`UPGRADE_ID`,`ORDER_NO`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rdfm_upgrade_nls
-- ----------------------------
DROP TABLE IF EXISTS `t_rdfm_upgrade_nls`;
CREATE TABLE `t_rdfm_upgrade_nls` (
  `UPGRADE_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) NOT NULL,
  `LKEY` int(11) NOT NULL,
  `CAUSE` varchar(1024) DEFAULT NULL,
  `DESCRIPTION` varchar(1024) DEFAULT NULL,
  `CHANGE_ID` char(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`CHANGE_ID`,`FMEA_ID`,`UPGRADE_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `CHANGE_ID` (`CHANGE_ID`,`FMEA_ID`,`UPGRADE_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_ap
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_ap`;
CREATE TABLE `t_rfm_ap` (
  `AP_ID` char(32) NOT NULL,
  `DEFAULT_DFLAG` char(1) DEFAULT NULL,
  `DEFAULT_PFLAG` char(1) DEFAULT NULL,
  `SET_LKEY` tinyint(4) DEFAULT NULL,
  `STATE` char(1) DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`AP_ID`) USING BTREE,
  UNIQUE KEY `AP_ID` (`AP_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_ap_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_ap_detail`;
CREATE TABLE `t_rfm_ap_detail` (
  `AP_ID` char(32) NOT NULL,
  `DETAIL_NO` smallint(6) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  `S_BEGIN` tinyint(4) DEFAULT NULL,
  `S_END` tinyint(4) DEFAULT NULL,
  `O_BEGIN` tinyint(4) DEFAULT NULL,
  `O_END` tinyint(4) DEFAULT NULL,
  `D_BEGIN` tinyint(4) DEFAULT NULL,
  `D_END` tinyint(4) DEFAULT NULL,
  `AP` varchar(36) DEFAULT NULL,
  `ATTR1` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`AP_ID`,`DETAIL_NO`,`LKEY`) USING BTREE,
  UNIQUE KEY `AP_ID` (`AP_ID`,`DETAIL_NO`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_ap_nls
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_ap_nls`;
CREATE TABLE `t_rfm_ap_nls` (
  `AP_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  PRIMARY KEY (`AP_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `AP_ID` (`AP_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_attr
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_attr`;
CREATE TABLE `t_rfm_attr` (
  `ATTR_ID` char(32) NOT NULL,
  `DEFAULT_DFLAG` char(1) DEFAULT NULL,
  `DEFAULT_PFLAG` char(1) DEFAULT NULL,
  `SET_LKEY` tinyint(4) DEFAULT NULL,
  `STATE` char(1) DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ATTR_ID`) USING BTREE,
  UNIQUE KEY `ATTR_ID` (`ATTR_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_attr_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_attr_detail`;
CREATE TABLE `t_rfm_attr_detail` (
  `DETAIL_ID` char(32) NOT NULL,
  `ATTR_ID` char(32) NOT NULL,
  `ORDINAL` smallint(6) DEFAULT NULL,
  `STATE` char(1) DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`DETAIL_ID`,`ATTR_ID`) USING BTREE,
  UNIQUE KEY `DETAIL_ID` (`DETAIL_ID`,`ATTR_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_attr_nls
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_attr_nls`;
CREATE TABLE `t_rfm_attr_nls` (
  `ATTR_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  PRIMARY KEY (`ATTR_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `ATTR_ID` (`ATTR_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_attr_tran
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_attr_tran`;
CREATE TABLE `t_rfm_attr_tran` (
  `DETAIL_ID` char(32) NOT NULL,
  `ATTR_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  `NAME` varchar(512) DEFAULT NULL,
  `NAME_TRANSLATE` char(1) DEFAULT NULL,
  PRIMARY KEY (`DETAIL_ID`,`ATTR_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `DETAIL_ID` (`DETAIL_ID`,`ATTR_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_equipment
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_equipment`;
CREATE TABLE `t_rfm_equipment` (
  `EQUIPMENT_ID` char(32) NOT NULL,
  `DEFAULT_PFLAG` char(1) DEFAULT NULL,
  `SET_LKEY` tinyint(4) DEFAULT NULL,
  `STATE` char(1) DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`EQUIPMENT_ID`) USING BTREE,
  UNIQUE KEY `EQUIPMENT_ID` (`EQUIPMENT_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_equipment_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_equipment_detail`;
CREATE TABLE `t_rfm_equipment_detail` (
  `DETAIL_ID` char(32) NOT NULL,
  `EQUIPMENT_ID` char(32) NOT NULL,
  `ORDINAL` smallint(6) DEFAULT NULL,
  `STATE` char(1) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  `CODE` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`DETAIL_ID`,`EQUIPMENT_ID`) USING BTREE,
  UNIQUE KEY `DETAIL_ID` (`DETAIL_ID`,`EQUIPMENT_ID`) USING BTREE,
  KEY `DETAIL_ID1` (`DETAIL_ID`) USING BTREE,
  KEY `EQUIPMENT_ID` (`EQUIPMENT_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_equipment_nls
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_equipment_nls`;
CREATE TABLE `t_rfm_equipment_nls` (
  `EQUIPMENT_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  PRIMARY KEY (`EQUIPMENT_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `EQUIPMENT_ID` (`EQUIPMENT_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_equipment_tran
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_equipment_tran`;
CREATE TABLE `t_rfm_equipment_tran` (
  `DETAIL_ID` char(32) NOT NULL,
  `EQUIPMENT_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  `NAME` varchar(512) DEFAULT NULL,
  `DESCRIPTION` varchar(1024) DEFAULT NULL,
  `NAME_TRANSLATE` char(1) DEFAULT NULL,
  `DESC_TRANSLATE` char(1) DEFAULT NULL,
  PRIMARY KEY (`DETAIL_ID`,`EQUIPMENT_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `DETAIL_ID` (`DETAIL_ID`,`EQUIPMENT_ID`,`LKEY`) USING BTREE,
  KEY `DETAIL_ID1` (`DETAIL_ID`) USING BTREE,
  KEY `EQUIPMENT_ID` (`EQUIPMENT_ID`) USING BTREE,
  KEY `LKEY` (`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_library
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_library`;
CREATE TABLE `t_rfm_library` (
  `LIBRARY_ID` char(32) NOT NULL,
  `DEFAULT_FLAG` char(1) DEFAULT NULL,
  `SET_LKEY` int(11) NOT NULL DEFAULT '0',
  `STATE` char(1) DEFAULT '0',
  `TYPE` char(1) DEFAULT NULL,
  `DATA_SOURCE` text,
  `DEL_FLAG` char(1) NOT NULL DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`LIBRARY_ID`) USING BTREE,
  UNIQUE KEY `LIBRARY_ID` (`LIBRARY_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_library_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_library_detail`;
CREATE TABLE `t_rfm_library_detail` (
  `STRU_ID` char(32) NOT NULL,
  `LIBRARY_ID` char(32) NOT NULL,
  `PARENT_STRU_ID` char(32) NOT NULL,
  `STRU_TYPE_CODE` char(2) DEFAULT NULL,
  `LEFT_NO` int(11) DEFAULT NULL,
  `RIGHT_NO` int(11) DEFAULT NULL,
  `OCCURRENCE` int(11) DEFAULT NULL,
  `DETECTION` int(11) DEFAULT NULL,
  PRIMARY KEY (`STRU_ID`,`LIBRARY_ID`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`STRU_ID`,`LIBRARY_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_library_nls
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_library_nls`;
CREATE TABLE `t_rfm_library_nls` (
  `LIBRARY_ID` char(32) NOT NULL,
  `LKEY` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`LIBRARY_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `LIBRARY_ID` (`LIBRARY_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_library_tran
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_library_tran`;
CREATE TABLE `t_rfm_library_tran` (
  `STRU_ID` char(32) NOT NULL,
  `LIBRARY_ID` char(32) NOT NULL,
  `LKEY` int(11) NOT NULL DEFAULT '0',
  `NAME` varchar(1024) DEFAULT NULL,
  `DESCRIPTION` varchar(4000) DEFAULT NULL,
  `NAME_TRANSLATE` char(1) DEFAULT NULL,
  `DESC_TRANSLATE` char(1) DEFAULT NULL,
  PRIMARY KEY (`STRU_ID`,`LIBRARY_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `STRU_ID` (`STRU_ID`,`LIBRARY_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_machine
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_machine`;
CREATE TABLE `t_rfm_machine` (
  `MACHINE_ID` char(32) NOT NULL,
  `DEFAULT_PFLAG` char(1) DEFAULT NULL,
  `SET_LKEY` tinyint(4) DEFAULT NULL,
  `STATE` char(1) DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`MACHINE_ID`) USING BTREE,
  UNIQUE KEY `MACHINE_ID` (`MACHINE_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_machine_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_machine_detail`;
CREATE TABLE `t_rfm_machine_detail` (
  `DETAIL_ID` char(32) NOT NULL,
  `MACHINE_ID` char(32) NOT NULL,
  `ORDINAL` smallint(6) DEFAULT NULL,
  `STATE` char(1) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  `CODE` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`DETAIL_ID`,`MACHINE_ID`) USING BTREE,
  UNIQUE KEY `DETAIL_ID` (`DETAIL_ID`,`MACHINE_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_machine_nls
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_machine_nls`;
CREATE TABLE `t_rfm_machine_nls` (
  `MACHINE_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  PRIMARY KEY (`MACHINE_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `MACHINE_ID` (`MACHINE_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_machine_tran
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_machine_tran`;
CREATE TABLE `t_rfm_machine_tran` (
  `DETAIL_ID` char(32) NOT NULL,
  `MACHINE_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  `NAME` varchar(512) DEFAULT NULL,
  `DESCRIPTION` varchar(1024) DEFAULT NULL,
  `NAME_TRANSLATE` char(1) DEFAULT NULL,
  `DESC_TRANSLATE` char(1) DEFAULT NULL,
  PRIMARY KEY (`DETAIL_ID`,`MACHINE_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `DETAIL_ID` (`DETAIL_ID`,`MACHINE_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_pduct_classify
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_pduct_classify`;
CREATE TABLE `t_rfm_pduct_classify` (
  `PDUCT_CLASSIFY_ID` char(32) NOT NULL,
  `DEFAULT_DFLAG` char(1) DEFAULT NULL,
  `DEFAULT_PFLAG` char(1) DEFAULT NULL,
  `SET_LKEY` tinyint(4) DEFAULT NULL,
  `STATE` char(1) DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`PDUCT_CLASSIFY_ID`) USING BTREE,
  UNIQUE KEY `PDUCT_CLASSIFY_ID` (`PDUCT_CLASSIFY_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_pduct_classify_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_pduct_classify_detail`;
CREATE TABLE `t_rfm_pduct_classify_detail` (
  `DETAIL_ID` char(32) NOT NULL,
  `PDUCT_CLASSIFY_ID` char(32) NOT NULL,
  `CLASSIFY_TYPE` char(1) DEFAULT NULL,
  `CLASSIFY_PATH` varchar(255) DEFAULT NULL,
  `FILE_NAME` varchar(255) DEFAULT NULL,
  `ORDINAL` smallint(6) DEFAULT NULL,
  `STATE` char(1) DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`DETAIL_ID`,`PDUCT_CLASSIFY_ID`) USING BTREE,
  UNIQUE KEY `DETAIL_ID` (`DETAIL_ID`,`PDUCT_CLASSIFY_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_pduct_classify_nls
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_pduct_classify_nls`;
CREATE TABLE `t_rfm_pduct_classify_nls` (
  `PDUCT_CLASSIFY_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  PRIMARY KEY (`PDUCT_CLASSIFY_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `PDUCT_CLASSIFY_ID` (`PDUCT_CLASSIFY_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_pduct_classify_tran
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_pduct_classify_tran`;
CREATE TABLE `t_rfm_pduct_classify_tran` (
  `DETAIL_ID` char(32) NOT NULL,
  `PDUCT_CLASSIFY_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  `NAME` varchar(512) DEFAULT NULL,
  `DESCRIPTION` varchar(1024) DEFAULT NULL,
  `EXPLAIN` varchar(512) DEFAULT NULL,
  `NAME_TRANSLATE` char(1) DEFAULT NULL,
  `DESC_TRANSLATE` char(1) DEFAULT NULL,
  `EXP_TRANSLATE` char(1) DEFAULT NULL,
  PRIMARY KEY (`DETAIL_ID`,`PDUCT_CLASSIFY_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `DETAIL_ID` (`DETAIL_ID`,`PDUCT_CLASSIFY_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_proc_icon
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_proc_icon`;
CREATE TABLE `t_rfm_proc_icon` (
  `PROC_ICON_ID` char(32) NOT NULL,
  `DEFAULT_PFLAG` char(1) DEFAULT NULL,
  `SET_LKEY` tinyint(4) DEFAULT NULL,
  `STATE` char(1) DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`PROC_ICON_ID`) USING BTREE,
  UNIQUE KEY `PROC_ICON_ID` (`PROC_ICON_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_proc_icon_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_proc_icon_detail`;
CREATE TABLE `t_rfm_proc_icon_detail` (
  `DETAIL_ID` char(32) NOT NULL,
  `PROC_ICON_ID` char(32) NOT NULL,
  `PROC_ICON_PATH` varchar(255) DEFAULT NULL,
  `FILE_NAME` varchar(255) DEFAULT NULL,
  `ORDINAL` smallint(6) DEFAULT NULL,
  `STATE` char(1) DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`DETAIL_ID`,`PROC_ICON_ID`) USING BTREE,
  UNIQUE KEY `DETAIL_ID` (`DETAIL_ID`,`PROC_ICON_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_proc_icon_nls
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_proc_icon_nls`;
CREATE TABLE `t_rfm_proc_icon_nls` (
  `PROC_ICON_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  PRIMARY KEY (`PROC_ICON_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `PROC_ICON_ID` (`PROC_ICON_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_proc_icon_tran
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_proc_icon_tran`;
CREATE TABLE `t_rfm_proc_icon_tran` (
  `DETAIL_ID` char(32) NOT NULL,
  `PROC_ICON_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  `NAME` varchar(512) DEFAULT NULL,
  `DESCRIPTION` varchar(1024) DEFAULT NULL,
  `NAME_TRANSLATE` char(1) DEFAULT NULL,
  `DESC_TRANSLATE` char(1) DEFAULT NULL,
  PRIMARY KEY (`DETAIL_ID`,`PROC_ICON_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `DETAIL_ID` (`DETAIL_ID`,`PROC_ICON_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_standard
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_standard`;
CREATE TABLE `t_rfm_standard` (
  `STANDARD_ID` char(32) NOT NULL,
  `DEFAULT_DFLAG` char(1) DEFAULT NULL,
  `DEFAULT_PFLAG` char(1) DEFAULT NULL,
  `SET_LKEY` tinyint(4) DEFAULT NULL,
  `STATE` char(1) DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`STANDARD_ID`) USING BTREE,
  UNIQUE KEY `STANDARD_ID` (`STANDARD_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_standard_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_standard_detail`;
CREATE TABLE `t_rfm_standard_detail` (
  `STANDARD_ID` char(32) NOT NULL,
  `STANDARD_LEVEL` smallint(6) NOT NULL,
  `SOD_FLAG` char(1) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  `ATTR1` varchar(2048) DEFAULT NULL,
  `ATTR2` varchar(2048) DEFAULT NULL,
  `ATTR1_TRANSLATE` char(1) DEFAULT NULL,
  `ATTR2_TRANSLATE` char(1) DEFAULT NULL,
  `ATTR3` varchar(2048) DEFAULT NULL,
  `ATTR4` varchar(2048) DEFAULT NULL,
  `ATTR5` varchar(2048) DEFAULT NULL,
  `ATTR3_TRANSLATE` char(1) DEFAULT NULL,
  `ATTR4_TRANSLATE` char(1) DEFAULT NULL,
  `ATTR5_TRANSLATE` char(1) DEFAULT NULL,
  `ATTR3_CONTROL` char(1) DEFAULT NULL,
  `ATTR4_CONTROL` char(1) DEFAULT NULL,
  `ATTR5_CONTROL` char(1) DEFAULT NULL,
  PRIMARY KEY (`STANDARD_ID`,`STANDARD_LEVEL`,`SOD_FLAG`,`LKEY`) USING BTREE,
  UNIQUE KEY `STANDARD_ID` (`STANDARD_ID`,`STANDARD_LEVEL`,`SOD_FLAG`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_standard_nls
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_standard_nls`;
CREATE TABLE `t_rfm_standard_nls` (
  `STANDARD_ID` char(32) NOT NULL,
  `LKEY` tinyint(4) NOT NULL,
  PRIMARY KEY (`STANDARD_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `STANDARD_ID` (`STANDARD_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for t_rfm_user_define
-- ----------------------------
DROP TABLE IF EXISTS `t_rfm_user_define`;
CREATE TABLE `t_rfm_user_define` (
  `USER_DEFINE_ID` char(32) NOT NULL,
  `FMEA_ID` char(32) DEFAULT NULL,
  `FMEA_FLAG` char(1) DEFAULT NULL,
  `VERSION_FLAG` smallint(6) DEFAULT NULL,
  `LKEY` tinyint(4) NOT NULL,
  `MEMO` varchar(512) DEFAULT NULL,
  `ORDINAL` smallint(6) DEFAULT NULL,
  `STATE` char(1) DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) NOT NULL,
  `INSERT_PGM_ID` char(9) NOT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `UPDATE_USER_ID` char(9) DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`USER_DEFINE_ID`,`LKEY`) USING BTREE,
  UNIQUE KEY `USER_DEFINE_ID` (`USER_DEFINE_ID`,`LKEY`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Function structure for FUN_INSTR_SIMULATE_ORACLE
-- ----------------------------
DROP FUNCTION IF EXISTS `FUN_INSTR_SIMULATE_ORACLE`;
DELIMITER ;;
CREATE FUNCTION `FUN_INSTR_SIMULATE_ORACLE`(
    f_str varchar(2000),
    f_substr VARCHAR(100),
    f_str_pos INT,
    f_count INT UNSIGNED) RETURNS int(10) unsigned
BEGIN

      DECLARE i INT DEFAULT 0; 
      DECLARE j INT DEFAULT 0; 
      DECLARE v_substr_len INT UNSIGNED DEFAULT 0; 
      DECLARE v_str_len INT UNSIGNED DEFAULT 0;  
      SET v_str_len = LENGTH(f_str); 
      SET v_substr_len = LENGTH(f_substr);
      
      IF f_str_pos > 0 THEN
        SET i = f_str_pos;
        SET j = 0;
        WHILE i <= v_str_len
        DO
          IF INSTR(LEFT(SUBSTR(f_str,i),v_substr_len),f_substr) > 0 THEN
            SET j = j + 1;
            IF j = f_count THEN
              RETURN i;
            END IF;
          END IF;
          SET i = i + 1;
        END WHILE;
      
      ELSEIF f_str_pos <0 THEN
        SET i = v_str_len + f_str_pos+1;
        SET j = 0;
        WHILE i <= v_str_len AND i > 0 
        DO
          IF INSTR(RIGHT(SUBSTR(f_str,1,i),v_substr_len),f_substr) > 0 THEN
            SET j = j + 1;
            IF j = f_count THEN
              RETURN i - v_substr_len + 1;
            END IF;
          END IF;
          SET i = i - 1;
        END WHILE;
      
      ELSE
        RETURN 0;
      END IF;
      RETURN 0;
    END
;;
DELIMITER ;

-- ----------------------------
-- Function structure for FUN_RFM_PART_SERIES_NO
-- ----------------------------
DROP FUNCTION IF EXISTS `FUN_RFM_PART_SERIES_NO`;
DELIMITER ;;
CREATE DEFINER=`root`@`%` FUNCTION `FUN_RFM_PART_SERIES_NO`(P_IN_SERIES_NO varchar(300), P_IN_PREFIX varchar(300), P_IN_BASE_SERIES_LEN numeric(3), P_IN_OFFSET numeric(3)) RETURNS varchar(300) CHARSET utf8
begin
 
  declare V_JOIN varchar(1);
  declare V_PREFIX varchar(128);
  declare V_BASE_COLON_POS numeric(3);
  declare V_BASE_COMMA_POS numeric(3);
  declare V_POSTFIX_UPDATE_POS numeric(3);
  declare V_POSTFIX varchar(128);

  IF P_IN_SERIES_NO IS NULL or P_IN_SERIES_NO='' THEN
    RETURN NULL;
  END IF;
  set V_JOIN = SUBSTR(P_IN_SERIES_NO, P_IN_BASE_SERIES_LEN, 1);
  set V_PREFIX = concat(P_IN_PREFIX , V_JOIN);

  set V_BASE_COLON_POS = FUN_INSTR_SIMULATE_ORACLE(P_IN_SERIES_NO, ':', P_IN_BASE_SERIES_LEN+1, 1);
  set V_BASE_COMMA_POS = FUN_INSTR_SIMULATE_ORACLE(P_IN_SERIES_NO, '.', P_IN_BASE_SERIES_LEN+1, 1);
  
  set V_POSTFIX_UPDATE_POS = V_BASE_COLON_POS;
  IF V_POSTFIX_UPDATE_POS = 0 OR (V_POSTFIX_UPDATE_POS >= V_BASE_COMMA_POS and V_BASE_COMMA_POS <> 0) THEN
    set V_POSTFIX_UPDATE_POS = V_BASE_COMMA_POS;
  END IF;  
  
  IF V_POSTFIX_UPDATE_POS = 0 THEN
    RETURN concat(V_PREFIX , (SUBSTR(P_IN_SERIES_NO, P_IN_BASE_SERIES_LEN + 1)) , '');
  ELSE
    RETURN concat(V_PREFIX , (SUBSTR(P_IN_SERIES_NO, P_IN_BASE_SERIES_LEN + 1, V_POSTFIX_UPDATE_POS-P_IN_BASE_SERIES_LEN-1)) , SUBSTR(P_IN_SERIES_NO, V_POSTFIX_UPDATE_POS));
  END IF;
end
;;
DELIMITER ;

-- ----------------------------
-- Function structure for FUN_RFM_UPDATE_SERIES_NO
-- ----------------------------
DROP FUNCTION IF EXISTS `FUN_RFM_UPDATE_SERIES_NO`;
DELIMITER ;;
CREATE FUNCTION `FUN_RFM_UPDATE_SERIES_NO`(P_IN_SERIES_NO varchar(300), P_IN_BASE_SERIES_NO varchar(300)) RETURNS varchar(300) CHARSET utf8
begin
 
  declare V_BASE_COLON_POS numeric(3);
  declare V_BASE_COMMA_POS numeric(3);
  declare V_PREFIX_UPDATE_POS numeric(3);
  declare V_POSTFIX_UPDATE_POS numeric(3);
  declare V_PREFIX varchar(128);
  declare V_POSTFIX varchar(128);

  set V_BASE_COLON_POS = FUN_INSTR_SIMULATE_ORACLE(P_IN_BASE_SERIES_NO, ':', -1, 1);
  set V_BASE_COMMA_POS = FUN_INSTR_SIMULATE_ORACLE(P_IN_BASE_SERIES_NO, '.', -1, 1);

  IF V_BASE_COMMA_POS > V_BASE_COLON_POS THEN
    set V_PREFIX_UPDATE_POS = V_BASE_COMMA_POS;
  ELSE
    set V_PREFIX_UPDATE_POS = V_BASE_COLON_POS;
  END IF;
 
  set V_PREFIX = SUBSTR(P_IN_SERIES_NO, 1, V_PREFIX_UPDATE_POS);
  
  set V_BASE_COLON_POS = FUN_INSTR_SIMULATE_ORACLE(P_IN_SERIES_NO, ':', V_PREFIX_UPDATE_POS+1, 1);
  set V_BASE_COMMA_POS = FUN_INSTR_SIMULATE_ORACLE(P_IN_SERIES_NO, '.', V_PREFIX_UPDATE_POS+1, 1);
  
  set V_POSTFIX_UPDATE_POS = V_BASE_COLON_POS;
  IF V_POSTFIX_UPDATE_POS = 0 OR (V_POSTFIX_UPDATE_POS >= V_BASE_COMMA_POS and V_BASE_COMMA_POS <> 0) THEN
    set V_POSTFIX_UPDATE_POS = V_BASE_COMMA_POS;
  END IF;  
  
  IF V_POSTFIX_UPDATE_POS = 0 THEN
    RETURN concat(V_PREFIX , (SUBSTR(P_IN_SERIES_NO, V_PREFIX_UPDATE_POS + 1) - 1) , '');
  ELSE
    RETURN concat(V_PREFIX , (SUBSTR(P_IN_SERIES_NO, V_PREFIX_UPDATE_POS + 1, V_POSTFIX_UPDATE_POS-V_PREFIX_UPDATE_POS-1) -1) , SUBSTR(P_IN_SERIES_NO, V_POSTFIX_UPDATE_POS) );
  END IF;
end
;;
DELIMITER ;

-- ----------------------------
-- Function structure for FUN_TREE_D_FAULT_NET_CHILD_BUILD
-- ----------------------------
DROP FUNCTION IF EXISTS `FUN_TREE_D_FAULT_NET_CHILD_BUILD`;
DELIMITER ;;
CREATE FUNCTION `FUN_TREE_D_FAULT_NET_CHILD_BUILD`(p_parentId varchar(32), p_fmeaId varchar(32)) RETURNS varchar(20000) CHARSET utf8
begin
 
 declare sTemp varchar(20000);
 declare sTempChd varchar(20000);

 set sTemp = '$';
 set sTempChd =p_parentId;

 while sTempChd is not null do
  set sTemp = concat(sTemp,',',sTempChd);
  select group_concat(FAULT_ID) into sTempChd from T_RDFM_FAULT_NET where find_in_set(PARENT_FAULT_ID,sTempChd)> 0 and FMEA_ID=p_fmeaId;
 end while;

 return sTemp;

end
;;
DELIMITER ;

-- ----------------------------
-- Function structure for FUN_TREE_D_FAULT_NET_PARENT_BUILD
-- ----------------------------
DROP FUNCTION IF EXISTS `FUN_TREE_D_FAULT_NET_PARENT_BUILD`;
DELIMITER ;;
CREATE FUNCTION `FUN_TREE_D_FAULT_NET_PARENT_BUILD`(p_childId varchar(32), p_fmeaId varchar(32)) RETURNS varchar(20000) CHARSET utf8
begin
 
 declare sTemp varchar(20000);
 declare sTempChild varchar(20000);

 set sTemp = '';
 set sTempChild = p_childId;
 
 while sTempChild is not null do
	
  if sTemp !='' then
   set sTemp = concat(sTemp, ',' ,sTempChild);
  else
   set sTemp = sTempChild;
  end if;

  select group_concat(PARENT_FAULT_ID) into sTempChild from T_RDFM_FAULT_NET where find_in_set(FAULT_ID,sTempChild) > 0 and FMEA_ID=p_fmeaId;
 end while;
 
 return sTemp;

end
;;
DELIMITER ;

-- ----------------------------
-- Function structure for FUN_TREE_D_FUNCTION_NET_CHILD_BUILD
-- ----------------------------
DROP FUNCTION IF EXISTS `FUN_TREE_D_FUNCTION_NET_CHILD_BUILD`;
DELIMITER ;;
CREATE FUNCTION `FUN_TREE_D_FUNCTION_NET_CHILD_BUILD`(p_parentId varchar(32), p_fmeaId varchar(32)) RETURNS varchar(20000) CHARSET utf8
begin
 
 declare sTemp text;
 declare sTempChd text;

 set sTemp = '$';
 set sTempChd =p_parentId;

 while sTempChd is not null do
  set sTemp = concat(sTemp,',',sTempChd);
  select group_concat(FUNCTION_ID) into sTempChd from T_RDFM_FUNCTION_NET where find_in_set(PARENT_FUNCTION_ID,sTempChd)> 0 and FMEA_ID=p_fmeaId;
 end while;

 return sTemp;

end
;;
DELIMITER ;

-- ----------------------------
-- Function structure for FUN_TREE_D_FUNCTION_NET_PARENT_BUILD
-- ----------------------------
DROP FUNCTION IF EXISTS `FUN_TREE_D_FUNCTION_NET_PARENT_BUILD`;
DELIMITER ;;
CREATE FUNCTION `FUN_TREE_D_FUNCTION_NET_PARENT_BUILD`(p_childId varchar(32), p_fmeaId varchar(32)) RETURNS varchar(20000) CHARSET utf8
begin
 
 declare sTemp varchar(20000);
 declare sTempChild varchar(20000);

 set sTemp = '';
 set sTempChild = p_childId;
 
 while sTempChild is not null do
	
  if sTemp !='' then
   set sTemp = concat(sTemp, ',' ,sTempChild);
  else
   set sTemp = sTempChild;
  end if;

  select group_concat(PARENT_FUNCTION_ID) into sTempChild from T_RDFM_FUNCTION_NET where find_in_set(FUNCTION_ID,sTempChild) > 0 and FMEA_ID=p_fmeaId;
 end while;
 
 return sTemp;

end
;;
DELIMITER ;

-- ----------------------------
-- Table structure for t_sys_user
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user`;
CREATE TABLE `t_sys_user`  (
  `USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `USER_NAME` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LOGIN_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `PASSWORD` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `EMAIL` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TELEPHONE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MOBILE_PHONE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `PRESET` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSERT_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UPDATE_TIME` datetime NULL DEFAULT NULL,
  `UPDATE_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`USER_ID`) USING BTREE,
  UNIQUE INDEX `USER_ID`(`USER_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_cm_code
-- ----------------------------
DROP TABLE IF EXISTS `t_cm_code`;
CREATE TABLE `t_cm_code`  (
  `CM_ID` char(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CM_CLASS` char(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CM_CLASS_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CM_CODE` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CM_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DESCRIPTION` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ORDINAL` tinyint(4) NOT NULL,
  `DEL_FLAG` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSERT_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UPDATE_TIME` datetime NULL DEFAULT NULL,
  `UPDATE_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`CM_ID`) USING BTREE,
  UNIQUE INDEX `CM_ID`(`CM_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_cm_code
-- ----------------------------
INSERT INTO `t_cm_code` VALUES ('000000000000000000000001', '001', 'WDA Analysis Objective', '01', 'select.analysisobjective.operatedtime1', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000002', '001', 'WDA Analysis Objective', '02', 'select.analysisobjective.operatedtime2', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000003', '001', 'WDA Analysis Objective', '03', 'select.analysisobjective.operatedtime3', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000004', '002', 'WDA Time Unit', '01', 'select.timeunits.year', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000005', '002', 'WDA Time Unit', '02', 'select.timeunits.month', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000006', '002', 'WDA Time Unit', '03', 'select.timeunits.day', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000007', '003', 'WB Distribution', '01', 'select.distribution.weibull', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000008', '003', 'WB Distribution', '02', 'select.distribution.lognormal', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000009', '003', 'WB Distribution', '04', 'select.distribution.exponential', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000010', '003', 'WB Distribution', '03', 'select.distribution.normal', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000011', '004', 'WB Parameter', '01', 'select.parameter.1parameter', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000012', '004', 'WB Parameter', '02', 'select.parameter.2parameter', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000013', '004', 'WB Parameter', '03', 'select.parameter.3parameter', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000014', '005', 'WB Evaluate', '01', 'select.evaluating.rrx', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000015', '005', 'WB Evaluate', '02', 'select.evaluating.rry', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000016', '005', 'WB Evaluate', '03', 'select.evaluating.mle', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000017', '006', 'WB RankingMethod', '01', 'select.rankingmethod.medianrank', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000018', '007', 'WB ConfidenceType', '00', 'select.confidencetype.nothing', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000019', '007', 'WB ConfidenceType', '01', 'select.confidencetype.dconfidencebound', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000020', '007', 'WB ConfidenceType', '02', 'select.confidencetype.lowerbound', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000021', '007', 'WB ConfidenceType', '03', 'select.confidencetype.upperbound', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000022', '008', 'WB ConfidenceMethod', '01', 'select.confidencemethod.fishermatrix', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000023', '008', 'WB ConfidenceMethod', '02', 'select.confidencemethod.likelihoodradio', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000024', '009', 'WDA Data Resource', '01', 'select.dataresource.database', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000025', '009', 'WDA Data Resource', '02', 'select.dataresource.file', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000026', '010', 'WDA Repair Type', '01', 'select.repairtype.changepart', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000027', '010', 'WDA Repair Type', '02', 'select.repairtype.repairpart', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000028', '011', 'WDA Warranty Type', '01', 'select.warrantytype.partmanul', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000029', '012', 'WDA Analysis Type', '01', 'select.analysistype.usage', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000030', '012', 'WDA Analysis Type', '02', 'select.analysistype.fu', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000031', '012', 'WDA Analysis Type', '03', 'select.analysistype.fugroup', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000032', '012', 'WDA Analysis Type', '04', 'select.analysistype.futrend', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000033', '012', 'WDA Analysis Type', '12', 'select.analysistype.fu.part.trend', '', 5, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000034', '012', 'WDA Analysis Type', '05', 'select.analysistype.futime', '', 6, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000035', '012', 'WDA Analysis Type', '06', 'select.analysistype.cu', '', 7, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000036', '012', 'WDA Analysis Type', '07', 'select.analysistype.cugroup', '', 8, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000037', '012', 'WDA Analysis Type', '08', 'select.analysistype.cutrend', '', 9, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000038', '012', 'WDA Analysis Type', '13', 'select.analysistype.cu.part.trend', '', 10, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000039', '012', 'WDA Analysis Type', '09', 'select.analysistype.cutime', '', 11, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000040', '012', 'WDA Analysis Type', '10', 'select.analysistype.repairtime', '', 12, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000041', '012', 'WDA Analysis Type', '11', 'select.analysistype.mttff', '', 13, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000042', '013', 'WDA CharType1 ', '01', 'select.chartype1.columnline', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000043', '013', 'WDA CharType1 ', '02', 'select.chartype1.columnline2', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000044', '013', 'WDA CharType1 ', '03', 'select.chartype1.columnline3', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000045', '014', 'WDA CharType2', '01', 'select.chartype2.pie', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000046', '014', 'WDA CharType2', '02', 'select.chartype2.column', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000047', '015', 'WF Approval Action', '01', 'select.action.approve', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000048', '015', 'WF Approval Action', '02', 'select.action.notify', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000049', '016', 'WF Task State', '01', 'select.task.waitdo', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000050', '016', 'WF Task State', '02', 'select.task.accept', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000051', '016', 'WF Task State', '03', 'select.task.done', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000052', '016', 'WF Task State', '04', 'select.task.delegate', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000053', '016', 'WF Task State', '05', 'select.task.reject', '', 5, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000054', '016', 'WF Task State', '06', 'select.task.accepted', '', 6, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000055', '017', 'Notice Type', '01', 'select.notice.sysmsg', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000056', '017', 'Notice Type', '02', 'select.notice.taskmsg', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000057', '017', 'Notice Type', '03', 'select.notice.usermsg', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000058', '018', 'Critical Level', '01', 'select.critical.high', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000059', '018', 'Critical Level', '02', 'select.critical.middle', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000060', '018', 'Critical Level', '03', 'select.critical.low', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000061', '019', 'Notice Way', '01', 'select.noticeway.no', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000062', '019', 'Notice Way', '02', 'select.noticeway.tasker', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000063', '019', 'Notice Way', '03', 'select.noticeway.owner', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000064', '019', 'Notice Way', '04', 'select.noticeway.both', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000065', '020', 'Person Select Type', '01', 'select.common.user', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000066', '020', 'Person Select Type', '02', 'select.common.group', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000067', '021', 'Part Critical Level', '01', 'select.part.critical.low', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000068', '021', 'Part Critical Level', '02', 'select.part.critical.middle', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000069', '021', 'Part Critical Level', '03', 'select.part.critical.high', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000070', '022', 'PM Type', '01', 'select.pj.type.development', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000071', '022', 'PM Type', '02', 'select.pj.type.application', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000072', '022', 'PM Type', '03', 'select.pj.type.upgrade', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000073', '022', 'PM Type', '04', 'select.pj.type.costdown', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000074', '023', 'PM Application', '01', 'select.pj.application.truck', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000075', '023', 'PM Application', '02', 'select.pj.application.truckct001', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000076', '023', 'PM Application', '03', 'select.pj.application.truckct002', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000077', '024', 'Reliability Index', '01', 'select.reliability.index.afr', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000078', '024', 'Reliability Index', '02', 'select.reliability.index.mtbf', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000079', '025', 'Proactive type', '01', 'select.proactive.type.system', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000080', '025', 'Proactive type', '02', 'select.proactive.type.subsystem', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000081', '025', 'Proactive type', '03', 'select.proactive.type.parts', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000082', '027', 'WF Instance State', '01', 'select.instance.edit', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000083', '027', 'WF Instance State', '02', 'select.instance.start', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000084', '027', 'WF Instance State', '03', 'select.instance.complete', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000085', '027', 'WF Instance State', '04', 'select.instance.reject', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000086', '028', 'TS Allocation Method', '01', 'select.allocation.method.equal', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000087', '028', 'TS Allocation Method', '02', 'select.allocation.method.score', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000088', '028', 'TS Allocation Method', '03', 'select.allocation.method.arinc', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000089', '028', 'TS Allocation Method', '04', 'select.allocation.method.modify_arinc', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000090', '028', 'TS Allocation Method', '05', 'select.allocation.method.agree', '', 5, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000091', '030', 'Target Type', '31', 'select.target.type.system', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000092', '030', 'Target Type', '32', 'select.target.type.subsystem', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000093', '032', 'TS Setting Method', '01', 'select.setting.method.subjective', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000094', '032', 'TS Setting Method', '02', 'select.setting.method.baysian', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000095', '033', 'Metric Type', '01', 'select.metric.mtbf', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000096', '033', 'Metric Type', '02', 'select.metric.fr', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000097', '034', 'PT Problem Severity', '01', 'select.problem.severity.low', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000098', '034', 'PT Problem Severity', '02', 'select.problem.severity.middle', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000099', '034', 'PT Problem Severity', '03', 'select.problem.severity.high', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000100', '041', 'WB Data Resource', '02', 'select.wb.data.file', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000101', '041', 'WB Data Resource', '03', 'select.wb.data.manual', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000102', '041', 'WB Data Resource', '05', 'select.wb.data.randogenerator', '', 5, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000103', '042', 'Document Related Type ', '01', 'select.doc.related.other', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000104', '042', 'Document Related Type ', '02', 'select.doc.related.product', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000105', '042', 'Document Related Type ', '03', 'select.doc.related.part', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000106', '043', 'TS Metric Type', '01', 'select.ts.metric.mtbf', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000107', '043', 'TS Metric Type', '02', 'select.ts.metric.fr', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000108', '043', 'TS Metric Type', '03', 'select.ts.metric.rt', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000109', '044', 'TS Time Unit', '01', 'select.ts.time.unit.year', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000110', '044', 'TS Time Unit', '02', 'select.ts.time.unit.day', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000111', '044', 'TS Time Unit', '03', 'select.ts.time.unit.hour', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000112', '044', 'TS Time Unit', '04', 'select.ts.time.unit.kilometer', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000113', '044', 'TS Time Unit', '05', 'select.ts.time.unit.time', '', 5, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000114', '045', 'LD Distribution', '01', 'select.ld.distribution.weibull', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000115', '045', 'LD Distribution', '02', 'select.ld.distribution.lognormal', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000116', '045', 'LD Distribution', '03', 'select.ld.distribution.normal', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000117', '045', 'LD Distribution', '04', 'select.ld.distribution.exponential', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000118', '046', 'LD Parameter', '01', 'select.ld.parameter.1parameter', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000119', '046', 'LD Parameter', '02', 'select.ld.parameter.2parameter', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000120', '046', 'LD Parameter', '03', 'select.ld.parameter.3parameter', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000121', '047', 'LD Evaluate', '01', 'select.ld.evaluating.rrx', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000122', '047', 'LD Evaluate', '02', 'select.ld.evaluating.rry', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000123', '047', 'LD Evaluate', '03', 'select.ld.evaluating.mle', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000124', '048', 'LD RankingMethod', '01', 'select.ld.rankingmethod.medianrank', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000125', '049', 'LD ConfidenceType', '00', 'select.ld.confidencetype.nothing', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000126', '049', 'LD ConfidenceType', '01', 'select.ld.confidencetype.dconfidencebound', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000127', '049', 'LD ConfidenceType', '02', 'select.ld.confidencetype.lowerbound', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000128', '049', 'LD ConfidenceType', '03', 'select.ld.confidencetype.upperbound', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000129', '050', 'LD ConfidenceMethod', '01', 'select.ld.confidencemethod.fishermatrix', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000130', '050', 'LD ConfidenceMethod', '02', 'select.ld.confidencemethod.likelihoodradio', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000131', '051', 'DA Model', '01', 'select.model.linearityModel', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000132', '051', 'DA Model', '02', 'select.model.exponentialModel', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000133', '051', 'DA Model', '03', 'select.model.powerFunModel', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000134', '051', 'DA Model', '04', 'select.model.logarithmModel', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000135', '051', 'DA Model', '05', 'select.model.lioydLipowModel', '', 5, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000136', '052', 'DFMEA', '01', 'select.dfmea.actiontype.prevent', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000137', '052', 'DFMEA', '02', 'select.dfmea.actiontype.detect', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000138', '053', 'DFMEA', '01', 'select.dfmea.state.process', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000139', '053', 'DFMEA', '02', 'select.dfmea.state.notcomplete', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000140', '053', 'DFMEA', '03', 'select.dfmea.state.complete', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000141', '054', 'DFMEA', '01', 'select.dfmea.severitytype.sc', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000142', '054', 'DFMEA', '02', 'select.dfmea.severitytype.s', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000143', '054', 'DFMEA', '03', 'select.dfmea.severitytype.yc', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000144', '055', 'DFMEA Feature_Logic', '01', 'select.dfmea.featurelogic.equal', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000145', '055', 'DFMEA Feature_Logic', '02', 'select.dfmea.featurelogic.greater', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000146', '055', 'DFMEA Feature_Logic', '03', 'select.dfmea.featurelogic.small', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000147', '055', 'DFMEA Feature_Logic', '04', 'select.dfmea.featurelogic.greaterequal', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000148', '055', 'DFMEA Feature_Logic', '05', 'select.dfmea.featurelogic.smallequal', '', 5, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000149', '055', 'DFMEA Feature_Logic', '06', 'select.dfmea.featurelogic.uneuqal', '', 6, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000150', '056', 'PD Feature_Logic', '01', 'select.pd.featurelogic.equal', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000151', '056', 'PD Feature_Logic', '02', 'select.pd.featurelogic.greater', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000152', '056', 'PD Feature_Logic', '03', 'select.pd.featurelogic.small', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000153', '056', 'PD Feature_Logic', '04', 'select.pd.featurelogic.greaterequal', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000154', '056', 'PD Feature_Logic', '05', 'select.pd.featurelogic.smallequal', '', 5, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000155', '056', 'PD Feature_Logic', '06', 'select.pd.featurelogic.uneuqal', '', 6, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000156', '057', 'PFMEA optimize action type', '01', 'select.pfmea.actiontype.prevent', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000157', '057', 'PFMEA optimize action type', '02', 'select.pfmea.actiontype.detect', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000158', '058', 'PFMEA serverity type', '01', 'select.pfmea.severitytype.sc', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000159', '058', 'PFMEA serverity type', '02', 'select.pfmea.severitytype.s', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000160', '058', 'PFMEA serverity type', '03', 'select.pfmea.severitytype.yc', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000161', '060', 'PFMEA Feature_Logic', '01', 'select.pfmea.featurelogic.equal', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000162', '060', 'PFMEA Feature_Logic', '02', 'select.pfmea.featurelogic.greater', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000163', '060', 'PFMEA Feature_Logic', '03', 'select.pfmea.featurelogic.small', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000164', '060', 'PFMEA Feature_Logic', '04', 'select.pfmea.featurelogic.greaterequal', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000165', '060', 'PFMEA Feature_Logic', '05', 'select.pfmea.featurelogic.smallequal', '', 5, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000166', '060', 'PFMEA Feature_Logic', '06', 'select.pfmea.featurelogic.uneuqal', '', 6, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000167', '061', 'FMEA Base Warehouse State', '0', 'select.fmea.state.enable', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000168', '061', 'FMEA Base Warehouse State', '1', 'select.fmea.state.disabled', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000169', '062', 'FCS PROBLEM_STATE', '01', 'select.problem.lifeState.create', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000170', '062', 'FCS PROBLEM_STATE', '02', 'select.problem.lifeState.unfathomed', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000171', '062', 'FCS PROBLEM_STATE', '03', 'select.problem.lifeState.Solutioning', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000172', '062', 'FCS PROBLEM_STATE', '04', 'select.problem.lifeState.Solutioned', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000173', '063', 'FCS PROBLEM_BELONG', '1', 'select.problem.belong.afterService', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000174', '063', 'FCS PROBLEM_BELONG', '2', 'select.problem.belong.produce', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000175', '063', 'FCS PROBLEM_BELONG', '3', 'select.problem.belong.design', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000176', '063', 'FCS PROBLEM_BELONG', '4', 'select.problem.belong.test', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000177', '064', 'FCS PROBLEM_RELATINGSTATE', '01', 'select.problem.relatingState.unAssociated', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000178', '064', 'FCS PROBLEM_RELATINGSTATE', '02', 'select.problem.relatingState.associated', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000179', '065', 'FCS PHASE_ISOLATION_SELECT_STATE', '01', 'select.isolation.select.state.noStart', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000180', '065', 'FCS PHASE_ISOLATION_SELECT_STATE', '02', 'select.isolation.select.state.working', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000181', '065', 'FCS PHASE_ISOLATION_SELECT_STATE', '03', 'select.isolation.select.state.finish', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000182', '066', 'FCS PHASE_ISOLATION_VALIDATE_STATE', '01', 'select.isolation.validate.state.noStart', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000183', '066', 'FCS PHASE_ISOLATION_VALIDATE_STATE', '02', 'select.isolation.validate.state.working', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000184', '066', 'FCS PHASE_ISOLATION_VALIDATE_STATE', '03', 'select.isolation.validate.state.finish', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000185', '067', 'FCS PHASE_DEFEND_STATE', '01', 'select.defend.state.noStart', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000186', '067', 'FCS PHASE_DEFEND_STATE', '02', 'select.defend.state.working', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000187', '067', 'FCS PHASE_DEFEND_STATE', '03', 'select.defend.state.finish', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000188', '068', 'APPROVE TYPE', '01', 'select.approve.type.state', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000189', '068', 'APPROVE TYPE', '02', 'select.approve.type.share', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000190', '068', 'APPROVE TYPE', '03', 'select.approve.type.rebuild', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000191', '069', 'XFRACAS QUESTION_PROBLEM_STATE', '01', 'select.questionproblem.state.editing', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000192', '069', 'XFRACAS QUESTION_PROBLEM_STATE', '02', 'select.questionproblem.state.responsibilityaauditing', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000193', '069', 'XFRACAS QUESTION_PROBLEM_STATE', '03', 'select.questionproblem.state.directleaderauditing', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000194', '069', 'XFRACAS QUESTION_PROBLEM_STATE', '04', 'select.questionproblem.state.shoulderdeptauditing', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000195', '069', 'XFRACAS QUESTION_PROBLEM_STATE', '05', 'select.questionproblem.state.resultauditing', '', 5, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000196', '069', 'XFRACAS QUESTION_PROBLEM_STATE', '06', 'select.questionproblem.state.lastleaderauditing', '', 6, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000197', '069', 'XFRACAS QUESTION_PROBLEM_STATE', '07', 'select.questionproblem.state.closeauditing', '', 7, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000198', '070', 'XFRACAS DEAL_TYPE', '1', 'select.deal.type.questionrepeat', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000199', '070', 'XFRACAS DEAL_TYPE', '2', 'select.deal.type.commondeal', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000200', '070', 'XFRACAS DEAL_TYPE', '3', 'select.deal.type.commonregister', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000201', '070', 'XFRACAS DEAL_TYPE', '4', 'select.deal.type.especiallyregister', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000202', '071', 'XFRACAS CASE_STATE', '01', 'select.case.state.casestate1', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000203', '071', 'XFRACAS CASE_STATE', '02', 'select.case.state.casestate2', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000204', '071', 'XFRACAS CASE_STATE', '03', 'select.case.state.casestate3', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000205', '071', 'XFRACAS CASE_STATE', '04', 'select.case.state.casestate4', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000206', '071', 'XFRACAS CASE_STATE', '05', 'select.case.state.casestate5', '', 5, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000207', '071', 'XFRACAS CASE_STATE', '06', 'select.case.state.casestate6', '', 6, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000208', '071', 'XFRACAS CASE_STATE', '07', 'select.case.state.casestate7', '', 7, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000209', '071', 'XFRACAS CASE_STATE', '08', 'select.case.state.casestate8', '', 8, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000210', '071', 'XFRACAS CASE_STATE', '09', 'select.case.state.casestate9', '', 9, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000211', '071', 'XFRACAS CASE_STATE', '10', 'select.case.state.casestate10', '', 10, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000212', '071', 'XFRACAS CASE_STATE', '11', 'select.case.state.casestate11', '', 11, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000213', '071', 'XFRACAS CASE_STATE', '12', 'select.case.state.casestate12', '', 12, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000214', '071', 'XFRACAS CASE_STATE', '13', 'select.case.state.casestate13', '', 13, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000215', '071', 'XFRACAS CASE_STATE', '14', 'select.case.state.casestate14', '', 14, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000216', '071', 'XFRACAS CASE_STATE', '15', 'select.case.state.casestate15', '', 15, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000217', '071', 'XFRACAS CASE_STATE', '16', 'select.case.state.casestate16', '', 16, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000218', '071', 'XFRACAS CASE_STATE', '17', 'select.case.state.casestate17', '', 17, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000219', '071', 'XFRACAS CASE_STATE', '18', 'select.case.state.casestate18', '', 18, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000220', '071', 'XFRACAS CASE_STATE', '19', 'select.case.state.casestate19', '', 19, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000221', '072', 'XFRACAS CASELEVEL', '1', 'select.case.level.commondeal', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000222', '072', 'XFRACAS CASELEVEL', '2', 'select.case.level.especiallyregister', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000223', '073', 'XFRACAS ACTUALIZE_LIFE_STATE', '01', 'select.case.actualize.lifeState.working', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000224', '073', 'XFRACAS ACTUALIZE_LIFE_STATE', '02', 'select.case.actualize.lifeState.finish', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000225', '074', 'WDA MTBF Calc Option', '1', 'select.analysisobjective.daycount', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000226', '074', 'WDA MTBF Calc Option', '2', 'select.analysisobjective.operatedtime1', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000227', '074', 'WDA MTBF Calc Option', '3', 'select.analysisobjective.operatedtime2', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000228', '074', 'WDA MTBF Calc Option', '4', 'select.analysisobjective.operatedtime3', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000229', '075', 'Language', '1', 'select.lang.zh', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000230', '075', 'Language', '2', 'select.lang.en', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000231', '075', 'Language', '3', 'select.lang.ru', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000232', '075', 'Language', '4', 'select.lang.fr', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000233', '075', 'Language', '5', 'select.lang.de', '', 5, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000234', '075', 'Language', '6', 'select.lang.ja', '', 6, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000235', '075', 'Language', '7', 'select.lang.da', '', 7, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000236', '075', 'Language', '8', 'select.lang.uk', '', 8, '1', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000237', '075', 'Language', '9', 'select.lang.bg', '', 9, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000238', '075', 'Language', '10', 'select.lang.hr', '', 10, '1', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000239', '075', 'Language', '11', 'select.lang.is', '', 11, '1', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000240', '075', 'Language', '12', 'select.lang.hu', '', 12, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000241', '075', 'Language', '13', 'select.lang.in', '', 13, '1', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000242', '075', 'Language', '14', 'select.lang.tr', '', 14, '1', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000243', '075', 'Language', '15', 'select.lang.sr', '', 15, '1', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000244', '075', 'Language', '16', 'select.lang.el', '', 16, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000245', '075', 'Language', '17', 'select.lang.it', '', 17, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000246', '075', 'Language', '18', 'select.lang.no', '', 18, '1', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000247', '075', 'Language', '19', 'select.lang.cs', '', 19, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000248', '075', 'Language', '20', 'select.lang.sk', '', 20, '1', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000249', '075', 'Language', '21', 'select.lang.sl', '', 21, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000250', '075', 'Language', '22', 'select.lang.ko', '', 22, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000251', '075', 'Language', '23', 'select.lang.pl', '', 23, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000252', '075', 'Language', '24', 'select.lang.th', '', 24, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000253', '075', 'Language', '25', 'select.lang.ga', '', 25, '1', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000254', '075', 'Language', '26', 'select.lang.et', '', 26, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000255', '075', 'Language', '27', 'select.lang.sv', '', 27, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000256', '075', 'Language', '28', 'select.lang.be', '', 28, '1', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000257', '075', 'Language', '29', 'select.lang.lt', '', 29, '1', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000258', '075', 'Language', '30', 'select.lang.ro', '', 30, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000259', '075', 'Language', '31', 'select.lang.fi', '', 31, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000260', '075', 'Language', '32', 'select.lang.nl', '', 32, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000261', '075', 'Language', '33', 'select.lang.pt', '', 33, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000262', '075', 'Language', '34', 'select.lang.es', '', 34, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000263', '075', 'Language', '35', 'select.lang.vi', '', 35, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000264', '075', 'Language', '36', 'select.lang.ar', '', 36, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000265', '075', 'Language', '37', 'select.lang.ms', '', 37, '1', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000266', '076', 'R-FMEA-Action-state', '01', 'select.action.not.do', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000267', '076', 'R-FMEA-Action-state', '02', 'select.action.wait.decide', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000268', '076', 'R-FMEA-Action-state', '03', 'select.action.wait.execute', '', 3, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000269', '076', 'R-FMEA-Action-state', '04', 'select.action.give.up', '', 4, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000270', '077', 'R-FMEA-Action-Type', '09', 'select.rfm.actiontype.prevent', '', 1, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000271', '077', 'R-FMEA-Action-Type', '10', 'select.rfm.actiontype.detect', '', 2, '0', '2021-05-21 17:36:50', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000272', '075', 'Language', '38', 'select.lang.tw', '', 38, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000273', '076', 'R-FMEA-Action-state', '05', 'select.action.finish', '', 5, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000274', '078', 'diagram', '01', 'select.diagram.p1', '', 1, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000275', '078', 'diagram', '01', 'select.diagram.p2', '', 2, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000276', '078', 'diagram', '01', 'select.diagram.p3', '', 3, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000277', '078', 'diagram', '01', 'select.diagram.p4', '', 4, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000278', '078', 'diagram', '01', 'select.diagram.p5', '', 5, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000279', '078', 'diagram', '01', 'select.diagram.p6', '', 6, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000280', '078', 'diagram', '01', 'select.diagram.p7', '', 7, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000281', '078', 'diagram', '01', 'select.diagram.p8', '', 8, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000282', '078', 'diagram', '01', 'select.diagram.p9', '', 9, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000283', '078', 'diagram', '01', 'select.diagram.p10', '', 10, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000284', '078', 'diagram', '01', 'select.diagram.p11', '', 11, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000285', '078', 'diagram', '01', 'select.diagram.p12', '', 12, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000286', '078', 'diagram', '02', 'select.diagram.e1', '', 1, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000287', '078', 'diagram', '02', 'select.diagram.e2', '', 2, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000288', '078', 'diagram', '02', 'select.diagram.e3', '', 3, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000289', '078', 'diagram', '02', 'select.diagram.e4', '', 4, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000290', '078', 'diagram', '02', 'select.diagram.e5', '', 5, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000291', '078', 'diagram', '03', 'select.diagram.i1', '', 1, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000292', '078', 'diagram', '03', 'select.diagram.i2', '', 2, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000293', '078', 'diagram', '03', 'select.diagram.i3', '', 3, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000294', '078', 'diagram', '04', 'select.diagram.m1', '', 1, '0', '2021-05-21 17:36:52', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000295', '079', 'Rdfm Export File Type', '01', 'select.exportFileType.FMEA', '', 1, '0', '2021-05-21 17:37:51', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000296', '079', 'Rdfm Export File Type', '02', 'select.exportFileType.DRBFM', '', 2, '0', '2021-05-21 17:37:51', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000297', '079', 'Rdfm Export File Type', '03', 'select.exportFileType.DVPR', '', 3, '0', '2021-05-21 17:37:51', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000298', '079', 'Rdfm Export File Type', '04', 'select.exportFileType.FeatureList', '', 4, '0', '2021-05-21 17:37:51', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000299', '080', 'Rpfm Export File Type', '01', 'select.rpfmExportFileType.FMEA', '', 1, '0', '2021-05-21 17:37:51', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000300', '080', 'Rpfm Export File Type', '02', 'select.rpfmExportFileType.ProcessFlowChart', '', 2, '0', '2021-05-21 17:37:51', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000301', '080', 'Rpfm Export File Type', '03', 'select.rpfmExportFileType.Controlplan', '', 3, '0', '2021-05-21 17:37:51', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000302', '080', 'Rpfm Export File Type', '04', 'select.rpfmExportFileType.Inspectionplan', '', 4, '0', '2021-05-21 17:37:51', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000303', '080', 'Rpfm Export File Type', '05', 'select.rpfmExportFileType.FeatureList', '', 5, '0', '2021-05-21 17:37:51', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000304', '068', 'APPROVE TYPE', '04', 'select.approve.type.versionUpgrade', '', 4, '0', '2021-07-05 11:45:02', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000305', '081', 'R-FMEA-Action-State', '14', 'select.rfm.actionstate.current', '', 1, '0', '2021-12-24 10:41:39', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000306', '081', 'R-FMEA-Action-State', '07', 'select.rfm.actionstate.optimization', '', 2, '0', '2021-12-24 10:41:39', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000307', '082', 'rdfm-pd-code', '01', 'select.pd.p2p', '', 1, '0', '2022-02-10 10:41:39', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000308', '082', 'rdfm-pd-code', '02', 'select.pd.cot', '', 2, '0', '2022-02-10 10:41:39', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000309', '082', 'rdfm-pd-code', '03', 'select.pd.cug', '', 3, '0', '2022-02-10 10:41:39', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000310', '082', 'rdfm-pd-code', '04', 'select.pd.env', '', 4, '0', '2022-02-10 10:41:39', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000311', '082', 'rdfm-pd-code', '05', 'select.pd.sia', '', 5, '0', '2022-02-10 10:41:39', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000312', '082', 'rdfm-pd-code', '06', 'select.pd.in', '', 6, '0', '2022-02-10 10:41:39', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000313', '082', 'rdfm-pd-code', '07', 'select.pd.out', '', 7, '0', '2022-02-10 10:41:39', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000314', '082', 'rdfm-pd-code', '08', 'select.pd.func', '', 8, '0', '2022-02-10 10:41:39', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000315', '082', 'rdfm-pd-code', '09', 'select.pd.fr', '', 9, '0', '2022-02-10 10:41:39', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000316', '082', 'rdfm-pd-code', '10', 'select.pd.kpc', '', 10, '0', '2022-02-10 10:41:39', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000317', '082', 'rdfm-pd-code', '11', 'select.pd.un.fr', '', 11, '0', '2022-02-10 10:41:39', 'system', 'system', NULL, '', '', 1);
INSERT INTO `t_cm_code` VALUES ('000000000000000000000318', '082', 'rdfm-pd-code', '12', 'select.pd.un.eo', '', 12, '0', '2022-02-10 10:41:39', 'system', 'system', NULL, '', '', 1);

-- ----------------------------
-- Table structure for t_data_lock
-- ----------------------------
CREATE TABLE `t_data_lock`  (
  `LOCK_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LOCK_TIME` datetime NULL DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSERT_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UPDATE_TIME` datetime NULL DEFAULT NULL,
  `UPDATE_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`LOCK_ID`) USING BTREE,
  UNIQUE INDEX `LOCK_ID`(`LOCK_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_sys_user_theme
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user_theme`;
CREATE TABLE `t_sys_user_theme`  (
  `USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `THEME_ID` smallint(6) NULL DEFAULT NULL,
  PRIMARY KEY (`USER_ID`) USING BTREE,
  UNIQUE INDEX `USER_ID`(`USER_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_sys_watermark
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_watermark`;
CREATE TABLE `t_sys_watermark`  (
  `WATERMARK_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `WARNING_TEXT` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CORPORATE_NAME` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DISPLAY_WARNING_TEXT` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DISPLAY_CORPORATE_NAME` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DISPLAY_LOGIN_ACCOUNT` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DISPLAY_SYSTEM_TIME` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DISPLAY_IP` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `WATERMARK_WIDTH` int(11) NULL DEFAULT NULL,
  `WATERMARK_HEIGHT` int(11) NULL DEFAULT NULL,
  `WATERMARK_ANGLE` int(11) NULL DEFAULT NULL,
  `WATERMARK_FONT` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `WATERMARK_FONTSIZE` int(11) NULL DEFAULT NULL,
  `WATERMARK_ALPHA` double NULL DEFAULT NULL,
  `WATERMARK_COLOR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `WATERMARK_Y_SPACE` int(11) NULL DEFAULT NULL,
  `WATERMARK_X_SPACE` int(11) NULL DEFAULT NULL,
  `WATERMARK_COLS` int(11) NULL DEFAULT NULL,
  `WATERMARK_ROWS` int(11) NULL DEFAULT NULL,
  `WATERMARK_Y` int(11) NULL DEFAULT NULL,
  `WATERMARK_X` int(11) NULL DEFAULT NULL,
  `EXT_INFO1` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `EXT_INFO2` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `EXT_INFO3` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DISPLAY_EXT_INFO1` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DISPLAY_EXT_INFO2` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DISPLAY_EXT_INFO3` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `STATE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSERT_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UPDATE_TIME` datetime NULL DEFAULT NULL,
  `UPDATE_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`WATERMARK_ID`) USING BTREE,
  UNIQUE INDEX `WATERMARK_ID`(`WATERMARK_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_sys_task
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_task`;
CREATE TABLE `t_sys_task`  (
  `TASK_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TASK_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TASK_TYPE` char(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `BUSINESS_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TASK_SOURCE_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `RESPONSIBLE` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `PLAN_START_DATE` datetime NULL DEFAULT NULL,
  `PLAN_END_DATE` datetime NULL DEFAULT NULL,
  `CONTEXT_ENV` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `START_DATE` datetime NULL DEFAULT NULL,
  `END_DATE` datetime NULL DEFAULT NULL,
  `PERCENT` decimal(5, 2) NULL DEFAULT NULL,
  `DESCRIPTION` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `EXT_INFO1` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `EXT_INFO2` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `EXT_INFO3` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LIFE_STATE` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `RELEASE_TIME` datetime NULL DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSERT_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UPDATE_TIME` datetime NULL DEFAULT NULL,
  `UPDATE_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`TASK_ID`) USING BTREE,
  UNIQUE INDEX `TASK_ID`(`TASK_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_sys_delivery
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_delivery`;
CREATE TABLE `t_sys_delivery`  (
  `TASK_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DELIVERY_TYPE` char(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DELIVERY_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSERT_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UPDATE_TIME` datetime NULL DEFAULT NULL,
  `UPDATE_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`TASK_ID`, `DELIVERY_TYPE`, `DELIVERY_ID`) USING BTREE,
  UNIQUE INDEX `TASK_ID`(`TASK_ID`, `DELIVERY_TYPE`, `DELIVERY_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_sys_watermark
-- ----------------------------
INSERT INTO `t_sys_watermark` VALUES ('10000000000000000000000000000000', '禁止拍照', '国可工软', '0', '0', '1', '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '2021-03-26 13:20:38', 'system', 'system', '2022-03-07 19:09:26', 'U00000047', 'Rb0102401', 77);

-- ----------------------------
-- Table structure for t_sys_share
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_share`;
CREATE TABLE `t_sys_share`  (
  `DOCUMENT_TYPE` char(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DOCUMENT_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TARGET_TYPE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TARGET` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DETAIL_NO` smallint(6) NULL DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSERT_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UPDATE_TIME` datetime NULL DEFAULT NULL,
  `UPDATE_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`DOCUMENT_TYPE`, `DOCUMENT_ID`, `TARGET_TYPE`, `TARGET`) USING BTREE,
  UNIQUE INDEX `DOCUMENT_TYPE`(`DOCUMENT_TYPE`, `DOCUMENT_ID`, `TARGET_TYPE`, `TARGET`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_sys_share_approve
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_share_approve`;
CREATE TABLE `t_sys_share_approve`  (
  `SHARE_APPROVE_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DOCUMENT_TYPE` char(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DOCUMENT_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ACTIVE_FLAG` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DEL_FLAG` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `LIFE_STATE` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSERT_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UPDATE_TIME` datetime NULL DEFAULT NULL,
  `UPDATE_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`SHARE_APPROVE_ID`) USING BTREE,
  UNIQUE INDEX `SHARE_APPROVE_ID`(`SHARE_APPROVE_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_sys_share_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_share_detail`;
CREATE TABLE `t_sys_share_detail`  (
  `DETAIL_NO` smallint(6) NOT NULL,
  `SHARE_APPROVE_ID` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TARGET_TYPE` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TARGET` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `OPERATE_FLAG` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `INSERT_TIME` datetime NOT NULL,
  `INSERT_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSERT_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UPDATE_TIME` datetime NULL DEFAULT NULL,
  `UPDATE_USER_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UPDATE_PGM_ID` char(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `VERSION_NO` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`DETAIL_NO`, `SHARE_APPROVE_ID`) USING BTREE,
  UNIQUE INDEX `DETAIL_NO`(`DETAIL_NO`, `SHARE_APPROVE_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;