-- -- The tasks that need to be done, who can do it, and what state it's in. -- A task is the instance of a transition. -- CREATE TABLE wf_tasks ( task_id integer PRIMARY KEY NOT NULL, case_id integer, workflow_key varchar(100), transition_key varchar(100), state varchar(40) DEFAULT 'enabled'::character varying, enabled_date timestamptz DEFAULT now(), started_date timestamptz, canceled_date timestamptz, finished_date timestamptz, overridden_date timestamptz, trigger_time timestamptz, deadline timestamptz, estimated_minutes integer, holding_user integer, hold_timeout timestamptz, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_task_holding_user_fk REFERENCES wf_cases (), CONSTRAINT wf_task_pk REFERENCES wf_cases (), CONSTRAINT wf_task_state_ck REFERENCES wf_cases (), CONSTRAINT wf_task_workflow_fk REFERENCES wf_cases (), CONSTRAINT wf_task_case_fk REFERENCES wf_cases (), CONSTRAINT wf_task_transition_fk REFERENCES wf_cases () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_task_state_ck REFERENCES users (), CONSTRAINT wf_task_case_fk REFERENCES users (), CONSTRAINT wf_task_holding_user_fk REFERENCES users (), CONSTRAINT wf_task_pk REFERENCES users (), CONSTRAINT wf_task_transition_fk REFERENCES users (), CONSTRAINT wf_task_workflow_fk REFERENCES users (), CONSTRAINT wf_task_workflow_fk REFERENCES wf_transitions (), CONSTRAINT wf_task_transition_fk REFERENCES wf_transitions (), CONSTRAINT wf_task_state_ck REFERENCES wf_transitions (), CONSTRAINT wf_task_pk REFERENCES wf_transitions (), CONSTRAINT wf_task_holding_user_fk REFERENCES wf_transitions (), CONSTRAINT wf_task_case_fk REFERENCES wf_transitions (), CONSTRAINT wf_task_workflow_fk REFERENCES wf_workflows (), CONSTRAINT wf_task_case_fk REFERENCES wf_workflows (), CONSTRAINT wf_task_holding_user_fk REFERENCES wf_workflows (), CONSTRAINT wf_task_pk REFERENCES wf_workflows (), CONSTRAINT wf_task_state_ck REFERENCES wf_workflows (), CONSTRAINT wf_task_transition_fk REFERENCES wf_workflows () ); CREATE INDEX wf_tasks_case_id_idx ON wf_tasks (case_id); CREATE INDEX wf_tasks_holding_user_idx ON wf_tasks (holding_user); CREATE TRIGGER RI_ConstraintTrigger_a_343502 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343503 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343509 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343510 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343514 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343515 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343524 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343525 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343529 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343530 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343557 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343558 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to wf_tasks: --wf_task_assignments(wf_task_case_fk) --wf_task_assignments(wf_task_holding_user_fk) --wf_task_assignments(wf_task_pk) --wf_task_assignments(wf_task_state_ck) --wf_task_assignments(wf_task_transition_fk) --wf_task_assignments(wf_task_workflow_fk) --wf_tokens(wf_task_case_fk) --wf_tokens(wf_task_holding_user_fk) --wf_tokens(wf_task_pk) --wf_tokens(wf_task_state_ck) --wf_tokens(wf_task_transition_fk) --wf_tokens(wf_task_workflow_fk) -- Table size: 0 bytes -- Table rows: 0
Begin main content
