'relations' uniqueness

[lrkwz]

Feature Request

Add unique key to directus_relations(collection_many, field_many, collection_one, field_one, junction_field).

What problem does this feature solve?

• Two users creating the same relation
• Two identical rows inserted by repeated changes on data structure (create a relation then modify relation)

How do you think this should be implemented?

CREATE INDEX...

Would you be willing to work on this?

This is fairly easy, it's isn't that easy handle all the error condition that will arise from this change.

[benhaynes]

Thanks @lrkwz — we'll take a look at potentially adding this once @wellingguzman is back.

[lrkwz]

Probably #537 would benefit of this

[rijkvanzanten]

I think #586 might potentially solve this as well

[lrkwz]

Still I suggest to enforce strong bonds directly in database for relations (unique indexes, foreign keys, ...) this will eventually let code errors immediately visible.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[benhaynes]

To achieve better clarity/visibility, we are now tracking feature requests within the Feature Request project board.

This issue being closed does not mean it's not being considered.