We would like to connect the database to a data visualization software in order to analyze answers from the forms (including custom ones).
The issue is that the relations between the tables in the database aren't easy to understand as there aren't any constraints and foreign keys defined.
Some columns with ID in their name are confusing as to whether they have a table for themselves or not.
Is it possible to share an ERD diagram or can you point us to the direction where we can find the model files (as in how the db is generated)?
Any help would be appreciated.
Here's the information tab for reference: