-- -- The instance of a process, e.g. the case of publishing one article, -- the case of handling one insurance claim, the case of handling -- one ecommerce order, of fixing one ticket-tracker ticket. -- CREATE TABLE wf_cases ( case_id integer PRIMARY KEY NOT NULL, workflow_key varchar(100), context_key varchar(100), -- -- A case is generally about some other object, e.g., an insurance claim, an article, -- a ticket, an order, etc. This is the place to store the reference to that object. -- It is not uncommong to have more than one case for the same object, e.g., we might -- have one process for evaluating and honoring an insurance claim, and another for archiving -- legal information about a claim. -- object_id integer, state varchar(40) DEFAULT 'created'::character varying, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_cases_context_fk REFERENCES acs_objects (), CONSTRAINT wf_cases_object_fk REFERENCES acs_objects (), CONSTRAINT wf_cases_pk REFERENCES acs_objects (), CONSTRAINT wf_cases_workflow_fk REFERENCES acs_objects (), CONSTRAINT wf_cases_acs_object_fk REFERENCES acs_objects (), CONSTRAINT wf_cases_state_ck REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_cases_pk REFERENCES wf_contexts (), CONSTRAINT wf_cases_acs_object_fk REFERENCES wf_contexts (), CONSTRAINT wf_cases_context_fk REFERENCES wf_contexts (), CONSTRAINT wf_cases_object_fk REFERENCES wf_contexts (), CONSTRAINT wf_cases_state_ck REFERENCES wf_contexts (), CONSTRAINT wf_cases_workflow_fk REFERENCES wf_contexts () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_cases_workflow_fk REFERENCES acs_objects (), CONSTRAINT wf_cases_state_ck REFERENCES acs_objects (), CONSTRAINT wf_cases_pk REFERENCES acs_objects (), CONSTRAINT wf_cases_object_fk REFERENCES acs_objects (), CONSTRAINT wf_cases_context_fk REFERENCES acs_objects (), CONSTRAINT wf_cases_acs_object_fk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_cases_workflow_fk REFERENCES wf_workflows (), CONSTRAINT wf_cases_acs_object_fk REFERENCES wf_workflows (), CONSTRAINT wf_cases_context_fk REFERENCES wf_workflows (), CONSTRAINT wf_cases_object_fk REFERENCES wf_workflows (), CONSTRAINT wf_cases_pk REFERENCES wf_workflows (), CONSTRAINT wf_cases_state_ck REFERENCES wf_workflows () ); CREATE INDEX wf_cases_context_key_idx ON wf_cases (context_key); CREATE INDEX wf_cases_object_id_idx ON wf_cases (object_id); CREATE INDEX wf_cases_workflow_key_idx ON wf_cases (workflow_key); CREATE TRIGGER RI_ConstraintTrigger_a_343177 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343178 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343187 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343188 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343207 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343208 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343222 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343223 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343299 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343300 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343304 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343305 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343309 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343310 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343319 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343320 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343507 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343508 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343567 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343568 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to wf_cases: --wf_article_cases(wf_cases_acs_object_fk) --wf_article_cases(wf_cases_context_fk) --wf_article_cases(wf_cases_object_fk) --wf_article_cases(wf_cases_pk) --wf_article_cases(wf_cases_state_ck) --wf_article_cases(wf_cases_workflow_fk) --wf_attribute_value_audit(wf_cases_acs_object_fk) --wf_attribute_value_audit(wf_cases_context_fk) --wf_attribute_value_audit(wf_cases_object_fk) --wf_attribute_value_audit(wf_cases_pk) --wf_attribute_value_audit(wf_cases_state_ck) --wf_attribute_value_audit(wf_cases_workflow_fk) --wf_case_assignments(wf_cases_acs_object_fk) --wf_case_assignments(wf_cases_context_fk) --wf_case_assignments(wf_cases_object_fk) --wf_case_assignments(wf_cases_pk) --wf_case_assignments(wf_cases_state_ck) --wf_case_assignments(wf_cases_workflow_fk) --wf_case_deadlines(wf_cases_acs_object_fk) --wf_case_deadlines(wf_cases_context_fk) --wf_case_deadlines(wf_cases_object_fk) --wf_case_deadlines(wf_cases_pk) --wf_case_deadlines(wf_cases_state_ck) --wf_case_deadlines(wf_cases_workflow_fk) --wf_tasks(wf_cases_acs_object_fk) --wf_tasks(wf_cases_context_fk) --wf_tasks(wf_cases_object_fk) --wf_tasks(wf_cases_pk) --wf_tasks(wf_cases_state_ck) --wf_tasks(wf_cases_workflow_fk) --wf_tokens(wf_cases_acs_object_fk) --wf_tokens(wf_cases_context_fk) --wf_tokens(wf_cases_object_fk) --wf_tokens(wf_cases_pk) --wf_tokens(wf_cases_state_ck) --wf_tokens(wf_cases_workflow_fk) -- Table size: 0 bytes -- Table rows: 0
Begin main content
