KCDS

id 483 破棄契約
id 476 元変更契約
property_id: 32

破棄契約の契約書PDFコードを一応残しておくが、バッチで自動削除予定。
order_pdf: order_483_1771398803_6556
petition_pdf: petition_483_1771398803_5261
contract_pdf: origin_483_1771398804_1559

元契約を元に戻す。
UPDATE ms_contract SET close_status = 2, copy_contract_id = NULL WHERE contract_id = 476;

変更契約なので、原契約のclose_statusも元に戻す。
UPDATE ms_contract SET close_status = 1 WHERE contract_id = 369;

作成した破棄契約をなかったことに。

破棄履歴の削除
DELETE FROM re_delete_relation WHERE delete_relation_id = '32-1-2';

破棄契約のツリー情報削除
DELETE FROM ms_tree_paths WHERE contract_id = 483;

発注明細の削除
DELETE FROM ms_construction_price WHERE contract_id = 483;

破棄契約の削除
DELETE FROM ms_contract WHERE contract_id = 483;

実行SQL
UPDATE ms_contract SET close_status = 2, copy_contract_id = NULL WHERE contract_id = 476;
UPDATE ms_contract SET close_status = 1 WHERE contract_id = 369;
DELETE FROM re_delete_relation WHERE delete_relation_id = '32-1-2';
DELETE FROM ms_tree_paths WHERE contract_id = 483;
DELETE FROM ms_construction_price WHERE contract_id = 483;
DELETE FROM ms_contract WHERE contract_id = 483;