CREATE TABLE workflow_fsm_states ( state_id integer PRIMARY KEY NOT NULL, workflow_id integer NOT NULL, parent_action_id integer, sort_order integer NOT NULL, short_name varchar(100) NOT NULL, pretty_name varchar(200) NOT NULL, hide_fields varchar(4000), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_fsm_states_parent_action_fk REFERENCES workflow_actions (), CONSTRAINT wf_fsm_states_pk REFERENCES workflow_actions (), CONSTRAINT wf_fsm_states_pretty_name_un REFERENCES workflow_actions (), CONSTRAINT wf_fsm_states_short_name_un REFERENCES workflow_actions (), CONSTRAINT wf_fsm_states_workflow_id_fk REFERENCES workflow_actions () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_fsm_states_workflow_id_fk REFERENCES workflows (), CONSTRAINT wf_fsm_states_parent_action_fk REFERENCES workflows (), CONSTRAINT wf_fsm_states_pk REFERENCES workflows (), CONSTRAINT wf_fsm_states_pretty_name_un REFERENCES workflows (), CONSTRAINT wf_fsm_states_short_name_un REFERENCES workflows () ); CREATE UNIQUE INDEX wf_fsm_states_pretty_name_un ON workflow_fsm_states (workflow_id, parent_action_id, pretty_name); CREATE INDEX wf_fsm_states_prnt_action_idx ON workflow_fsm_states (parent_action_id); CREATE UNIQUE INDEX wf_fsm_states_short_name_un ON workflow_fsm_states (workflow_id, short_name); CREATE INDEX wf_fsm_states_workflow_idx ON workflow_fsm_states (workflow_id); CREATE TRIGGER RI_ConstraintTrigger_a_343257 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343258 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343422 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343423 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343432 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_setnull_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343433 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343439 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343440 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343444 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343445 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to workflow_fsm_states: --workflow_case_fsm(wf_fsm_states_parent_action_fk) --workflow_case_fsm(wf_fsm_states_pk) --workflow_case_fsm(wf_fsm_states_pretty_name_un) --workflow_case_fsm(wf_fsm_states_short_name_un) --workflow_case_fsm(wf_fsm_states_workflow_id_fk) --workflow_fsm_action_en_in_st(wf_fsm_states_parent_action_fk) --workflow_fsm_action_en_in_st(wf_fsm_states_pk) --workflow_fsm_action_en_in_st(wf_fsm_states_pretty_name_un) --workflow_fsm_action_en_in_st(wf_fsm_states_short_name_un) --workflow_fsm_action_en_in_st(wf_fsm_states_workflow_id_fk) --workflow_fsm_actions(wf_fsm_states_parent_action_fk) --workflow_fsm_actions(wf_fsm_states_pk) --workflow_fsm_actions(wf_fsm_states_pretty_name_un) --workflow_fsm_actions(wf_fsm_states_short_name_un) --workflow_fsm_actions(wf_fsm_states_workflow_id_fk) -- Table size: 8,192 bytes -- Table rows: 12
Begin main content
