-- -- Defines relational segments. Each relational segment is a pair of --group_id/rel_type, or, in english, the -- parties that have a relation of type rel_type to group_id. -- CREATE TABLE rel_segments ( segment_id integer PRIMARY KEY NOT NULL, -- -- The user-entered name of the relational segment. -- segment_name varchar(230) NOT NULL, -- -- The group for which this segment was created. -- group_id integer NOT NULL, -- -- The relationship type used to define elements in this segment. -- rel_type varchar(100) NOT NULL, CONSTRAINT rel_segments_group_id_fk REFERENCES groups (), CONSTRAINT rel_segments_pk REFERENCES groups (), CONSTRAINT rel_segments_rel_type_fk REFERENCES groups (), CONSTRAINT rel_segments_segment_id_fk REFERENCES groups (), CONSTRAINT rel_segments_segment_id_fk REFERENCES acs_rel_types (), CONSTRAINT rel_segments_rel_type_fk REFERENCES acs_rel_types (), CONSTRAINT rel_segments_pk REFERENCES acs_rel_types (), CONSTRAINT rel_segments_group_id_fk REFERENCES acs_rel_types (), CONSTRAINT rel_segments_segment_id_fk REFERENCES parties (), CONSTRAINT rel_segments_group_id_fk REFERENCES parties (), CONSTRAINT rel_segments_pk REFERENCES parties (), CONSTRAINT rel_segments_rel_type_fk REFERENCES parties () ); CREATE UNIQUE INDEX rel_segments_grp_rel_type_uq ON rel_segments (group_id, rel_type); CREATE INDEX rel_segments_rel_type_idx ON rel_segments (rel_type); CREATE TRIGGER rel_segments_del_tr BEFORE DELETE FOR EACH ROW EXECUTE PROCEDURE rel_segments_del_tr (disabled) CREATE TRIGGER rel_segments_in_tr BEFORE INSERT FOR EACH ROW EXECUTE PROCEDURE rel_segments_in_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342842 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342843 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342847 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342848 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342852 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342853 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342857 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342858 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342869 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342870 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342874 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342875 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342879 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342880 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to rel_segments: --rc_segment_required_seg_map(rel_segments_group_id_fk) --rc_segment_required_seg_map(rel_segments_pk) --rc_segment_required_seg_map(rel_segments_rel_type_fk) --rc_segment_required_seg_map(rel_segments_segment_id_fk) --rel_constraints(rel_segments_group_id_fk) --rel_constraints(rel_segments_pk) --rel_constraints(rel_segments_rel_type_fk) --rel_constraints(rel_segments_segment_id_fk) -- Table size: 8,192 bytes -- Table rows: 14
Begin main content
