# Database model and diagram

This diagram could be a bit difficult to understand at first and follow all the relations. To be able to use an interactive version of the same diagram, please use the [MySQL Workbench](http://www.mysql.com/products/workbench/) and follow these steps.

* Download [MySQL Workbench](http://www.mysql.com/products/workbench/) (it's free and cross-platform!)
* Install it and open it
* Select **Create EER Model From SQL Script**
* Look for your file 'struct.sql (your\_osclass\_folder/oc-includes/osclass/installer/struct.sql)
* **Check** Place imported object on a diagram
* Click on **Execute**, **Next**, **Finish**
* Re-arrange the boxes (tables) as you wish

Relations will highlight if you place your mouse over the tables or the relations.

![](https://3609657691-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Ls1-ouXz_w9tatpI-oE%2F-LsgFUyKCDEzqbZqyIqW%2F-LsgGO0D93a0HCel5EV_%2FDatabase_diagram.png?alt=media\&token=4b66aa36-a8b1-4845-ac8b-2349be84f183)