Database Structure and Sample Data

[hyalina]

An SQL dump (.sql) must be made.

[kimerran]

can you be more specific? if you mean schema then have a look at this

[hyalina]

An SQL dump (.sql) or an ERD for the system, not list of API calls. And what you've shown are JSON data.

[hyalina]

Crow foot notation would be nice.