说明 / 示例
删除之前做好备份
删除之前做好备份
删除之前做好备份
查询字段关联
select * from t_sys_column t where t.column_code='FAT_DEF_012_BO_DATA_ID'
select * from t_bill_area_field f where f.bill_area_field_id='7b0dfa7201ea11eab448b5dc2cb26c4f';
select * from T_BILL_DEFINE_AREA_FIELD tdf where tdf.bill_area_field_id = '7b0dfa7201ea11eab448b5dc2cb26c4f';
select * from t_bill_define_field tf where tf.bill_area_field_id='7b0dfa7201ea11eab448b5dc2cb26c4f';
select * from t_bill_define_field_history tfh where tfh.bill_area_field_id='7b0dfa7201ea11eab448b5dc2cb26c4f';
---data_id为tips_language_key
select * from t_i18n_dynamic td where td.data_id='7d418afcdb7311e9ba39f16aa0a8a894';
---data_id为bill_area_field_id
select * from t_i18n_dynamic td where td.data_id='7b0dfa7201ea11eab448b5dc2cb26c4f';
---graphpointinfo_id为bill_area_field_id
SELECT * from t_rule_graphpointinfo t WHERE t.graphpointinfo_id = '7b0dfa7201ea11eab448b5dc2cb26c4f';
---start_pointid为bill_area_field_id
SELECT * from t_rule_graphpointrelation s WHERE s.start_pointid = '7b0dfa7201ea11eab448b5dc2cb26c4f';
---end_pointid为bill_area_field_id
SELECT * from t_rule_graphpointrelation s WHERE s.end_pointid = '7b0dfa7201ea11eab448b5dc2cb26c4f';
删除字段关联
ALTER TABLE XXX DROP COLUMN XXX;
delete from t_sys_column where column_id=''
delete from t_bill_area_field where bill_area_field_id='7b0dfa7201ea11eab448b5dc2cb26c4f';
delete from T_BILL_DEFINE_AREA_FIELD where bill_area_field_id = '7b0dfa7201ea11eab448b5dc2cb26c4f';
delete from t_bill_define_field where bill_area_field_id='7b0dfa7201ea11eab448b5dc2cb26c4f';
delete from t_bill_define_field_history where bill_area_field_id='7b0dfa7201ea11eab448b5dc2cb26c4f';
---data_id为tips_language_key
delete from t_i18n_dynamic where data_id='7d418afcdb7311e9ba39f16aa0a8a894';
---data_id为bill_area_field_id
delete from t_i18n_dynamic where data_id='7b0dfa7201ea11eab448b5dc2cb26c4f';
---graphpointinfo_id为bill_area_field_id;
delete from t_rule_graphpointinfo WHERE graphpointinfo_id = '7b0dfa7201ea11eab448b5dc2cb26c4f';
---start_pointid为bill_area_field_id
delete from t_rule_graphpointrelation WHERE start_pointid = '7b0dfa7201ea11eab448b5dc2cb26c4f';
---end_pointid为bill_area_field_id
delete from t_rule_graphpointrelation WHERE end_pointid = '7b0dfa7201ea11eab448b5dc2cb26c4f';