7 ms·
Tried it on SQLite's own Fossil repo, which is a kind of SQLite db too. The resulting diagram shows no relationship arrows. Turns out the Fossil's schema uses
by zoomablemind 2y ago
Tried it on SQLite's own Fossil repo, which is a kind of SQLite db too.
The resulting diagram shows no relationship arrows.
Turns out the Fossil's schema uses REFERENCES clause with a table name only; I guess, this points to table's primary key by default. Apparently, the diagram generator requires explicit column names.
- thristian 2y agoHuh. The syntax diagram in the documentation[1] suggests this is possible, but the documentation on foreign keys[2] does not mention that syntax, or how it's interpreted. I think I can fix this. [1]: https://sqlite.org/syntax/foreign-key-clause.html https://sqlite.org/syntax/foreign-key-clause.html [2]: https://sqlite.org/foreignkeys.html https://sqlite.org/foreignkeys.html
- thristian 2y agoI have pushed an update which should fix this issue.
- zoomablemind 2y agoJust tested the fix on the Fossil's db. The arrows are displayed correctly. Thanks!