slaj/deliverables/01_new_tables_rollback.sql

-- ============================================================
-- 回滚脚本: 删除新建的 73 张表
-- 警告: CASCADE 会同时删除依赖这些表的视图、函数等
-- 执行方式: psql -h 39.98.38.2 -p 5866 -U highgo -d highgo -f this_file.sql
-- ============================================================

-- ATT_APP_BASE → att_app_base
DROP TABLE IF EXISTS slaj.att_app_base CASCADE;

-- ATT_JOB_BASE → att_job_base
DROP TABLE IF EXISTS slaj.att_job_base CASCADE;

-- ATT_ORG_BASE20250113 → att_org_base20250113
DROP TABLE IF EXISTS slaj.att_org_base20250113 CASCADE;

-- ATT_ORG_DEP → att_org_dep
DROP TABLE IF EXISTS slaj.att_org_dep CASCADE;

-- ATT_PERSON_EXT → att_person_ext
DROP TABLE IF EXISTS slaj.att_person_ext CASCADE;

-- ATT_ROLE_BASE → att_role_base
DROP TABLE IF EXISTS slaj.att_role_base CASCADE;

-- ATT_USER_EXT → att_user_ext
DROP TABLE IF EXISTS slaj.att_user_ext CASCADE;

-- BDMS_ATT_ENG_PUST → bdms_att_eng_pust
DROP TABLE IF EXISTS slaj.bdms_att_eng_pust CASCADE;

-- BIS_HIDD_REC_REP20250113 → bis_hidd_rec_rep20250113
DROP TABLE IF EXISTS slaj.bis_hidd_rec_rep20250113 CASCADE;

-- HARD_TOTAL → hard_total
DROP TABLE IF EXISTS slaj.hard_total CASCADE;

-- HIDD_STATISTICS → hidd_statistics
DROP TABLE IF EXISTS slaj.hidd_statistics CASCADE;

-- OBJ_AD → obj_ad
DROP TABLE IF EXISTS slaj.obj_ad CASCADE;

-- OBJ_BAAD → obj_baad
DROP TABLE IF EXISTS slaj.obj_baad CASCADE;

-- OBJ_HAZARD20250113 → obj_hazard20250113
DROP TABLE IF EXISTS slaj.obj_hazard20250113 CASCADE;

-- OBJ_HAZARDBAK → obj_hazardbak
DROP TABLE IF EXISTS slaj.obj_hazardbak CASCADE;

-- OBJ_HIDD20250113 → obj_hidd20250113
DROP TABLE IF EXISTS slaj.obj_hidd20250113 CASCADE;

-- OBJ_HIDDD → obj_hiddd
DROP TABLE IF EXISTS slaj.obj_hiddd CASCADE;

-- OBJ_ORG_ZCPT → obj_org_zcpt
DROP TABLE IF EXISTS slaj.obj_org_zcpt CASCADE;

-- OBJ_ROLE → obj_role
DROP TABLE IF EXISTS slaj.obj_role CASCADE;

-- OBJ_TEND20250113 → obj_tend20250113
DROP TABLE IF EXISTS slaj.obj_tend20250113 CASCADE;

-- PPRTY_NOTICE_INFO → pprty_notice_info
DROP TABLE IF EXISTS slaj.pprty_notice_info CASCADE;

-- REL_DRILL_EVA → rel_drill_eva
DROP TABLE IF EXISTS slaj.rel_drill_eva CASCADE;

-- REL_DRILL_SC → rel_drill_sc
DROP TABLE IF EXISTS slaj.rel_drill_sc CASCADE;

-- REL_INSURE_TEND → rel_insure_tend
DROP TABLE IF EXISTS slaj.rel_insure_tend CASCADE;

-- REL_INSURE_TEND20250113 → rel_insure_tend20250113
DROP TABLE IF EXISTS slaj.rel_insure_tend20250113 CASCADE;

