CREATE TABLE workflow_roles ( role_id integer PRIMARY KEY NOT NULL, workflow_id integer NOT NULL, short_name varchar(100) NOT NULL, pretty_name varchar(200) NOT NULL, sort_order integer NOT NULL, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_roles_pk REFERENCES workflows (), CONSTRAINT wf_roles_workflow_id_fk REFERENCES workflows (), CONSTRAINT wf_roles_short_name_un REFERENCES workflows (), CONSTRAINT wf_roles_pretty_name_un REFERENCES workflows () ); CREATE UNIQUE INDEX wf_roles_pretty_name_un ON workflow_roles (workflow_id, pretty_name); CREATE UNIQUE INDEX wf_roles_short_name_un ON workflow_roles (workflow_id, short_name); CREATE TRIGGER RI_ConstraintTrigger_a_343127 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343128 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343152 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_setnull_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343153 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343292 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343293 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343457 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343458 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343477 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343478 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343487 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343488 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343499 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343500 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to workflow_roles: --workflow_action_allowed_roles(wf_roles_pk) --workflow_action_allowed_roles(wf_roles_pretty_name_un) --workflow_action_allowed_roles(wf_roles_short_name_un) --workflow_action_allowed_roles(wf_roles_workflow_id_fk) --workflow_actions(wf_roles_pk) --workflow_actions(wf_roles_pretty_name_un) --workflow_actions(wf_roles_short_name_un) --workflow_actions(wf_roles_workflow_id_fk) --workflow_case_role_party_map(wf_roles_pk) --workflow_case_role_party_map(wf_roles_pretty_name_un) --workflow_case_role_party_map(wf_roles_short_name_un) --workflow_case_role_party_map(wf_roles_workflow_id_fk) --workflow_role_allowed_parties(wf_roles_pk) --workflow_role_allowed_parties(wf_roles_pretty_name_un) --workflow_role_allowed_parties(wf_roles_short_name_un) --workflow_role_allowed_parties(wf_roles_workflow_id_fk) --workflow_role_callbacks(wf_roles_pk) --workflow_role_callbacks(wf_roles_pretty_name_un) --workflow_role_callbacks(wf_roles_short_name_un) --workflow_role_callbacks(wf_roles_workflow_id_fk) --workflow_role_default_parties(wf_roles_pk) --workflow_role_default_parties(wf_roles_pretty_name_un) --workflow_role_default_parties(wf_roles_short_name_un) --workflow_role_default_parties(wf_roles_workflow_id_fk) -- Table size: 8,192 bytes -- Table rows: 8
Begin main content
