-- -- Manual deadlines for the individual transitions (tasks) on a per-case basis. -- CREATE TABLE wf_case_deadlines ( case_id integer NOT NULL, workflow_key varchar(100), transition_key varchar(100) NOT NULL, deadline timestamptz NOT NULL, PRIMARY KEY (case_id,transition_key), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_deadline_fk REFERENCES wf_cases (), CONSTRAINT wf_case_deadline_pk REFERENCES wf_cases (), CONSTRAINT wf_case_deadline_trans_fk REFERENCES wf_cases () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_case_deadline_trans_fk REFERENCES wf_transitions (), CONSTRAINT wf_case_deadline_fk REFERENCES wf_transitions (), CONSTRAINT wf_case_deadline_pk REFERENCES wf_transitions () ); CREATE TRIGGER RI_ConstraintTrigger_c_343224 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343225 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343229 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343230 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