-- REL_JOB_ROLE → rel_job_role
DROP TABLE IF EXISTS slaj.rel_job_role CASCADE;

-- REL_ORG_ZCPT → rel_org_zcpt
DROP TABLE IF EXISTS slaj.rel_org_zcpt CASCADE;

-- REL_PERS_ZCPT → rel_pers_zcpt
DROP TABLE IF EXISTS slaj.rel_pers_zcpt CASCADE;

-- REL_SYS_PERS → rel_sys_pers
DROP TABLE IF EXISTS slaj.rel_sys_pers CASCADE;

-- REL_USER_APP → rel_user_app
DROP TABLE IF EXISTS slaj.rel_user_app CASCADE;

-- REL_USER_APPOINT → rel_user_appoint
DROP TABLE IF EXISTS slaj.rel_user_appoint CASCADE;

-- REL_USER_JOB → rel_user_job
DROP TABLE IF EXISTS slaj.rel_user_job CASCADE;

-- REL_USER_ROLE → rel_user_role
DROP TABLE IF EXISTS slaj.rel_user_role CASCADE;

-- REL_USER_ROLE_EXT → rel_user_role_ext
DROP TABLE IF EXISTS slaj.rel_user_role_ext CASCADE;

-- T_BUSI_ACCI_EVALUATE → t_busi_acci_evaluate
DROP TABLE IF EXISTS slaj.t_busi_acci_evaluate CASCADE;

-- T_BUSI_ACCOUNT_RECORD → t_busi_account_record
DROP TABLE IF EXISTS slaj.t_busi_account_record CASCADE;

-- T_BUSI_BD_TOTAL → t_busi_bd_total
DROP TABLE IF EXISTS slaj.t_busi_bd_total CASCADE;

-- T_BUSI_CONPLAN_BASIC20250113 → t_busi_conplan_basic20250113
DROP TABLE IF EXISTS slaj.t_busi_conplan_basic20250113 CASCADE;

-- T_BUSI_CONT_MEAS → t_busi_cont_meas
DROP TABLE IF EXISTS slaj.t_busi_cont_meas CASCADE;

-- T_BUSI_DATA_TYPE_LEVEL → t_busi_data_type_level
DROP TABLE IF EXISTS slaj.t_busi_data_type_level CASCADE;

-- T_BUSI_DRILL_EVA → t_busi_drill_eva
DROP TABLE IF EXISTS slaj.t_busi_drill_eva CASCADE;

-- T_BUSI_DRILL_RECORD → t_busi_drill_record
DROP TABLE IF EXISTS slaj.t_busi_drill_record CASCADE;

-- T_BUSI_ENG_PART → t_busi_eng_part
DROP TABLE IF EXISTS slaj.t_busi_eng_part CASCADE;

-- T_BUSI_ENG_SAFE_EVALUATE → t_busi_eng_safe_evaluate
DROP TABLE IF EXISTS slaj.t_busi_eng_safe_evaluate CASCADE;

-- T_BUSI_EVALUATE → t_busi_evaluate
DROP TABLE IF EXISTS slaj.t_busi_evaluate CASCADE;

-- T_BUSI_GROUP_INFO → t_busi_group_info
DROP TABLE IF EXISTS slaj.t_busi_group_info CASCADE;

-- T_BUSI_HARD_TOTAL → t_busi_hard_total
DROP TABLE IF EXISTS slaj.t_busi_hard_total CASCADE;

-- T_BUSI_HAZARD_REPORT20250113 → t_busi_hazard_report20250113
DROP TABLE IF EXISTS slaj.t_busi_hazard_report20250113 CASCADE;

-- T_BUSI_HAZ_IDENBAK → t_busi_haz_idenbak
DROP TABLE IF EXISTS slaj.t_busi_haz_idenbak CASCADE;

-- T_BUSI_HIDD_EVALUATE → t_busi_hidd_evaluate
DROP TABLE IF EXISTS slaj.t_busi_hidd_evaluate CASCADE;

