--
-- Holds information about the panels to be displayed on the task page.
--
CREATE TABLE wf_context_task_panels (
context_key varchar(100) NOT NULL,
workflow_key varchar(100) NOT NULL,
transition_key varchar(100) NOT NULL,
sort_order integer NOT NULL,
header varchar(200) NOT NULL,
template_url varchar(500) NOT NULL,
overrides_action_p char(1) DEFAULT 'f'::bpchar,
only_display_when_started_p char(1) DEFAULT 'f'::bpchar,
PRIMARY KEY (context_key,workflow_key,transition_key,sort_order),
ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT wf_context_panels_context_fk REFERENCES wf_contexts (),
CONSTRAINT wf_context_panels_display_p_ck REFERENCES wf_contexts (),
CONSTRAINT wf_context_panels_ovrd_p_ck REFERENCES wf_contexts (),
CONSTRAINT wf_context_panels_pk REFERENCES wf_contexts (),
CONSTRAINT wf_context_panels_trans_fk REFERENCES wf_contexts (),
CONSTRAINT wf_context_panels_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_context_panels_context_fk REFERENCES wf_transitions (),
CONSTRAINT wf_context_panels_display_p_ck REFERENCES wf_transitions (),
CONSTRAINT wf_context_panels_ovrd_p_ck REFERENCES wf_transitions (),
CONSTRAINT wf_context_panels_pk REFERENCES wf_transitions (),
CONSTRAINT wf_context_panels_trans_fk REFERENCES wf_transitions (),
CONSTRAINT wf_context_panels_workflow_fk REFERENCES wf_transitions () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT wf_context_panels_workflow_fk REFERENCES wf_workflows (),
CONSTRAINT wf_context_panels_context_fk REFERENCES wf_workflows (),
CONSTRAINT wf_context_panels_display_p_ck REFERENCES wf_workflows (),
CONSTRAINT wf_context_panels_ovrd_p_ck REFERENCES wf_workflows (),
CONSTRAINT wf_context_panels_pk REFERENCES wf_workflows (),
CONSTRAINT wf_context_panels_trans_fk REFERENCES wf_workflows ()
);
CREATE INDEX wf_ctx_panl_workflow_trans_idx ON wf_context_task_panels (workflow_key, transition_key);
CREATE TRIGGER RI_ConstraintTrigger_c_343359 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343360 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343364 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343365 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343369 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343370 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Table size: 0 bytes
-- Table rows: 0
Tables: