CREATE TABLE workflow_fsm_action_en_in_st ( action_id integer NOT NULL, state_id integer NOT NULL, assigned_p bool DEFAULT true, PRIMARY KEY (action_id,state_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_fsm_acn_enb_in_st_acn_id_fk REFERENCES workflow_actions (), CONSTRAINT wf_fsm_acn_enb_in_st_st_id_fk REFERENCES workflow_actions (), CONSTRAINT workflow_fsm_action_en_in_st_pk REFERENCES workflow_actions () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT workflow_fsm_action_en_in_st_pk REFERENCES workflow_fsm_states (), CONSTRAINT wf_fsm_acn_enb_in_st_acn_id_fk REFERENCES workflow_fsm_states (), CONSTRAINT wf_fsm_acn_enb_in_st_st_id_fk REFERENCES workflow_fsm_states () ); CREATE INDEX wf_fsm_act_en_in_st_action_idx ON workflow_fsm_action_en_in_st (action_id); CREATE INDEX wf_fsm_act_en_in_st_state_idx ON workflow_fsm_action_en_in_st (state_id); CREATE TRIGGER RI_ConstraintTrigger_c_343419 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343420 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343424 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343425 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 28
Begin main content
