problem with ref & sql generation
Open
enhancement
- Dominant language
- JavaScript
- Stars
- 3.7k
- Forks
- 233
- Avg merge
- 1d 23h
- Merged PRs (30d)
- 4
Description
Hi team, I found some issues:
## 1. sql generation:
the following markup
```dbml
ref: remfo.cards.user_id - auth.users.id
```
generates following sql:
```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:
```dbml
ref: remfo.cards.user_id - auth.users.id
```
I find following more informative:
than:
(look at the arrow)
Contributor guide
Assessment
This issue has not been assessed yet.