-- T_BUSI_HIDD_TOTAL → t_busi_hidd_total
DROP TABLE IF EXISTS slaj.t_busi_hidd_total CASCADE;

-- T_BUSI_HUIZONG_TOTAL → t_busi_huizong_total
DROP TABLE IF EXISTS slaj.t_busi_huizong_total CASCADE;

-- T_BUSI_INSURE_INFO → t_busi_insure_info
DROP TABLE IF EXISTS slaj.t_busi_insure_info CASCADE;

-- T_BUSI_INSURE_INFO20250113 → t_busi_insure_info20250113
DROP TABLE IF EXISTS slaj.t_busi_insure_info20250113 CASCADE;

-- T_BUSI_INSURE_PRE → t_busi_insure_pre
DROP TABLE IF EXISTS slaj.t_busi_insure_pre CASCADE;

-- T_BUSI_MEET_TOTAL → t_busi_meet_total
DROP TABLE IF EXISTS slaj.t_busi_meet_total CASCADE;

-- T_BUSI_ORG_SAFE_EVALUATE → t_busi_org_safe_evaluate
DROP TABLE IF EXISTS slaj.t_busi_org_safe_evaluate CASCADE;

-- T_BUSI_POSSIBLE_ACCIDENT → t_busi_possible_accident
DROP TABLE IF EXISTS slaj.t_busi_possible_accident CASCADE;

-- T_BUSI_POSTRES → t_busi_postres
DROP TABLE IF EXISTS slaj.t_busi_postres CASCADE;

-- T_BUSI_POSTRES_PERSON → t_busi_postres_person
DROP TABLE IF EXISTS slaj.t_busi_postres_person CASCADE;

-- T_BUSI_SAFEORG_INFO → t_busi_safeorg_info
DROP TABLE IF EXISTS slaj.t_busi_safeorg_info CASCADE;

-- T_BUSI_SIX_BOOST_MWR → t_busi_six_boost_mwr
DROP TABLE IF EXISTS slaj.t_busi_six_boost_mwr CASCADE;

-- T_BUSI_SMS_RECORD → t_busi_sms_record
DROP TABLE IF EXISTS slaj.t_busi_sms_record CASCADE;

-- T_BUSI_STR_PUNISH → t_busi_str_punish
DROP TABLE IF EXISTS slaj.t_busi_str_punish CASCADE;

-- T_BUSI_SUPPLIES_RESERVE → t_busi_supplies_reserve
DROP TABLE IF EXISTS slaj.t_busi_supplies_reserve CASCADE;

-- T_BUSI_TEAM_INFO → t_busi_team_info
DROP TABLE IF EXISTS slaj.t_busi_team_info CASCADE;

-- T_BUSI_TRAIN_RECORD → t_busi_train_record
DROP TABLE IF EXISTS slaj.t_busi_train_record CASCADE;

-- T_CON_SAFE_ENU → t_con_safe_enu
DROP TABLE IF EXISTS slaj.t_con_safe_enu CASCADE;

-- T_CON_SLAJ_LOG → t_con_slaj_log
DROP TABLE IF EXISTS slaj.t_con_slaj_log CASCADE;

-- T_DICT_SCOR_CERTI → t_dict_scor_certi
DROP TABLE IF EXISTS slaj.t_dict_scor_certi CASCADE;

-- T_DICT_SCOR_PUNISH → t_dict_scor_punish
DROP TABLE IF EXISTS slaj.t_dict_scor_punish CASCADE;

-- T_SSO_USERROLE_SM3 → t_sso_userrole_sm3
DROP TABLE IF EXISTS slaj.t_sso_userrole_sm3 CASCADE;

-- T_SSO_USER_SM3 → t_sso_user_sm3
DROP TABLE IF EXISTS slaj.t_sso_user_sm3 CASCADE;