0

I have this:

enter image description here

I wanna change the users table to this:

enter image description here

I added nullable constraint on usersId in the orders table but that didn't change anything on the ERD. Is this a problem with pgadmin or I'm doing something wrong?

aryankarim
  • 184
  • 1
  • 10
  • 2
    if `orders (usersId)` is nullable, then that's enough for the cardinality to be optional (aka 0:1). There must be an issue with the drawing tool. – The Impaler Jul 11 '22 at 20:01

1 Answers1

1

The ERD diagramming tool of pgadmin seems designed to represent only one-to-many and many-to-many relations.

It is not capable (yet?) of representing simple one-to-one relations, and seems not capable either according to the screenshots in the documentation to indicate optional or mandatory participation in a relation (e.g. double bar or circle bar).

The best way forward would be to log an issue in pgadmin's official issue tracker.

Christophe
  • 68,716
  • 7
  • 72
  • 138