# 字段映射表 — ROHS → 安监(slaj)

> 给改 ROHS 代码的团队使用。包含所有列名变更、类型变更的完整对照。

## 一、新表（73张）

以下表在安监中不存在，本次新建。ROHS 代码侧需：
1. 连接 schema 从 `SLAJ_ROHS` 改为 `slaj`
2. 表名和列名统一改为小写

| 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 | 一致 |
| EMAIL | EMAIL | 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 代码改动清单

### 必须改动

1. **Schema 改名**: `SLAJ_ROHS` → `slaj`（数据库连接配置/jdbc url）
2. **表名小写**: 所有表名从大写改为小写（如 `ATT_ENG_BASE` → `att_eng_base`）
3. **列名小写**: 所有列名从大写改为小写
4. **STR_TO_DATE → TO_DATE**: 涉及以下表，ROHS代码中所有 `STR_TO_DATE` 改为 `TO_DATE`
5. **3张独立表改名**:
   - `T_BUSI_REGULAR_EVALU` → `t_busi_regular_evalu_rohs`
   - `T_BUSI_REVIEW_INFO` → `t_busi_review_info_rohs`
   - `T_DICT_HIDD_ENG` → `t_dict_hidd_eng_rohs`

### 建议检查

1. TIMESTAMP 类型字段：如果代码中将数据库字段映射为 LocalDate，需改为 LocalDateTime
2. 新增列（取并集）：如果代码中有 `SELECT *` 查询，确认是否受影响
3. 安监独有列：ROHS代码可选择忽略这些列，写入时留 NULL 即可