I was very pleased to discover SQL Power Architect recently but I've come across an issue.
I'm trying to reverse engineer a PostgreSQL DB and finding that the FKs are getting dropped. Not all of them, just some. There doesn't seem to be a pattern that I can tell.
Frustratingly I did find the following topic when I did a search, but it's coming up as not existing: Losing some Foreign Keys when reverse engineering Postgresql databases
One of the tables I'm having problems with follows - only financial_year_id gets its FK:
This message was edited 1 time. Last update was at 2016-09-07 04:36:50