-- -- This table holds information that pertains to a transition in a specific context. -- It will specifically hold -- CREATE TABLE wf_context_transition_info ( context_key varchar(100) NOT NULL, workflow_key varchar(100) NOT NULL, transition_key varchar(100) NOT NULL, estimated_minutes integer, instructions text(-5), enable_callback varchar(100), enable_custom_arg text(-5), fire_callback varchar(100), fire_custom_arg text(-5), time_callback varchar(100), time_custom_arg text(-5), deadline_callback varchar(100), deadline_custom_arg text(-5), deadline_attribute_name varchar(100), hold_timeout_callback varchar(100), hold_timeout_custom_arg text(-5), notification_callback varchar(100), notification_custom_arg text(-5), unassigned_callback varchar(100), unassigned_custom_arg text(-5), PRIMARY KEY (context_key,workflow_key,transition_key), CONSTRAINT wf_context_trans_context_fk REFERENCES wf_contexts (), CONSTRAINT wf_context_trans_trans_fk REFERENCES wf_contexts (), CONSTRAINT wf_context_trans_workflow_fk REFERENCES wf_contexts (), CONSTRAINT wf_context_transition_pk REFERENCES wf_contexts () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_context_transition_pk REFERENCES wf_transitions (), CONSTRAINT wf_context_trans_workflow_fk REFERENCES wf_transitions (), CONSTRAINT wf_context_trans_trans_fk REFERENCES wf_transitions (), CONSTRAINT wf_context_trans_context_fk REFERENCES wf_transitions (), CONSTRAINT wf_context_transition_pk REFERENCES wf_workflows (), CONSTRAINT wf_context_trans_context_fk REFERENCES wf_workflows (), CONSTRAINT wf_context_trans_trans_fk REFERENCES wf_workflows (), CONSTRAINT wf_context_trans_workflow_fk REFERENCES wf_workflows () ); CREATE INDEX wf_ctx_trans_wf_trans_idx ON wf_context_transition_info (workflow_key, transition_key); CREATE TRIGGER RI_ConstraintTrigger_c_343389 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343390 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343394 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343395 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343399 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343400 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 1
Begin main content
