CREATE TABLE workflow_case_log ( entry_id integer PRIMARY KEY NOT NULL, case_id integer, action_id integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_log_acn_id_fk REFERENCES workflow_actions (), CONSTRAINT wf_case_log_case_id_fk REFERENCES workflow_actions (), CONSTRAINT wf_case_log_cr_items_fk REFERENCES workflow_actions (), CONSTRAINT wf_case_log_pk REFERENCES workflow_actions () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_log_pk REFERENCES workflow_cases (), CONSTRAINT wf_case_log_cr_items_fk REFERENCES workflow_cases (), CONSTRAINT wf_case_log_case_id_fk REFERENCES workflow_cases (), CONSTRAINT wf_case_log_acn_id_fk REFERENCES workflow_cases (), CONSTRAINT wf_case_log_pk REFERENCES cr_items (), CONSTRAINT wf_case_log_acn_id_fk REFERENCES cr_items (), CONSTRAINT wf_case_log_case_id_fk REFERENCES cr_items (), CONSTRAINT wf_case_log_cr_items_fk REFERENCES cr_items () ); CREATE INDEX workflow_case_log_action_id ON workflow_case_log (action_id); CREATE INDEX workflow_case_log_case_id ON workflow_case_log (case_id); CREATE TRIGGER RI_ConstraintTrigger_c_343264 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343265 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343269 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343270 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343274 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343275 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343277 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343278 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to workflow_case_log: --workflow_case_log_data(wf_case_log_acn_id_fk) --workflow_case_log_data(wf_case_log_case_id_fk) --workflow_case_log_data(wf_case_log_cr_items_fk) --workflow_case_log_data(wf_case_log_pk) -- Table size: 655,360 bytes -- Table rows: 14,622
Begin main content
