-- -- Defines relational constraints. The relational constraints system is -- intended to support applications in modelling and applying -- constraint rules on inter-party relatinships based on relational -- party segmentation. -- CREATE TABLE rel_constraints ( constraint_id integer PRIMARY KEY NOT NULL, -- -- The user-defined name of this constraint. -- constraint_name varchar(100) NOT NULL, -- -- The segment for which the constraint is defined. -- rel_segment integer NOT NULL, -- -- The side of the relation the constraint applies to. -- rel_side char(3) DEFAULT 'two'::bpchar NOT NULL, -- -- The segment in which elements must be in to satisfy the constraint. -- required_rel_segment integer NOT NULL, CONSTRAINT rc_constraint_id_fk REFERENCES acs_objects (), CONSTRAINT rc_rel_segment_fk REFERENCES acs_objects (), CONSTRAINT rc_rel_side_ck REFERENCES acs_objects (), CONSTRAINT rc_required_rel_segment REFERENCES acs_objects (), CONSTRAINT rel_constraints_pk REFERENCES acs_objects (), CONSTRAINT rc_constraint_id_fk REFERENCES rel_segments (), CONSTRAINT rc_rel_segment_fk REFERENCES rel_segments (), CONSTRAINT rc_rel_side_ck REFERENCES rel_segments (), CONSTRAINT rc_required_rel_segment REFERENCES rel_segments (), CONSTRAINT rel_constraints_pk REFERENCES rel_segments (), CONSTRAINT rel_constraints_pk REFERENCES rel_segments (), CONSTRAINT rc_constraint_id_fk REFERENCES rel_segments (), CONSTRAINT rc_rel_segment_fk REFERENCES rel_segments (), CONSTRAINT rc_rel_side_ck REFERENCES rel_segments (), CONSTRAINT rc_required_rel_segment REFERENCES rel_segments () ); CREATE INDEX rel_constraint_req_rel_seg_idx ON rel_constraints (required_rel_segment); CREATE UNIQUE INDEX rel_constraints_uq ON rel_constraints (rel_segment, rel_side, required_rel_segment); CREATE TRIGGER rel_constraints_del_tr AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE rel_constraints_del_tr (disabled) CREATE TRIGGER rel_constraints_ins_tr AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE rel_constraints_ins_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342839 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342840 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342849 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342850 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342859 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342860 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 9
Begin main content
