1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089 |
- /*
- 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;
|