Database schema analysis

[loicknuchel]

Azimutt is not only a diagram tool but it aims at helping to understand and manage better database schema. That's why we introduced the "Schema analysis" tool with several analysis:

• identify potentially missing relations (foreign key to add or at least relations to declare in Azimutt)
  • columns ending with _id or _ids without relations and not primary key
• check for columns types to spot inconsistencies
• warn about tables with too many columns

We are seeking to expand this tool to make it as useful as possible.
So if you see any improvement, in existing rules or new ones, please comment here so we could implement them.