This particular post is to assist in getting a Moodle DB schema specific to your database. It is especially handy if there are non-standard plugins installed on Moodle.
As mentioned in an earlier post, getting a relevant ERD on Moodle.org is almost herculian. This tool will reverse engineer the databse ERD.
The application is Fabforce4 located at http://www.fabforce.net/dbdesigner4/
Installation on Windows is straightforward, simply download, install and configure to point to your database.
Installation on CentOS linux was not as good. The application refused to launch. I decided to run it on Wine (which I had to install here).
I’ll update with a sample schema of my test database as soon as the operation completes.