請求表操作表:用戶信息表(person_tab)
種類:Before delete
功能描述:關聯刪除所有外鍵指向該表的數據行,刪除與人員關連的數據行
操作表:
日歷提示信息表(calendarNote_tab)
公文基礎信息表(documentBaseInfo_tab)
AB角
工作分工信息表(divideWork_tab)
公文督辦基礎信息表(superviseBaseInfo_tab)
人員在崗信息表(guardInfo_tab)
周工作計劃信息表(planOfWeek_tab)
/***************************************************/ create or replace TRIGGER DelPerson BEFORE DELETE ON person_tab FOR EACH ROW BEGIN delete from calendarNote_tab where calendarNote_tab.c_userId =:old.p_userId; delete from documentBaseInfo_tab where documentBaseInfo_tab.dbi_publishUserId =:old.p_userId; delete from superviseBaseInfo_tab where superviseBaseInfo_tab.sbi_enterUserId =:old.p_userId; delete from divideWork_tab where divideWork_tab.dw_enterUserId=:old.p_userId; delete from guardInfo_tab where guardInfo_tab.gi_userId=:old.p_userId; delete from planOfWeek_tab where planOfWeek_tab.pw_userId=:old.p_userId; END; |
請求表操作表:組織結構信息表(department_tab)
種類: Before delete
功能描述:關聯刪除所有外鍵指向該表的數據行,刪除與部門有關的數據行
操作表:用戶信息表(person_tab)
/***************************************************/ create or replace TRIGGER Deldepartment BEFORE DELETE ON DEPARTMENT_TAB FOR EACH ROW BEGIN delete from person_tab where person_tab.p_departmentId =:old.dm_id; END; |