problem with ref & sql generation

[xerosanyam]

Hi team, I found some issues:

1. sql generation:

the following markup

ref: remfo.cards.user_id - auth.users.id

generates following sql:

ALTER TABLE "auth"."users" ADD FOREIGN KEY ("id") REFERENCES "remfo"."cards" ("user_id");

This is confusing.
I feel the table we are altering should come first as it will resemble the sql query more.

2. dbdiagram should show an arrow

for syntax:

ref: remfo.cards.user_id - auth.users.id

I find following more informative:

than:

(look at the arrow)

[huyphung1602]

Hi @xerosanyam,

I am Huy Phung from the dbdiagram team.

Thank you for sharing your concerns and suggestions. We're discussing it.
We'll be back when there's an update.

Have an enjoyable weekend!

Best regards
Huy Phung