Regarding my last suggestion, I believe it should be:
create or replace view rel_constraints_violated_one as
select constrained_rels.constraint_id, constrained_rels.constraint_name, constrained_rels.rel_id, constrained_rels.container_id, constrained_rels.party_id,
constrained_rels.rel_type, constrained_rels.rel_segment, constrained_rels.rel_side, constrained_rels.required_rel_segment
from ...
and similar for the rel_constraints_violated_two view.
