03_field_mapping.md 58 KB
字段映射表 — ROHS → 安监(slaj)
给改 ROHS 代码的团队使用。包含所有列名变更、类型变更的完整对照。
一、新表（73张）
以下表在安监中不存在，本次新建。ROHS 代码侧需：
- 连接 schema 从
SLAJ_ROHS改为slaj - 表名和列名统一改为小写
| ROHS 表名 | 安监表名 | 列数 | 表说明 |
|---|---|---|---|
| ATT_APP_BASE | att_app_base |
21 | - |
| ATT_JOB_BASE | att_job_base |
12 | - |
| ATT_ORG_BASE20250113 | att_org_base20250113 |
17 | - |
| ATT_ORG_DEP | att_org_dep |
13 | - |
| ATT_PERSON_EXT | att_person_ext |
23 | - |
| ATT_ROLE_BASE | att_role_base |
13 | - |
| ATT_USER_EXT | att_user_ext |
9 | - |
| BDMS_ATT_ENG_PUST | bdms_att_eng_pust |
33 | - |
| BIS_HIDD_REC_REP20250113 | bis_hidd_rec_rep20250113 |
10 | - |
| HARD_TOTAL | hard_total |
31 | - |
| HIDD_STATISTICS | hidd_statistics |
38 | - |
| OBJ_AD | obj_ad |
5 | 行政区划名录表 |
| OBJ_BAAD | obj_baad |
5 | - |
| OBJ_HAZARD20250113 | obj_hazard20250113 |
16 | - |
| OBJ_HAZARDBAK | obj_hazardbak |
16 | - |
| OBJ_HIDD20250113 | obj_hidd20250113 |
32 | - |
| OBJ_HIDDD | obj_hiddd |
33 | - |
| OBJ_ORG_ZCPT | obj_org_zcpt |
9 | - |
| OBJ_ROLE | obj_role |
6 | - |
| OBJ_TEND20250113 | obj_tend20250113 |
15 | - |
| PPRTY_NOTICE_INFO | pprty_notice_info |
12 | - |
| REL_DRILL_EVA | rel_drill_eva |
11 | 演练评估与预案关系表 |
| REL_DRILL_SC | rel_drill_sc |
17 | 演练抽查结果表 |
| REL_INSURE_TEND | rel_insure_tend |
5 | 保险和标段关系表 |
| REL_INSURE_TEND20250113 | rel_insure_tend20250113 |
5 | - |
| REL_JOB_ROLE | rel_job_role |
8 | - |
| REL_ORG_ZCPT | rel_org_zcpt |
5 | 机构与支撑平台关系 |
| REL_PERS_ZCPT | rel_pers_zcpt |
4 | 机构与支撑平台关系 |
| REL_SYS_PERS | rel_sys_pers |
2 | - |
| REL_USER_APP | rel_user_app |
10 | - |
| REL_USER_APPOINT | rel_user_appoint |
9 | - |
| REL_USER_JOB | rel_user_job |
8 | - |
| REL_USER_ROLE | rel_user_role |
9 | - |
| REL_USER_ROLE_EXT | rel_user_role_ext |
8 | - |
| T_BUSI_ACCI_EVALUATE | t_busi_acci_evaluate |
18 | 事故风险评价 |
| T_BUSI_ACCOUNT_RECORD | t_busi_account_record |
10 | 责任追究记录 |
| T_BUSI_BD_TOTAL | t_busi_bd_total |
13 | - |
| T_BUSI_CONPLAN_BASIC20250113 | t_busi_conplan_basic20250113 |
20 | - |
| T_BUSI_CONT_MEAS | t_busi_cont_meas |
21 | - |
| T_BUSI_DATA_TYPE_LEVEL | t_busi_data_type_level |
24 | - |
| T_BUSI_DRILL_EVA | t_busi_drill_eva |
10 | 应急演练评估信息表 |
| T_BUSI_DRILL_RECORD | t_busi_drill_record |
16 | 演练实施记录表 |
| T_BUSI_ENG_PART | t_busi_eng_part |
14 | 区域管理信息表 |
| T_BUSI_ENG_SAFE_EVALUATE | t_busi_eng_safe_evaluate |
14 | 工程安全生产风险值 |
| T_BUSI_EVALUATE | t_busi_evaluate |
18 | - |
| T_BUSI_GROUP_INFO | t_busi_group_info |
10 | 安全机构成员表 |
| T_BUSI_HARD_TOTAL | t_busi_hard_total |
35 | 非工程辨识率 |
| T_BUSI_HAZARD_REPORT20250113 | t_busi_hazard_report20250113 |
9 | - |
| T_BUSI_HAZ_IDENBAK | t_busi_haz_idenbak |
10 | - |
| T_BUSI_HIDD_EVALUATE | t_busi_hidd_evaluate |
18 | 隐患风险评价 |
| T_BUSI_HIDD_TOTAL | t_busi_hidd_total |
47 | 隐患排查排名表 |
| T_BUSI_HUIZONG_TOTAL | t_busi_huizong_total |
19 | 汇总统计 |
| T_BUSI_INSURE_INFO | t_busi_insure_info |
34 | 项目保险信息表 |
| T_BUSI_INSURE_INFO20250113 | t_busi_insure_info20250113 |
34 | - |
| T_BUSI_INSURE_PRE | t_busi_insure_pre |
16 | 安全险事故预防服务表 |
| T_BUSI_MEET_TOTAL | t_busi_meet_total |
19 | 应急排名表 |
| T_BUSI_ORG_SAFE_EVALUATE | t_busi_org_safe_evaluate |
15 | 单位安全生产风险值 |
| T_BUSI_POSSIBLE_ACCIDENT | t_busi_possible_accident |
7 | 或有事故 |
| T_BUSI_POSTRES | t_busi_postres |
9 | - |
| T_BUSI_POSTRES_PERSON | t_busi_postres_person |
10 | - |
| T_BUSI_SAFEORG_INFO | t_busi_safeorg_info |
8 | 安全机构 |
| T_BUSI_SIX_BOOST_MWR | t_busi_six_boost_mwr |
32 | 六项机制推进部直属 |
| T_BUSI_SMS_RECORD | t_busi_sms_record |
4 | - |
| T_BUSI_STR_PUNISH | t_busi_str_punish |
12 | 处罚信息表 |
| T_BUSI_SUPPLIES_RESERVE | t_busi_supplies_reserve |
14 | 应急物资和储备表 |
| T_BUSI_TEAM_INFO | t_busi_team_info |
11 | 应急队伍信息表 |
| T_BUSI_TRAIN_RECORD | t_busi_train_record |
13 | 应急培训记录表 |
| T_CON_SAFE_ENU | t_con_safe_enu |
7 | 安监枚举表 |
| T_CON_SLAJ_LOG | t_con_slaj_log |
27 | - |
| T_DICT_SCOR_CERTI | t_dict_scor_certi |
12 | - |
| T_DICT_SCOR_PUNISH | t_dict_scor_punish |
8 | - |
| T_SSO_USERROLE_SM3 | t_sso_userrole_sm3 |
4 | - |
| T_SSO_USER_SM3 | t_sso_user_sm3 |
3 | - |
二、重叠表字段映射（37张）
ATT_ENG_BASE → att_eng_base
操作: 3个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| PGUID | PGUID | CHAR(32) | BPCHAR | 一致 |
| AD_GUID | AD_GUID | CHAR(32) | BPCHAR | 一致 |
| AD_CODE | AD_CODE | VARCHAR(20) | VARCHAR | 一致 |
| LK_GUID | LK_GUID | CHAR(32) | BPCHAR | 一致 |
| ENG_NAME | ENG_NAME | VARCHAR(100) | VARCHAR | 一致 |
| ENG_GUID | ENG_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_REST | ORG_REST | CHAR(32) | BPCHAR | 一致 |
| ORG_JURD | ORG_JURD | CHAR(32) | BPCHAR | 一致 |
| OLD_CODE | OLD_CODE | VARCHAR(12) | VARCHAR | 一致 |
| IMPO_GRAD | IMPO_GRAD | CHAR(1) | BPCHAR | 一致 |
| ENG_SCAL | ENG_SCAL | CHAR(1) | BPCHAR | 一致 |
| APPR_BUDG | APPR_BUDG | DECIMAL(12,4) | NUMERIC | 一致 |
| IF_REIN_FORCE | IF_REIN_FORCE | CHAR(1) | BPCHAR | 一致 |
| ENG_GRAD | ENG_GRAD | CHAR(1) | BPCHAR | 一致 |
| TOT_CAP | TOT_CAP | DECIMAL(13,3) | NUMERIC | 一致 |
| RES_CODE | RES_CODE | VARCHAR(20) | VARCHAR | 一致 |
| START_LONG | START_LONG | DECIMAL(11,8) | NUMERIC | 一致 |
| START_LAT | START_LAT | DECIMAL(10,8) | NUMERIC | 一致 |
| END_LONG | END_LONG | DECIMAL(11,8) | NUMERIC | 一致 |
| END_LAT | END_LAT | DECIMAL(10,8) | NUMERIC | 一致 |
| START_LOC | START_LOC | VARCHAR(256) | VARCHAR | 一致 |
| END_LOC | END_LOC | VARCHAR(256) | VARCHAR | 一致 |
| FIRS_POIN_AD_GUID | FIRS_POIN_AD_GUID | CHAR(32) | BPCHAR | 一致 |
| END_AD_GUID | END_AD_GUID | CHAR(32) | BPCHAR | 一致 |
| RV_GUID | RV_GUID | CHAR(32) | BPCHAR | 一致 |
| DES_FL_STAND | DES_FL_STAND | DECIMAL(5,0) | NUMERIC | 一致 |
| OFLP_CODE | OFLP_CODE | CHAR(32) | BPCHAR | 一致 |
| PROJ_GUID | PROJ_GUID | CHAR(32) | BPCHAR | 一致 |
| CEN_LONG | CEN_LONG | DECIMAL(11,8) | NUMERIC | 一致 |
| CEN_LAT | CEN_LAT | DECIMAL(10,8) | NUMERIC | 一致 |
| STAT | STAT | CHAR(1) | BPCHAR | 一致 |
| START_DATE | START_DATE | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| COMP_DATE | COMP_DATE | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| ENG_STAT | ENG_STAT | CHAR(1) | BPCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| ENG_REIN_FORCE_GUID | ENG_REIN_FORCE_GUID | CHAR(32) | BPCHAR | 一致 |
| NOTE | NOTE | VARCHAR(256) | VARCHAR | 一致 |
| COLL_TIME | COLL_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| UPD_TIME | UPD_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| FROM_DATE | FROM_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| REC_PERS | REC_PERS | CHAR(32) | BPCHAR | 一致 |
| ENG_CODE | ENG_CODE | VARCHAR(40) | VARCHAR | 一致 |
| ENG_TYPE | ENG_TYPE | CHAR(2) | BPCHAR | 一致 |
| WIUN_WDEV_NAME | WIUN_WDEV_NAME | VARCHAR(1000) | VARCHAR | 一致 |
| WIUN_WSUP_NAME | WIUN_WSUP_NAME | VARCHAR(1000) | VARCHAR | 一致 |
| WIUN_WCON_NAME | WIUN_WCON_NAME | VARCHAR(1000) | VARCHAR | 一致 |
| WIUN_WSUR_NAME | WIUN_WSUR_NAME | VARCHAR(1000) | VARCHAR | 一致 |
| WIUN_ACOR_NAME | WIUN_ACOR_NAME | VARCHAR(1000) | VARCHAR | 一致 |
| WIUN_QSS_NAME | WIUN_QSS_NAME | VARCHAR(1000) | VARCHAR | 一致 |
| GOV_LEG_PERS | GOV_LEG_PERS | VARCHAR(100) | VARCHAR | 一致 |
| GOV_LEG_PERS_DUTY | GOV_LEG_PERS_DUTY | VARCHAR(100) | VARCHAR | 一致 |
| GOV_LEG_PERS_TEL | GOV_LEG_PERS_TEL | VARCHAR(100) | VARCHAR | 一致 |
| WIUN_WAO_LEG_PERS | WIUN_WAO_LEG_PERS | VARCHAR(100) | VARCHAR | 一致 |
| WIUN_WAO_LEG_PERS_DUTY | WIUN_WAO_LEG_PERS_DUTY | VARCHAR(100) | VARCHAR | 一致 |
| WIUN_WAO_LEG_PERS_TEL | WIUN_WAO_LEG_PERS_TEL | VARCHAR(100) | VARCHAR | 一致 |
| LEG_PERS | LEG_PERS | VARCHAR(100) | VARCHAR | 一致 |
| LEG_PERS_DUTY | LEG_PERS_DUTY | VARCHAR(100) | VARCHAR | 一致 |
| LEG_PERS_TEL | LEG_PERS_TEL | VARCHAR(100) | VARCHAR | 一致 |
| CHAR_PERS | CHAR_PERS | VARCHAR(100) | VARCHAR | 一致 |
| CHAR_PERS_DUTY | CHAR_PERS_DUTY | VARCHAR(100) | VARCHAR | 一致 |
| CHAR_PERS_TEL | CHAR_PERS_TEL | VARCHAR(100) | VARCHAR | 一致 |
| RES_LOC | RES_LOC | VARCHAR(256) | VARCHAR | 一致 |
| DAM_TYPE_MAT | DAM_TYPE_MAT | CHAR(1) | BPCHAR | 一致 |
| DAM_TYPE_STR | DAM_TYPE_STR | CHAR(1) | BPCHAR | 一致 |
| DAM_SIZE_HIG | DAM_SIZE_HIG | DECIMAL(18,2) | NUMERIC | 一致 |
| DAM_SIZE_LEN | DAM_SIZE_LEN | DECIMAL(18,2) | NUMERIC | 一致 |
| DAM_CRE_ELV | DAM_CRE_ELV | DECIMAL(18,2) | NUMERIC | 一致 |
| FL_LOW_LIM_LEV | FL_LOW_LIM_LEV | DECIMAL(15,3) | NUMERIC | 一致 |
| FL_LOW_LIM_LEV_END | FL_LOW_LIM_LEV_END | TIMESTAMP | TIMESTAMP | 一致 |
| DES_FL_STAG | DES_FL_STAG | DECIMAL(15,3) | NUMERIC | 一致 |
| MAIN_FL_TYPE | MAIN_FL_TYPE | CHAR(1) | BPCHAR | 一致 |
| DEAD_LEV | DEAD_LEV | DECIMAL(14,2) | NUMERIC | 一致 |
| DEAD_CAP | DEAD_CAP | DECIMAL(10,3) | NUMERIC | 一致 |
| FLCO_CAP | FLCO_CAP | DECIMAL(9,2) | NUMERIC | 一致 |
| WAGA_CODE | WAGA_CODE | VARCHAR(20) | VARCHAR | 一致 |
| WAGA_LOC | WAGA_LOC | VARCHAR(256) | VARCHAR | 一致 |
| WAGA_TYPE | WAGA_TYPE | CHAR(1) | BPCHAR | 一致 |
| GAOR_NUM | GAOR_NUM | DECIMAL(2,0) | NUMERIC | 一致 |
| LOCK_DISC | LOCK_DISC | DECIMAL(8,2) | NUMERIC | 一致 |
| ENER_DISS | ENER_DISS | CHAR(1) | BPCHAR | 一致 |
| PUST_CODE | PUST_CODE | VARCHAR(20) | VARCHAR | 一致 |
| PUST_LOC | PUST_LOC | VARCHAR(256) | VARCHAR | 一致 |
| PUST_TYPE | PUST_TYPE | CHAR(1) | BPCHAR | 一致 |
| DES_HEAD | DES_HEAD | DECIMAL(8,2) | NUMERIC | 一致 |
| INS_FLOW | INS_FLOW | DECIMAL(15,4) | NUMERIC | 一致 |
| DES_FLOW | DES_FLOW | DECIMAL(15,4) | NUMERIC | 一致 |
| PUST_NUM | PUST_NUM | DECIMAL(2,0) | NUMERIC | 一致 |
| INS_POW | INS_POW | DECIMAL(8,3) | NUMERIC | 一致 |
| HYST_CODE | HYST_CODE | VARCHAR(20) | VARCHAR | 一致 |
| IF_RS_POW | IF_RS_POW | CHAR(1) | BPCHAR | 一致 |
| RES_NAME | RES_NAME | VARCHAR(100) | VARCHAR | 一致 |
| HYST_SITE | HYST_SITE | VARCHAR(256) | VARCHAR | 一致 |
| HYST_TYPE | HYST_TYPE | CHAR(1) | BPCHAR | 一致 |
| IF_RHYST | IF_RHYST | CHAR(1) | BPCHAR | 一致 |
| INS_CAP | INS_CAP | DECIMAL(10,2) | NUMERIC | 一致 |
| DAM_REG_CODE | DAM_REG_CODE | VARCHAR(20) | VARCHAR | 一致 |
| DAM_IDEN_CATE | DAM_IDEN_CATE | CHAR(1) | BPCHAR | 一致 |
| DAM_IDEN_ORG | DAM_IDEN_ORG | VARCHAR(100) | VARCHAR | 一致 |
| DAM_IDEN_DATE | DAM_IDEN_DATE | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| DAM_HIG | DAM_HIG | DECIMAL(18,2) | NUMERIC | 一致 |
| DIKE_CODE | DIKE_CODE | VARCHAR(20) | VARCHAR | 一致 |
| DIKE_GRAD | DIKE_GRAD | CHAR(1) | BPCHAR | 一致 |
| DIKE_TYPE | DIKE_TYPE | CHAR(1) | BPCHAR | 一致 |
| DIKE_LEN | DIKE_LEN | DECIMAL(12,2) | NUMERIC | 一致 |
| DIKE_SLOPE | DIKE_SLOPE | DECIMAL(8,2) | NUMERIC | 一致 |
| RV_BANK | RV_BANK | VARCHAR(6) | VARCHAR | 一致 |
| CROS_SITU | CROS_SITU | CHAR(1) | BPCHAR | 一致 |
| IF_ROAD | IF_ROAD | CHAR(1) | BPCHAR | 一致 |
| IRR_CODE | IRR_CODE | VARCHAR(20) | VARCHAR | 一致 |
| IRR_LOC | IRR_LOC | VARCHAR(256) | VARCHAR | 一致 |
| TOT_IRR_AREA | TOT_IRR_AREA | DECIMAL(10,0) | NUMERIC | 一致 |
| EFF_IRR_AREA | EFF_IRR_AREA | DECIMAL(10,0) | NUMERIC | 一致 |
| DES_IRR_AREA | DES_IRR_AREA | DECIMAL(12,2) | NUMERIC | 一致 |
| CHAN_HIGN_LEVE | CHAN_HIGN_LEVE | CHAR(1) | BPCHAR | 一致 |
| CHAN_NUM | CHAN_NUM | DECIMAL(10,0) | NUMERIC | 一致 |
| CHAN_LEN_TOT | CHAN_LEN_TOT | DECIMAL(8,2) | NUMERIC | 一致 |
| CHAN_DES_FLOW | CHAN_DES_FLOW | DECIMAL(10,2) | NUMERIC | 一致 |
| CHSY_GATE_NUM | CHSY_GATE_NUM | DECIMAL(10,0) | NUMERIC | 一致 |
| CHSY_AQU_NUM | CHSY_AQU_NUM | DECIMAL(10,0) | NUMERIC | 一致 |
| CHSY_DROP_NUM | CHSY_DROP_NUM | DECIMAL(10,0) | NUMERIC | 一致 |
| CHSY_INV_SIPH_NUM | CHSY_INV_SIPH_NUM | DECIMAL(10,0) | NUMERIC | 一致 |
| CHSY_TUN_NUM | CHSY_TUN_NUM | DECIMAL(10,0) | NUMERIC | 一致 |
| CHSY_CUL_NUM | CHSY_CUL_NUM | DECIMAL(10,0) | NUMERIC | 一致 |
| CHSY_FARM_BRI_NUM | CHSY_FARM_BRI_NUM | DECIMAL(10,0) | NUMERIC | 一致 |
| CHSY_MEA_NUM | CHSY_MEA_NUM | DECIMAL(10,0) | NUMERIC | 一致 |
| CHSY_DIT_PUST_ST_NUM | CHSY_DIT_PUST_ST_NUM | DECIMAL(10,0) | NUMERIC | 一致 |
| WADI_CODE | WADI_CODE | VARCHAR(20) | VARCHAR | 一致 |
| LINE_TOT_LEN | LINE_TOT_LEN | DECIMAL(8,2) | NUMERIC | 一致 |
| DES_PUMP_DIS | DES_PUMP_DIS | DECIMAL(16,2) | NUMERIC | 一致 |
| DES_PUMP_VOL | DES_PUMP_VOL | DECIMAL(19,3) | NUMERIC | 一致 |
| SD_CODE | SD_CODE | VARCHAR(20) | VARCHAR | 一致 |
| SD_LOC | SD_LOC | VARCHAR(256) | VARCHAR | 一致 |
| CON_AREA | CON_AREA | DECIMAL(9,2) | NUMERIC | 一致 |
| WARP_CAP | WARP_CAP | DECIMAL(9,2) | NUMERIC | 一致 |
| SD_SIZE_LEN | SD_SIZE_LEN | DECIMAL(7,2) | NUMERIC | 一致 |
| SD_SIZE_HIG | SD_SIZE_HIG | DECIMAL(7,3) | NUMERIC | 一致 |
| CWS_CODE | CWS_CODE | VARCHAR(20) | VARCHAR | 一致 |
| CWS_LOC | CWS_LOC | VARCHAR(256) | VARCHAR | 一致 |
| WINT_WS_TYPE | WINT_WS_TYPE | CHAR(1) | BPCHAR | 一致 |
| WASU_TYPE | WASU_TYPE | CHAR(1) | BPCHAR | 一致 |
| DES_WASU_SCAL | DES_WASU_SCAL | DECIMAL(18,2) | NUMERIC | 一致 |
| DES_WASU_POP | DES_WASU_POP | DECIMAL(8,4) | NUMERIC | 一致 |
| WATE_PURI | WATE_PURI | CHAR(1) | BPCHAR | 一致 |
| FL_LOW_LIM_LEV_START | FL_LOW_LIM_LEV_START | TIMESTAMP | TIMESTAMP | 一致 |
| TO_DATE | TO_DATE | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
ATT_ORG_BASE → att_org_base
表说明: 机构信息表
操作: 1个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| PGUID | PGUID | CHAR(32) | BPCHAR | 一致 |
| ORG_CODE | ORG_CODE | VARCHAR(32) | VARCHAR | 一致 |
| ORG_NAME | ORG_NAME | VARCHAR(512) | VARCHAR | 一致 |
| ORG_LEVEL | ORG_LEVEL | CHAR(2) | BPCHAR | 一致 |
| ORG_GRAD | ORG_GRAD | VARCHAR(512) | VARCHAR | 一致 |
| ORG_TYPE | ORG_TYPE | CHAR(1) | BPCHAR | 一致 |
| ORDERNUM | ORDERNUM | DECIMAL(38,0) | NUMERIC | 一致 |
| AD_CODE | AD_CODE | VARCHAR(100) | BPCHAR | 类型变更: BPCHAR → VARCHAR(100) |
| STATUS | STATUS | CHAR(1) | BPCHAR | 一致 |
| MODIFIER | MODIFIER | CHAR(32) | BPCHAR | 一致 |
| FROM_DATE | FROM_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| NOTE | NOTE | VARCHAR(2048) | VARCHAR | 一致 |
| JURD | JURD | VARCHAR(17) | VARCHAR | 一致 |
| AREA_TYPE | AREA_TYPE | CHAR(1) | BPCHAR | 一致 |
| NODE_CODE | NODE_CODE | VARCHAR(20) | VARCHAR | 一致 |
| TO_DATE | TO_DATE | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
ATT_ORG_EXT → att_org_ext
表说明: 单位信息扩展表
操作: 仅代码侧改动
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| SOC_CRE_CODE | SOC_CRE_CODE | VARCHAR(20) | VARCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| WIUN_NAME | WIUN_NAME | VARCHAR(500) | VARCHAR | 一致 |
| ORG_CLIEN_TYPE | ORG_CLIEN_TYPE | CHAR(1) | BPCHAR | 一致 |
| ORG_LEVEL | ORG_LEVEL | CHAR(2) | BPCHAR | 一致 |
| WIUN_CODE | WIUN_CODE | VARCHAR(20) | VARCHAR | 一致 |
| REG_NAME | REG_NAME | VARCHAR(100) | VARCHAR | 一致 |
| LEG_REP | LEG_REP | VARCHAR(100) | VARCHAR | 一致 |
| WIUN_WAO_LONG | WIUN_WAO_LONG | DECIMAL(11,8) | NUMERIC | 一致 |
| WIUN_WAO_LAT | WIUN_WAO_LAT | DECIMAL(10,8) | NUMERIC | 一致 |
| WIUN_PROP | WIUN_PROP | CHAR(1) | BPCHAR | 一致 |
| ADMIN_WIUN_GUID | ADMIN_WIUN_GUID | CHAR(32) | BPCHAR | 一致 |
| IF_WATE_ENTE | IF_WATE_ENTE | CHAR(1) | BPCHAR | 一致 |
| PRO_ORG_GUID | PRO_ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| IS_LEG_ENTI | IS_LEG_ENTI | CHAR(1) | BPCHAR | 一致 |
| IF_MINI_DIRE | IF_MINI_DIRE | CHAR(1) | BPCHAR | 一致 |
| CONTR_QUAL_GRAD | CONTR_QUAL_GRAD | CHAR(1) | BPCHAR | 一致 |
| CONTR_CERT_NUM | CONTR_CERT_NUM | VARCHAR(40) | VARCHAR | 一致 |
| SUP_QUAL_GRAD | SUP_QUAL_GRAD | CHAR(1) | BPCHAR | 一致 |
| STAN_GRAD | STAN_GRAD | CHAR(1) | BPCHAR | 一致 |
| STAN_CERT_CODE | STAN_CERT_CODE | VARCHAR(40) | VARCHAR | 一致 |
| SAFE_PROD_LICE_CODE | SAFE_PROD_LICE_CODE | VARCHAR(40) | VARCHAR | 一致 |
| FUND_SOUR | FUND_SOUR | CHAR(1) | BPCHAR | 一致 |
| EST_DATE | EST_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| REGI_CAPI | REGI_CAPI | DECIMAL(12,0) | NUMERIC | 一致 |
| ADDR | ADDR | VARCHAR(100) | VARCHAR | 一致 |
| REG_LOC | REG_LOC | VARCHAR(100) | VARCHAR | 一致 |
| MAJ_ACCI | MAJ_ACCI | VARCHAR(100) | VARCHAR | 一致 |
| LEG_PERS | LEG_PERS | VARCHAR(40) | VARCHAR | 一致 |
| LEG_PERS_TEL | LEG_PERS_TEL | VARCHAR(40) | VARCHAR | 一致 |
| CONTA_PERS | CONTA_PERS | VARCHAR(40) | VARCHAR | 一致 |
| CONTA_PERS_MOBI | CONTA_PERS_MOBI | VARCHAR(40) | VARCHAR | 一致 |
| CONTA_PERS_ADDR | CONTA_PERS_ADDR | VARCHAR(100) | VARCHAR | 一致 |
| SAFETY_LEG_PERS | SAFETY_LEG_PERS | VARCHAR(40) | VARCHAR | 一致 |
| SAFETY_LEG_PERS_DUTY | SAFETY_LEG_PERS_DUTY | VARCHAR(40) | VARCHAR | 一致 |
| SAFETY_LEG_PERS_TEL | SAFETY_LEG_PERS_TEL | VARCHAR(22) | VARCHAR | 一致 |
| SAFETY_LEG_PERS_MOPH | SAFETY_LEG_PERS_MOPH | VARCHAR(11) | VARCHAR | 一致 |
| SAFE_PROD_CONTA | SAFE_PROD_CONTA | VARCHAR(40) | VARCHAR | 一致 |
| SAFE_PROD_CONTA_TEL | SAFE_PROD_CONTA_TEL | VARCHAR(22) | VARCHAR | 一致 |
| SAFE_PROD_CONTA_MPOH | SAFE_PROD_CONTA_MPOH | VARCHAR(11) | VARCHAR | 一致 |
| ACC_EME_CONTA | ACC_EME_CONTA | VARCHAR(40) | VARCHAR | 一致 |
| ACC_EME_CONTA_MPOH | ACC_EME_CONTA_MPOH | VARCHAR(11) | VARCHAR | 一致 |
| WORK_POP_NUM | WORK_POP_NUM | DECIMAL(11,0) | NUMERIC | 一致 |
| SAFE_MANA_ORG | SAFE_MANA_ORG | VARCHAR(100) | VARCHAR | 一致 |
| FULL_MANA_TOT | FULL_MANA_TOT | DECIMAL(14,0) | NUMERIC | 一致 |
| SPE_OPER_PERS_TOT | SPE_OPER_PERS_TOT | DECIMAL(14,0) | NUMERIC | 一致 |
| LEG_RESP_PERS_TEL | LEG_RESP_PERS_TEL | VARCHAR(22) | VARCHAR | 一致 |
| LEG_RESP_PERS_FAX | LEG_RESP_PERS_FAX | VARCHAR(22) | VARCHAR | 一致 |
| STAN_CONTA_PERS | STAN_CONTA_PERS | VARCHAR(20) | VARCHAR | 一致 |
| STAN_CONTA_TEL | STAN_CONTA_TEL | VARCHAR(22) | VARCHAR | 一致 |
| STAN_CONTA_FAX | STAN_CONTA_FAX | VARCHAR(22) | VARCHAR | 一致 |
| STAN_CONTA_MOPH | STAN_CONTA_MOPH | VARCHAR(11) | VARCHAR | 一致 |
| STAN_CONTA_EMAIL | STAN_CONTA_EMAIL | VARCHAR(100) | VARCHAR | 一致 |
| NOTE | NOTE | VARCHAR(256) | VARCHAR | 一致 |
| COLL_TIME | COLL_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| UPD_TIME | UPD_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| REC_PERS | REC_PERS | CHAR(32) | BPCHAR | 一致 |
| ORG_TYPE | ORG_TYPE | CHAR(1) | BPCHAR | 一致 |
| CONF_PERS_NAME | CONF_PERS_NAME | VARCHAR(150) | VARCHAR | 一致 |
| CONF_PERS_MOPH | CONF_PERS_MOPH | VARCHAR(22) | VARCHAR | 一致 |
| STAT | STAT | CHAR(1) | BPCHAR | 一致 |
| AD_GUID | AD_GUID | CHAR(32) | BPCHAR | 一致 |
| WIUN_DUTY | WIUN_DUTY | VARCHAR(1000) | VARCHAR | 一致 |
| ACC_EMECONTA | ACC_EMECONTA | (不存在) | VARCHAR | 安监独有（ROHS代码可忽略） |
| ACC_EMECONTA_MPOH | ACC_EMECONTA_MPOH | (不存在) | VARCHAR | 安监独有（ROHS代码可忽略） |
ATT_ORG_UWAT_BASE → att_org_uwat_base
操作: 仅代码侧改动
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| PGUID | PGUID | CHAR(32) | BPCHAR | 一致 |
| ORG_CODE | ORG_CODE | VARCHAR(24) | VARCHAR | 一致 |
| ORG_NAME | ORG_NAME | VARCHAR(512) | VARCHAR | 一致 |
| ORG_LEVEL | ORG_LEVEL | CHAR(2) | BPCHAR | 一致 |
| ORG_GRAD | ORG_GRAD | VARCHAR(512) | VARCHAR | 一致 |
| ORG_TYPE | ORG_TYPE | CHAR(1) | BPCHAR | 一致 |
| ORDERNUM | ORDERNUM | DECIMAL(38,0) | NUMERIC | 一致 |
| AD_CODE | AD_CODE | CHAR(12) | BPCHAR | 一致 |
| STATUS | STATUS | CHAR(1) | BPCHAR | 一致 |
| MODIFIER | MODIFIER | CHAR(32) | BPCHAR | 一致 |
| FROM_DATE | FROM_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| NOTE | NOTE | VARCHAR(2048) | VARCHAR | 一致 |
| JURD | JURD | VARCHAR(17) | VARCHAR | 一致 |
| AREA_TYPE | AREA_TYPE | CHAR(1) | BPCHAR | 一致 |
| NODE_CODE | NODE_CODE | VARCHAR(20) | VARCHAR | 一致 |
| TO_DATE | TO_DATE | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
ATT_PERS_BASE → att_pers_base
操作: 7个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| PERS_NAME | PERS_NAME | VARCHAR(60) | VARCHAR | 一致 |
| PERS_CODE | PERS_CODE | VARCHAR(64) | BPCHAR | 类型变更: BPCHAR → VARCHAR(64) |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| PERS_TYPE | PERS_TYPE | CHAR(2) | BPCHAR | 一致 |
| SEX | SEX | CHAR(1) | BPCHAR | 一致 |
| TELNUMB | TELNUMB | VARCHAR(20) | VARCHAR | 一致 |
| FAXNUMB | FAXNUMB | VARCHAR(20) | VARCHAR | 一致 |
| MOBILENUMB | MOBILENUMB | VARCHAR(32) | VARCHAR | 一致 |
| VARCHAR(60) | VARCHAR | 一致 | ||
| BORN_PLAC | BORN_PLAC | VARCHAR(100) | VARCHAR | 一致 |
| BORN_DATE | BORN_DATE | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| NATION | NATION | CHAR(2) | BPCHAR | 一致 |
| TITLE | TITLE | VARCHAR(40) | VARCHAR | 一致 |
| SCHOOL | SCHOOL | VARCHAR(100) | VARCHAR | 一致 |
| MAJOB | MAJOB | VARCHAR(100) | VARCHAR | 一致 |
| HIGH_DEGR | HIGH_DEGR | VARCHAR(10) | VARCHAR | 一致 |
| WDATETIME | WDATETIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| STATUS | STATUS | CHAR(1) | BPCHAR | 一致 |
| MODIFIER | MODIFIER | CHAR(32) | (不存在) | 新增列（ROHS独有） |
| FROM_DATE | FROM_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| STR_TO_DATE | STR_TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| NOTE | NOTE | VARCHAR(2048) | VARCHAR | 一致 |
| ADM_DUTY | ADM_DUTY | VARCHAR(3) | VARCHAR | 一致 |
| NODE_CODE | NODE_CODE | VARCHAR(20) | (不存在) | 新增列（ROHS独有） |
| COLL_TIME | COLL_TIME | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
| UPD_TIME | UPD_TIME | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
| REC_PERS | REC_PERS | (不存在) | BPCHAR | 安监独有（ROHS代码可忽略） |
ATT_PERS_EXT → att_pers_ext
操作: 3个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| PERS_NAME | PERS_NAME | VARCHAR(60) | VARCHAR | 一致 |
| TEND_GUID | TEND_GUID | CHAR(32) | BPCHAR | 一致 |
| ADM_DUTY | ADM_DUTY | VARCHAR(3) | VARCHAR | 一致 |
| SEX | SEX | CHAR(1) | BPCHAR | 一致 |
| BORN_DATE | BORN_DATE | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| WORK_DATE | WORK_DATE | DECIMAL(4,2) | VARCHAR | 类型变更: VARCHAR → DECIMAL(4,2) |
| NOTE | NOTE | VARCHAR(256) | VARCHAR | 一致 |
| COLL_TIME | COLL_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| UPD_TIME | UPD_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| REC_PERS | REC_PERS | CHAR(32) | BPCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | (不存在) | 新增列（ROHS独有） |
BIS_HIDD_INVE → bis_hidd_inve
表说明: 隐患排查
操作: 仅代码侧改动
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| HIDD_GUID | HIDD_GUID | CHAR(32) | BPCHAR | 一致 |
| INSP_ORG_GUID | INSP_ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| INSP_DATE | INSP_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| INSP_LEADER | INSP_LEADER | VARCHAR(50) | VARCHAR | 一致 |
| INSP_LEADER_POST | INSP_LEADER_POST | VARCHAR(50) | VARCHAR | 一致 |
| INSP_MEM | INSP_MEM | VARCHAR(100) | VARCHAR | 一致 |
| NOTE | NOTE | VARCHAR(256) | VARCHAR | 一致 |
| REC_PERS | REC_PERS | CHAR(32) | BPCHAR | 一致 |
| COLL_TIME | COLL_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| UPD_TIME | UPD_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| ORG_MANAGE | ORG_MANAGE | (不存在) | VARCHAR | 安监独有（ROHS代码可忽略） |
| HIDD_CONTENT | HIDD_CONTENT | (不存在) | VARCHAR | 安监独有（ROHS代码可忽略） |
BIS_HIDD_RECT_ACCE → bis_hidd_rect_acce
表说明: 隐患治理验收
操作: 4个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| HIDD_GUID | HIDD_GUID | CHAR(32) | BPCHAR | 一致 |
| REQU_COMP_DATE | REQU_COMP_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| ACCEP_LEG_PERS | ACCEP_LEG_PERS | VARCHAR(100) | VARCHAR | 一致 |
| ACCEP_PERS | ACCEP_PERS | VARCHAR(20) | VARCHAR | 一致 |
| ACCEP_DATE | ACCEP_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| ACCEP_OPIN | ACCEP_OPIN | VARCHAR(500) | VARCHAR | 一致 |
| NOTE | NOTE | VARCHAR(256) | VARCHAR | 一致 |
| COLL_TIME | COLL_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| UPD_TIME | UPD_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| REC_PERS | REC_PERS | CHAR(32) | BPCHAR | 一致 |
| CANCEL_STATE | CANCEL_STATE | CHAR(1) | BPCHAR | 一致 |
| ACCEPT_ORG | ACCEPT_ORG | VARCHAR(255) | (不存在) | 新增列（ROHS独有） |
| ACCEPT_DATE | ACCEPT_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| ACCEPT_OPINION | ACCEPT_OPINION | VARCHAR(2000) | (不存在) | 新增列（ROHS独有） |
| CURL_RESULT | CURL_RESULT | VARCHAR(2000) | (不存在) | 新增列（ROHS独有） |
BIS_HIDD_RECT_IMPL → bis_hidd_rect_impl
表说明: 隐患整改落实
操作: 1个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| HIDD_GUID | HIDD_GUID | CHAR(32) | BPCHAR | 一致 |
| GOVER_RESP_WIUN_GUID | GOVER_RESP_WIUN_GUID | CHAR(32) | BPCHAR | 一致 |
| RECT_LEG_PERS | RECT_LEG_PERS | VARCHAR(100) | VARCHAR | 一致 |
| RECT_PERS_OFFI_TEL | RECT_PERS_OFFI_TEL | VARCHAR(40) | VARCHAR | 一致 |
| REQU_COMP_DATE | REQU_COMP_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| ACIMP_GOVER_FUND | ACIMP_GOVER_FUND | DECIMAL(14,2) | NUMERIC | 一致 |
| GOVE_OBJE_TASKS | GOVE_OBJE_TASKS | VARCHAR(4000) | VARCHAR | 一致 |
| EMER_PLAN_SAME | EMER_PLAN_SAME | VARCHAR(4000) | VARCHAR | 一致 |
| CORR_MEAS | CORR_MEAS | VARCHAR(4000) | VARCHAR | 一致 |
| NOTE | NOTE | VARCHAR(256) | VARCHAR | 一致 |
| COLL_TIME | COLL_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| UPD_TIME | UPD_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| REC_PERS | REC_PERS | CHAR(32) | BPCHAR | 一致 |
| GOVER_RESP_WIUN | GOVER_RESP_WIUN | VARCHAR(100) | VARCHAR | 一致 |
| RECT_DEPT | RECT_DEPT | VARCHAR(255) | (不存在) | 新增列（ROHS独有） |
OBJ_ACCI → obj_acci
表说明: 事故对象
操作: 5个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| P_GUID | P_GUID | CHAR(32) | BPCHAR | 一致 |
| ACCI_WIUN_GUID | ACCI_WIUN_GUID | CHAR(32) | BPCHAR | 一致 |
| ACCI_WIUN_TYPE | ACCI_WIUN_TYPE | CHAR(1) | BPCHAR | 一致 |
| ACCI_CATE | ACCI_CATE | CHAR(2) | BPCHAR | 一致 |
| OCCU_TIME | OCCU_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| OCCU_LOC | OCCU_LOC | VARCHAR(100) | VARCHAR | 一致 |
| MISS_NUM | MISS_NUM | DECIMAL(12,0) | NUMERIC | 一致 |
| SER_INJ_NUM | SER_INJ_NUM | DECIMAL(12,0) | NUMERIC | 一致 |
| CAS_NUM | CAS_NUM | DECIMAL(12,0) | NUMERIC | 一致 |
| ECON_LOSS | ECON_LOSS | DECIMAL(14,2) | NUMERIC | 一致 |
| OTLCOL_GUUI_VICM | OTLCOL_GUUI_VICM | VARCHAR(1000) | VARCHAR | 一致 |
| RESC_TREA_MEAS | RESC_TREA_MEAS | VARCHAR(2048) | VARCHAR | 一致 |
| CONTA_PERS | CONTA_PERS | VARCHAR(20) | VARCHAR | 一致 |
| OFFI_TEL | OFFI_TEL | VARCHAR(22) | VARCHAR | 一致 |
| REP_STAT | REP_STAT | CHAR(1) | BPCHAR | 一致 |
| NOTE | NOTE | VARCHAR(256) | VARCHAR | 一致 |
| COLL_TIME | COLL_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| UPD_TIME | UPD_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| REC_PERS | REC_PERS | CHAR(32) | BPCHAR | 一致 |
| SGDW_NAME | SGDW_NAME | VARCHAR(200) | VARCHAR | 一致 |
| ACCI_GRAD | ACCI_GRAD | CHAR(1) | BPCHAR | 一致 |
| ENG_GUID | ENG_GUID | CHAR(32) | BPCHAR | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| TEND_GUID | TEND_GUID | CHAR(32) | BPCHAR | 一致 |
| DATA_TYPE | DATA_TYPE | CHAR(1) | (不存在) | 新增列（ROHS独有） |
| HIDD_GUID | HIDD_GUID | CHAR(32) | (不存在) | 新增列（ROHS独有） |
| HAZ_GUID | HAZ_GUID | CHAR(32) | (不存在) | 新增列（ROHS独有） |
| ACCI_SITU | ACCI_SITU | VARCHAR(1000) | (不存在) | 新增列（ROHS独有） |
| DATA_SIGN | DATA_SIGN | VARCHAR(500) | (不存在) | 新增列（ROHS独有） |
| TO_DATE | TO_DATE | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
OBJ_ENG → obj_eng
表说明: 工程对象
操作: 仅代码侧改动
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| ENG_CODE | ENG_CODE | VARCHAR(40) | VARCHAR | 一致 |
| ENG_NAME | ENG_NAME | VARCHAR(100) | VARCHAR | 一致 |
| ENG_TYPE | ENG_TYPE | CHAR(2) | BPCHAR | 一致 |
| FROM_DATE | FROM_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| PUB_GUID | PUB_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_JURD | ORG_JURD | CHAR(32) | BPCHAR | 一致 |
| ORG_REST | ORG_REST | CHAR(32) | BPCHAR | 一致 |
| OLD_CODE | OLD_CODE | VARCHAR(18) | VARCHAR | 一致 |
| MANAGE_MODE | MANAGE_MODE | VARCHAR(2) | VARCHAR | 一致 |
| TO_DATE | TO_DATE | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
OBJ_HAZARD → obj_hazard
表说明: 危险源
操作: 3个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| HAZ_NAME | HAZ_NAME | VARCHAR(300) | VARCHAR | 一致 |
| GUIDE_GUID | GUIDE_GUID | CHAR(32) | BPCHAR | 一致 |
| PART_GUID | PART_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| VERI_STATUS | VERI_STATUS | CHAR(1) | BPCHAR | 一致 |
| VERI_PER | VERI_PER | CHAR(32) | BPCHAR | 一致 |
| VERI_TIME | VERI_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| CREATE_PER | CREATE_PER | CHAR(32) | BPCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| UPDATE_PER | UPDATE_PER | CHAR(32) | BPCHAR | 一致 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| PGUID | PGUID | CHAR(32) | BPCHAR | 一致 |
| CHANGE_STATUS | CHANGE_STATUS | CHAR(1) | BPCHAR | 一致 |
| TYPE | TYPE | CHAR(1) | BPCHAR | 一致 |
| ENG_GUID | ENG_GUID | CHAR(32) | BPCHAR | 一致 |
OBJ_HIDD → obj_hidd
表说明: 隐患对象
操作: 仅代码侧改动
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| HIDD_NAME | HIDD_NAME | VARCHAR(300) | VARCHAR | 一致 |
| ENG_GUID | ENG_GUID | CHAR(32) | BPCHAR | 一致 |
| TEND_GUID | TEND_GUID | CHAR(32) | BPCHAR | 一致 |
| SE_GUID | SE_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| HIDD_SOUR | HIDD_SOUR | CHAR(1) | BPCHAR | 一致 |
| HIDD_GRAD | HIDD_GRAD | CHAR(1) | BPCHAR | 一致 |
| HIDD_CLAS | HIDD_CLAS | CHAR(2) | BPCHAR | 一致 |
| IF_FOUND | IF_FOUND | CHAR(1) | BPCHAR | 一致 |
| PRO_PART | PRO_PART | VARCHAR(1024) | VARCHAR | 一致 |
| PART_LONG | PART_LONG | DECIMAL(11,8) | NUMERIC | 一致 |
| PART_LAT | PART_LAT | DECIMAL(10,8) | NUMERIC | 一致 |
| OTLCOL_QIFF_FNVU | OTLCOL_QIFF_FNVU | VARCHAR(2048) | VARCHAR | 一致 |
| INSP_REC_GUID | INSP_REC_GUID | CHAR(32) | BPCHAR | 一致 |
| SE_CHECK_ITEM_GUID | SE_CHECK_ITEM_GUID | CHAR(32) | BPCHAR | 一致 |
| HIDD_STAT | HIDD_STAT | CHAR(1) | BPCHAR | 一致 |
| HIDD_MERG_GUID | HIDD_MERG_GUID | CHAR(32) | BPCHAR | 一致 |
| REC_ORG_GUID | REC_ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| NOTE | NOTE | VARCHAR(256) | VARCHAR | 一致 |
| COLL_TIME | COLL_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| UPD_TIME | UPD_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| REC_PERS | REC_PERS | CHAR(32) | BPCHAR | 一致 |
| HIDDS_GUID | HIDDS_GUID | CHAR(32) | BPCHAR | 一致 |
| OCCU_NUM | OCCU_NUM | DECIMAL(5,0) | NUMERIC | 一致 |
| SINS_SCHE_GUID | SINS_SCHE_GUID | CHAR(32) | BPCHAR | 一致 |
| GROUP_GUID | GROUP_GUID | CHAR(32) | BPCHAR | 一致 |
| TEMP | TEMP | VARCHAR(20) | VARCHAR | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| DICT_GUID | DICT_GUID | CHAR(32) | BPCHAR | 一致 |
| HAZ_GUID | HAZ_GUID | CHAR(32) | BPCHAR | 一致 |
| HIDD_SORT | HIDD_SORT | CHAR(1) | BPCHAR | 一致 |
| TO_DATE | TO_DATE | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
OBJ_TEND → obj_tend
表说明: 标段对象表
操作: 仅代码侧改动
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| TEND_NAME | TEND_NAME | VARCHAR(256) | VARCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_PROJ_DEPT_GUID | ORG_PROJ_DEPT_GUID | CHAR(32) | BPCHAR | 一致 |
| ENG_GUID | ENG_GUID | CHAR(32) | BPCHAR | 一致 |
| LEG_PERS | LEG_PERS | VARCHAR(20) | VARCHAR | 一致 |
| LEG_TEL | LEG_TEL | VARCHAR(22) | VARCHAR | 一致 |
| CON_AMOUT | CON_AMOUT | DECIMAL(12,4) | NUMERIC | 一致 |
| TOTAL_SPC | TOTAL_SPC | DECIMAL(12,4) | NUMERIC | 一致 |
| CONS_CONT | CONS_CONT | VARCHAR(2048) | VARCHAR | 一致 |
| NOTE | NOTE | VARCHAR(256) | VARCHAR | 一致 |
| COLL_TIME | COLL_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| UPD_TIME | UPD_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| REC_PERS | REC_PERS | CHAR(32) | BPCHAR | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| TO_DATE | TO_DATE | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
| STAT | STAT | (不存在) | BPCHAR | 安监独有（ROHS代码可忽略） |
REL_BIS_MED → rel_bis_med
操作: 仅代码侧改动
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| BIS_TABLENAME | BIS_TABLENAME | VARCHAR(100) | VARCHAR | 一致 |
| BIS_GUID | BIS_GUID | CHAR(32) | BPCHAR | 一致 |
| MED_GUID | MED_GUID | CHAR(32) | BPCHAR | 一致 |
| BIS_REL_COLUMNS | BIS_REL_COLUMNS | VARCHAR(100) | VARCHAR | 一致 |
| FROM_DATE | FROM_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| TO_DATE | TO_DATE | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
REL_ENG_ORG → rel_eng_org
表说明: 工程与水利机构关系表
操作: 仅代码侧改动
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| ENG_GUID | ENG_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| FROM_DATE | FROM_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| TO_DATE | TO_DATE | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
REL_ENG_ORG_UWAT → rel_eng_org_uwat
表说明: 工程与非水利机构关系表
操作: 仅代码侧改动
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| ENG_GUID | ENG_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_UWAT_GUID | ORG_UWAT_GUID | CHAR(32) | BPCHAR | 一致 |
| FROM_DATE | FROM_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| TO_DATE | TO_DATE | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
REL_PROJ_ORG → rel_proj_org
表说明: 项目与机构关系表
操作: 仅代码侧改动
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| PROJ_GUID | PROJ_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| FROM_DATE | FROM_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| TO_DATE | TO_DATE | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
REL_TEND_ORG → rel_tend_org
表说明: 标段与非水利机构关系表
操作: 仅代码侧改动
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| TEND_GUID | TEND_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_UWAT_GUID | ORG_UWAT_GUID | CHAR(32) | BPCHAR | 一致 |
| FROM_DATE | FROM_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| TO_DATE | TO_DATE | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
REL_USER_TEND → rel_user_tend
表说明: 用户与标段关系表
操作: 仅代码侧改动
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| USER_GUID | USER_GUID | CHAR(32) | BPCHAR | 一致 |
| TEND_GUID | TEND_GUID | CHAR(32) | BPCHAR | 一致 |
| FROM_DATE | FROM_DATE | TIMESTAMP | TIMESTAMP | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| TO_DATE | TO_DATE | (不存在) | TIMESTAMP | 安监独有（ROHS代码可忽略） |
T_BUSI_CONPLAN_BASIC → t_busi_conplan_basic
表说明: 应急预案基本信息表
操作: 4个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| PLAN_NAME | PLAN_NAME | VARCHAR(100) | VARCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| ENTRY_TIME | ENTRY_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| EVA_CYCLE | EVA_CYCLE | DECIMAL(38,0) | NUMERIC | 一致 |
| REVISED | REVISED | CHAR(1) | BPCHAR | 一致 |
| PLAN_TYPE | PLAN_TYPE | CHAR(1) | BPCHAR | 一致 |
| CREPER_GUID | CREPER_GUID | CHAR(32) | BPCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| UPDPER_GUID | UPDPER_GUID | CHAR(32) | BPCHAR | 一致 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| PLAN_STATUS | PLAN_STATUS | CHAR(1) | BPCHAR | 一致 |
| PARENT_ID | PARENT_ID | CHAR(32) | BPCHAR | 一致 |
| REVISION_INFO | REVISION_INFO | VARCHAR(200) | VARCHAR | 一致 |
| PARENT_NAME | PARENT_NAME | VARCHAR(100) | VARCHAR | 一致 |
| REVISE_TIME | REVISE_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| HAZ_GUID | HAZ_GUID | VARCHAR(32) | (不存在) | 新增列（ROHS独有） |
| ENG_GUID | ENG_GUID | VARCHAR(32) | (不存在) | 新增列（ROHS独有） |
| EMER_TYPE | EMER_TYPE | CHAR(1) | (不存在) | 新增列（ROHS独有） |
| AREA_TYPE | AREA_TYPE | CHAR(1) | (不存在) | 新增列（ROHS独有） |
T_BUSI_CONTROL_MEASURE → t_busi_control_measure
表说明: 管控措施
操作: 2个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| HAZ_IDEN_GUID | HAZ_IDEN_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_PER_GUID | ORG_PER_GUID | CHAR(32) | BPCHAR | 一致 |
| CONS_ORG_PER_GUID | CONS_ORG_PER_GUID | CHAR(32) | BPCHAR | 一致 |
| SUPE_ORG_PER_GUID | SUPE_ORG_PER_GUID | CHAR(32) | BPCHAR | 一致 |
| SUPE_PER_GUID | SUPE_PER_GUID | CHAR(32) | BPCHAR | 一致 |
| SCENE_PER_GUID | SCENE_PER_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| CREATE_PER | CREATE_PER | CHAR(32) | BPCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| UPDATE_PER | UPDATE_PER | CHAR(32) | BPCHAR | 一致 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
T_BUSI_CONTROL_TERM → t_busi_control_term
表说明: 管控措施项
操作: 2个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| HAZ_IDEN_GUID | HAZ_IDEN_GUID | CHAR(32) | BPCHAR | 一致 |
| TYPE | TYPE | VARCHAR(200) | VARCHAR | 一致 |
| CONTENT | CONTENT | VARCHAR(1500) | VARCHAR | 一致 |
| DATA_TYPE | DATA_TYPE | CHAR(1) | BPCHAR | 一致 |
| CREATE_PER | CREATE_PER | CHAR(32) | BPCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| UPDATE_PER | UPDATE_PER | CHAR(32) | BPCHAR | 一致 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| MEAS_GUID | MEAS_GUID | CHAR(32) | BPCHAR | 一致 |
T_BUSI_HAZARD_ARCHIVE → t_busi_hazard_archive
表说明: 危险源档案
操作: 2个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| HAZ_IDEN_GUID | HAZ_IDEN_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| STATUS | STATUS | CHAR(1) | BPCHAR | 一致 |
| WIUN_GUID | WIUN_GUID | CHAR(32) | BPCHAR | 一致 |
| CREATE_PER | CREATE_PER | CHAR(32) | BPCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| UPDATE_PER | UPDATE_PER | CHAR(32) | BPCHAR | 一致 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
T_BUSI_HAZARD_REPORT → t_busi_hazard_report
表说明: 危险源上报
操作: 2个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| HAZ_IDEN_GUID | HAZ_IDEN_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| STATUS | STATUS | CHAR(1) | BPCHAR | 一致 |
| WIUN_GUID | WIUN_GUID | CHAR(32) | BPCHAR | 一致 |
| CREATE_PER | CREATE_PER | CHAR(32) | BPCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| UPDATE_PER | UPDATE_PER | CHAR(32) | BPCHAR | 一致 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
T_BUSI_HAZARD_WARM → t_busi_hazard_warm
表说明: 危险源风险预警评估
操作: 2个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | VARCHAR(50) | VARCHAR | 一致 |
| WARM_LEVEL | WARM_LEVEL | VARCHAR(100) | VARCHAR | 一致 |
| WARM_THRESHOLD | WARM_THRESHOLD | DECIMAL(10,0) | NUMERIC | 一致 |
| CURRENT_THRESHOLD | CURRENT_THRESHOLD | DECIMAL(10,0) | NUMERIC | 一致 |
| CONTROL_MEASURE | CONTROL_MEASURE | VARCHAR(3000) | VARCHAR | 一致 |
| EMGC_MEASURE | EMGC_MEASURE | VARCHAR(3000) | VARCHAR | 一致 |
| HAZ_GUID | HAZ_GUID | VARCHAR(50) | VARCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| CONTENT | CONTENT | VARCHAR(100) | VARCHAR | 一致 |
| REMARK | REMARK | VARCHAR(100) | VARCHAR | 一致 |
| CREPER_GUID | CREPER_GUID | CHAR(32) | BPCHAR | 一致 |
| UPDPER_GUID | UPDPER_GUID | CHAR(32) | BPCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
T_BUSI_HAZ_IDEN → t_busi_haz_iden
表说明: 辨识表
操作: 3个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| HAZ_GUID | HAZ_GUID | CHAR(32) | BPCHAR | 一致 |
| HAZ_GRADE | HAZ_GRADE | CHAR(1) | BPCHAR | 一致 |
| OTLCOL_QGW_TNYGTS | OTLCOL_QGW_TNYGTS | VARCHAR(2500) | (不存在) | 新增列（ROHS独有） |
| GUIDE_IN | GUIDE_IN | CHAR(1) | BPCHAR | 一致 |
| CREATE_PER | CREATE_PER | CHAR(32) | BPCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| UPDATE_PER | UPDATE_PER | CHAR(32) | BPCHAR | 一致 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| ACCI_CAUSE | ACCI_CAUSE | VARCHAR(2000) | VARCHAR | 一致 |
| HAZ_REMARK | HAZ_REMARK | (不存在) | VARCHAR | 安监独有（ROHS代码可忽略） |
| ORG_PER | ORG_PER | (不存在) | VARCHAR | 安监独有（ROHS代码可忽略） |
| ORG_PHONE | ORG_PHONE | (不存在) | VARCHAR | 安监独有（ROHS代码可忽略） |
| SUPE_PER | SUPE_PER | (不存在) | VARCHAR | 安监独有（ROHS代码可忽略） |
| SUPE_PHONE | SUPE_PHONE | (不存在) | VARCHAR | 安监独有（ROHS代码可忽略） |
| CONTROL_PER | CONTROL_PER | (不存在) | VARCHAR | 安监独有（ROHS代码可忽略） |
| CONTROL_PHONE | CONTROL_PHONE | (不存在) | VARCHAR | 安监独有（ROHS代码可忽略） |
T_BUSI_HAZ_IDEN_MW_Z → t_busi_haz_iden_mw_z
操作: 2个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| HAZ_GUID | HAZ_GUID | CHAR(32) | BPCHAR | 一致 |
| HAZ_GRADE | HAZ_GRADE | CHAR(1) | BPCHAR | 一致 |
| OTLCOL_QGW_TNYGTS | OTLCOL_QGW_TNYGTS | VARCHAR(2500) | VARCHAR | 一致 |
| GUIDE_IN | GUIDE_IN | CHAR(1) | BPCHAR | 一致 |
| CREATE_PER | CREATE_PER | CHAR(32) | BPCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| UPDATE_PER | UPDATE_PER | CHAR(32) | BPCHAR | 一致 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| ACCI_CAUSE | ACCI_CAUSE | VARCHAR(200) | VARCHAR | 一致 |
T_BUSI_INSPECT_ITEM → t_busi_inspect_item
表说明: 巡检项
操作: 2个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| RECORD_GUID | RECORD_GUID | CHAR(32) | BPCHAR | 一致 |
| CONTENT | CONTENT | VARCHAR(500) | VARCHAR | 一致 |
| DATA_TYPE | DATA_TYPE | CHAR(1) | BPCHAR | 一致 |
| ITEM_VALUE | ITEM_VALUE | VARCHAR(10) | VARCHAR | 一致 |
| RESULT | RESULT | CHAR(1) | BPCHAR | 一致 |
| REMARK | REMARK | VARCHAR(800) | VARCHAR | 一致 |
| CREATE_PER | CREATE_PER | CHAR(32) | BPCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| UPDATE_PER | UPDATE_PER | CHAR(32) | BPCHAR | 一致 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
T_BUSI_INSPECT_RECORD → t_busi_inspect_record
表说明: 巡检记录
操作: 5个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| HAZ_IDEN_GUID | HAZ_IDEN_GUID | CHAR(32) | BPCHAR | 一致 |
| TASK_GUID | TASK_GUID | CHAR(32) | BPCHAR | 一致 |
| START_TIME | START_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| END_TIME | END_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| QUANT_TYPE | QUANT_TYPE | CHAR(1) | BPCHAR | 一致 |
| EARLY | EARLY | VARCHAR(500) | VARCHAR | 一致 |
| THRESHOLD | THRESHOLD | VARCHAR(10) | VARCHAR | 一致 |
| RESULT | RESULT | CHAR(1) | BPCHAR | 一致 |
| REMARK | REMARK | VARCHAR(800) | VARCHAR | 一致 |
| INSPECT_PER_GUID | INSPECT_PER_GUID | VARCHAR(32) | VARCHAR | 一致 |
| INSPECT_PER | INSPECT_PER | VARCHAR(32) | VARCHAR | 一致 |
| INSPECT_TIME | INSPECT_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| CREATE_PER | CREATE_PER | CHAR(32) | BPCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| UPDATE_PER | UPDATE_PER | CHAR(32) | BPCHAR | 一致 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
T_BUSI_INSPECT_TASK → t_busi_inspect_task
表说明: 巡检计划
操作: 3个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| HAZ_IDEN_GUID | HAZ_IDEN_GUID | CHAR(32) | BPCHAR | 一致 |
| START_TIME | START_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| CYCLE_NUM | CYCLE_NUM | DECIMAL | NUMERIC | 一致 |
| QUANT_TYPE | QUANT_TYPE | CHAR(1) | BPCHAR | 一致 |
| EARLY | EARLY | VARCHAR(250) | VARCHAR | 一致 |
| THRESHOLD | THRESHOLD | VARCHAR(10) | VARCHAR | 一致 |
| ORG_GUID | ORG_GUID | CHAR(32) | BPCHAR | 一致 |
| STATUS | STATUS | CHAR(1) | BPCHAR | 一致 |
| CREATE_PER | CREATE_PER | CHAR(32) | BPCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| UPDATE_PER | UPDATE_PER | CHAR(32) | BPCHAR | 一致 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
T_BUSI_INSPECT_TASK_ITEM → t_busi_inspect_task_item
表说明: 巡检计划检查项
操作: 2个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| TASK_GUID | TASK_GUID | CHAR(32) | BPCHAR | 一致 |
| CONTENT | CONTENT | VARCHAR(500) | VARCHAR | 一致 |
| DATA_TYPE | DATA_TYPE | CHAR(1) | BPCHAR | 一致 |
| CREATE_PER | CREATE_PER | CHAR(32) | BPCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| UPDATE_PER | UPDATE_PER | CHAR(32) | BPCHAR | 一致 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
T_BUSI_REGULAR_EVALU → t_busi_regular_evalu
操作: 两套并存，ROHS版创建为 t_busi_regular_evalu_rohs
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| EV_GUID | EV_GUID | CHAR(32) | (新表) | 新建ROHS版表 |
| BASIC_ID | BASIC_ID | CHAR(32) | (新表) | 新建ROHS版表 |
| ASSESS_TIME | ASSESS_TIME | TIMESTAMP | (新表) | 新建ROHS版表 |
| EVALU_NAME | EVALU_NAME | VARCHAR(500) | (新表) | 新建ROHS版表 |
| EVA_START | EVA_START | TIMESTAMP | (新表) | 新建ROHS版表 |
| EVA_END | EVA_END | TIMESTAMP | (新表) | 新建ROHS版表 |
| EVALU_EXPLAIN | EVALU_EXPLAIN | VARCHAR(2000) | (新表) | 新建ROHS版表 |
| ORG_GUID | ORG_GUID | CHAR(32) | (新表) | 新建ROHS版表 |
| CREPER_GUID | CREPER_GUID | CHAR(32) | (新表) | 新建ROHS版表 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | (新表) | 新建ROHS版表 |
| UPDPER_GUID | UPDPER_GUID | CHAR(32) | (新表) | 新建ROHS版表 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | (新表) | 新建ROHS版表 |
| EVALU_STATUS | EVALU_STATUS | CHAR(1) | (新表) | 新建ROHS版表 |
| EVA_STATUS | EVA_STATUS | CHAR(1) | (新表) | 新建ROHS版表 |
| EVA_SOURCE | EVA_SOURCE | VARCHAR(50) | (新表) | 新建ROHS版表 |
T_BUSI_RESP_PER → t_busi_resp_per
表说明: 现场责任人
操作: 2个ALTER
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| NAME | NAME | VARCHAR(20) | VARCHAR | 一致 |
| PHONE | PHONE | VARCHAR(20) | VARCHAR | 一致 |
| CREATE_PER | CREATE_PER | CHAR(32) | BPCHAR | 一致 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| UPDATE_PER | UPDATE_PER | CHAR(32) | BPCHAR | 一致 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | DATE | 类型变更: DATE → TIMESTAMP |
| DATA_SIGN | DATA_SIGN | VARCHAR(100) | VARCHAR | 一致 |
T_BUSI_REVIEW_INFO → t_busi_review_info
操作: 两套并存，ROHS版创建为 t_busi_review_info_rohs
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| RE_GUID | RE_GUID | CHAR(32) | (新表) | 新建ROHS版表 |
| BASIC_ID | BASIC_ID | CHAR(32) | (新表) | 新建ROHS版表 |
| ORG_GUID | ORG_GUID | VARCHAR(100) | (新表) | 新建ROHS版表 |
| HOST_NAME | HOST_NAME | VARCHAR(500) | (新表) | 新建ROHS版表 |
| REVIEW_TIME | REVIEW_TIME | TIMESTAMP | (新表) | 新建ROHS版表 |
| CREPER_GUID | CREPER_GUID | CHAR(32) | (新表) | 新建ROHS版表 |
| CREATE_TIME | CREATE_TIME | TIMESTAMP | (新表) | 新建ROHS版表 |
| UPDPER_GUID | UPDPER_GUID | CHAR(32) | (新表) | 新建ROHS版表 |
| UPDATE_TIME | UPDATE_TIME | TIMESTAMP | (新表) | 新建ROHS版表 |
| REVIEW_NOTE | REVIEW_NOTE | VARCHAR(200) | (新表) | 新建ROHS版表 |
| REVIEW_STATUS | REVIEW_STATUS | CHAR(1) | (新表) | 新建ROHS版表 |
| KEEP_STATUS | KEEP_STATUS | CHAR(1) | (新表) | 新建ROHS版表 |
| KEEP_TIME | KEEP_TIME | TIMESTAMP | (新表) | 新建ROHS版表 |
| KEEP_ORG | KEEP_ORG | CHAR(32) | (新表) | 新建ROHS版表 |
| KEEP_PER | KEEP_PER | CHAR(32) | (新表) | 新建ROHS版表 |
T_BUSI_RISK_THRESHOLD → t_busi_risk_threshold
表说明: 风险评价阈值
操作: 仅代码侧改动
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | BPCHAR | 一致 |
| LOW_RISK | LOW_RISK | DECIMAL | NUMERIC | 一致 |
| ORDINARY_RISK | ORDINARY_RISK | DECIMAL | NUMERIC | 一致 |
| LARGER_RISK | LARGER_RISK | DECIMAL | NUMERIC | 一致 |
| SERIOUS_RISK | SERIOUS_RISK | DECIMAL | NUMERIC | 一致 |
| NOTE | NOTE | VARCHAR(256) | VARCHAR | 一致 |
| COLL_TIME | COLL_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| UPD_TIME | UPD_TIME | TIMESTAMP | TIMESTAMP | 一致 |
| REC_PERS | REC_PERS | CHAR(32) | BPCHAR | 一致 |
| STR_TO_DATE | TO_DATE | TIMESTAMP | (不存在) | 新增列（ROHS独有） |
| TO_DATE | TO_DATE | (不存在) | DATE | 安监独有（ROHS代码可忽略） |
T_DICT_HIDD_ENG → t_dict_hidd_eng
操作: 两套并存，ROHS版创建为 t_dict_hidd_eng_rohs
| ROHS列名 | 安监列名 | ROHS类型 | 安监类型 | 备注 |
|---|---|---|---|---|
| GUID | GUID | CHAR(32) | (新表) | 新建ROHS版表 |
| HIDD_TYPE | HIDD_TYPE | VARCHAR(100) | (新表) | 新建ROHS版表 |
| MANAGEMENT_LINK | MANAGEMENT_LINK | VARCHAR(100) | (新表) | 新建ROHS版表 |
| HIDD_CODE | HIDD_CODE | VARCHAR(50) | (新表) | 新建ROHS版表 |
| HIDD_CONTENT | HIDD_CONTENT | VARCHAR(1000) | (新表) | 新建ROHS版表 |
| ENG_STAT | ENG_STAT | CHAR(1) | (新表) | 新建ROHS版表 |
| ORG_MANAGE | ORG_MANAGE | VARCHAR(100) | (新表) | 新建ROHS版表 |
| VERSIONS | VERSIONS | CHAR(1) | (新表) | 新建ROHS版表 |
三、完全一致的表（28张，无需任何改动）
| ROHS表名 | 安监表名 | 列数 | 表说明 |
|---|---|---|---|
| ATT_ENG_CWS | att_eng_cws |
31 | 农村供水工程信息表 |
| ATT_ENG_DIKE | att_eng_dike |
38 | ATT_ENG_DIKE |
| ATT_ENG_HYST | att_eng_hyst |
39 | 水电站工程信息表 |
| ATT_ENG_IRR | att_eng_irr |
42 | 灌区工程信息表 |
| ATT_ENG_OTHE | att_eng_othe |
30 | 其他工程信息表 |
| ATT_ENG_PUST | att_eng_pust |
34 | 泵站工程信息表 |
| ATT_ENG_RES | att_eng_res |
42 | 水库工程信息表 |
| ATT_ENG_SD | att_eng_sd |
31 | 淤地坝工程信息表 |
| ATT_ENG_WADI | att_eng_wadi |
34 | 引调水工程信息表 |
| ATT_ENG_WAGA | att_eng_waga |
33 | 水闸信息表 |
| ATT_MED_BASE | att_med_base |
22 | 多媒体基本信息表 |
| ATT_ORG_UWAT_EXT | att_org_uwat_ext |
66 | - |
| BIS_ACCI_EXP_REP | bis_acci_exp_rep |
8 | 事故快报表 |
| BIS_ACCI_INVE | bis_acci_inve |
10 | 事故调查和处理信息 |
| BIS_ACCI_PROG | bis_acci_prog |
7 | 事故进展 |
| BIS_ACCI_REC_REP | bis_acci_rec_rep |
10 | 事故月报 |
| BIS_ENG_SARE | bis_eng_sare |
24 | 工程安全责任信息 |
| BIS_HIDD_MAJ_VERI | bis_hidd_maj_veri |
11 | 重大隐患核实信息 |
| BIS_HIDD_RECT_PROG | bis_hidd_rect_prog |
7 | 隐患整改进展情况 |
| BIS_HIDD_REC_REP | bis_hidd_rec_rep |
10 | 隐患记录上报 |
| BIS_MAJ_HIDD_SUP | bis_maj_hidd_sup |
13 | 隐患督办 |
| HAZARD_SOURCE | hazard_source |
18 | 危险源风险 |
| OBJ_SE | obj_se |
10 | 安全元素库对象表 |
| T_BUSI_PLAN_DISCLOSURE | t_busi_plan_disclosure |
11 | 预案信息公开表 |
| T_DICT_MAJOR_BUILDING | t_dict_major_building |
13 | 在建工程一般危险源字典表 |
| T_DICT_MAJOR_COMMON | t_dict_major_common |
15 | 已建工程一般危险源导则 |
| T_DICT_MAJOR_ED | t_dict_major_ed |
12 | 在建工程重大危险源清单 |
| T_DICT_MAJOR_SOURCE | t_dict_major_source |
14 | 重大危险源字典表 |
四、ROHS 代码改动清单
必须改动
- Schema 改名:
SLAJ_ROHS→slaj（数据库连接配置/jdbc url） - 表名小写: 所有表名从大写改为小写（如
ATT_ENG_BASE→att_eng_base） - 列名小写: 所有列名从大写改为小写
- STR_TO_DATE → TO_DATE: 涉及以下表，ROHS代码中所有
STR_TO_DATE改为TO_DATE - 3张独立表改名:
T_BUSI_REGULAR_EVALU→t_busi_regular_evalu_rohsT_BUSI_REVIEW_INFO→t_busi_review_info_rohsT_DICT_HIDD_ENG→t_dict_hidd_eng_rohs
建议检查
- TIMESTAMP 类型字段：如果代码中将数据库字段映射为 LocalDate，需改为 LocalDateTime
- 新增列（取并集）：如果代码中有
SELECT *查询，确认是否受影响 - 安监独有列：ROHS代码可选择忽略这些列，写入时留 NULL 即可