select c.constraint_id, c.constraint_name, c.rel_side from rel_constraints c where c.rel_segment = :segment_id