CREATE TABLE rc_segment_required_seg_map (
rel_segment integer NOT NULL,
rel_side char(3) NOT NULL,
required_rel_segment integer NOT NULL,
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 rc_required_rel_segment REFERENCES rel_segments (),
CONSTRAINT rc_rel_segment_fk REFERENCES rel_segments (),
CONSTRAINT rc_rel_side_ck REFERENCES rel_segments ()
);
CREATE INDEX rc_segment_required_seg_idx ON rc_segment_required_seg_map (required_rel_segment);
CREATE UNIQUE INDEX rc_segment_required_seg_map_uq ON rc_segment_required_seg_map (rel_segment, rel_side, required_rel_segment);
CREATE TRIGGER RI_ConstraintTrigger_c_342844 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342845 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342854 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342855 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Table size: 8,192 bytes
-- Table rows: 9
Tables: