There are a few resources that cover the various fields returned by the API endpoints, but they don't discuss the relationships between them from what I can tell. It would be helpful if an Entity Relationship Diagram or a list of primary and foreign keys could be provided as well. As we are trying to incorporate the data we are pulling through the API into our data warehouse, it would be helpful to have documentation on how the data are related to each other.

For example, if we look at the users and class reports tables. I would think these would be related to each other via the student_id field. However, the student_id in the users table is a text field and the student_id in the class reports table is a numeric field. They do not match. After digging into this, we suspect the student_id field in the class reports table is actually related to the id field from the users table. 

If there is some documentation of the relationships between tables, it would be very helpful for us.