Under review

Crow's Foot Notation Showing Incorrect Notation For One-to-Zero-or-One relationship

cloyd 3 years ago updated by Support 3 years ago 2

See image below. This should be a One-to-Zero-or-One relationship, but shows as a One-to-Zero-or-Many relationship.

Image 1225

It looks like I can change the cardinality of this in the relationship properties (there's no 1:0..1 option, just 1:1 but that works just as well) so I'm guessing there's just no auto-identification of relationships between tables?

Under review

Yes, there is no auto-identification of relationships as of now, but we will improve the system to do that.

Thanks for reporting,

Team - SqlDBM