dbml icon indicating copy to clipboard operation
dbml copied to clipboard

Add mandatory/optional relationship notation

Open ghost opened this issue 5 years ago • 7 comments

It would be great if the cardinality of relationships could include whether a relationship is mandatory/optional.

Some reference here

This means that at either ends of a relationship we can express the minimum cardinality and the maximum cardinality to show something like

[min_card]...[max_card]

For example, let's take the relationship between the entities STUDENT and TEACHER. Each teacher can have 0 to many students so the notation would show : 0...* each student can have 1 to many teachers (let's suppose) so the notation would show: 1...*

ghost avatar Jan 20 '20 10:01 ghost

linked to #1

lalessandrorizzo avatar Jan 20 '20 10:01 lalessandrorizzo

any interest for this feature?

lalessandrorizzo avatar Feb 21 '20 16:02 lalessandrorizzo

Hi @lalessandrorizzo ,

We already added it to our roadmap, but it's not in our priority now. Will keep you updated on the progress.

phuongduyphan avatar Feb 23 '20 03:02 phuongduyphan

Hi @phuongduyphan, it sounds great, thanks for the update.

lalessandrorizzo avatar Feb 24 '20 09:02 lalessandrorizzo