🚀 Feature: Relationship - unique index

[danilo73r]

🔖 Feature description

Allow to include the id of a relationship (many to one for example) in a unique index.

🎤 Pitch

Useful for a lot of use cases.

For example: An order can't have same product in two lines, so i need unique index (product_id, order_id)

collection: order_line

• attr: product_id (relationship)
• attr: order_id (relationship)

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[joeyouss]

Hi, thank you for raising this. Opening it for the community to vote/leave their feedback on this as of now!

[pierroo]

Yes, very much needed!

Another example would be a chatting app, I wanna make sure I cannot create twice the same "conversation".
A 1:1 conversation having attributes "from_id" (my user id) and "friend_id" for example.

Instead of having to do first a query to make sure it doesn't exist yet, I would like the insert to be rejected by the database itself if the duo "from_id"/"friend_id" already exists