getting the big picture
Some of us do not really care how OpenClinica is doing what it is doing, but others may be fascinated by the database: 100+ tables and some views and relations. Getting the big picture can be difficult and fortunately there are OpenSource-tools that can help us.
In the frame under this text you can see a summary of the database: just click ahead.
It was generated by SchemaSpy, in combination with schemaSpyGUI
Click on a table to see with which other tables it is connected. The associated graphics can be quite large, so you may want to open the links in a new browser window.