-- -- This table holds all the attribute values that has been set, -- so we can track changes over the lifetime of a case. -- CREATE TABLE wf_attribute_value_audit ( case_id integer NOT NULL, attribute_id integer NOT NULL, journal_id integer NOT NULL, attr_value text(-5), PRIMARY KEY (case_id,attribute_id,journal_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_attr_val_audit_attr_fk REFERENCES acs_attributes (), CONSTRAINT wf_attr_val_audit_case_fk REFERENCES acs_attributes (), CONSTRAINT wf_attr_val_audit_journal_fk REFERENCES acs_attributes (), CONSTRAINT wf_attr_val_audit_pk REFERENCES acs_attributes () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_attr_val_audit_pk REFERENCES wf_cases (), CONSTRAINT wf_attr_val_audit_journal_fk REFERENCES wf_cases (), CONSTRAINT wf_attr_val_audit_case_fk REFERENCES wf_cases (), CONSTRAINT wf_attr_val_audit_attr_fk REFERENCES wf_cases (), CONSTRAINT wf_attr_val_audit_pk REFERENCES journal_entries (), CONSTRAINT wf_attr_val_audit_attr_fk REFERENCES journal_entries (), CONSTRAINT wf_attr_val_audit_case_fk REFERENCES journal_entries (), CONSTRAINT wf_attr_val_audit_journal_fk REFERENCES journal_entries () ); CREATE INDEX wf_attr_val_aud_attr_id_idx ON wf_attribute_value_audit (attribute_id); CREATE TRIGGER RI_ConstraintTrigger_c_343184 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343185 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343189 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343190 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343194 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343195 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
