Hi, I've always didn't understood the complete (db)schema structure of OpenMRS. Schema Spy <http://schemaspy.sourceforge.net/> helped me in understand the db schema better. It also gave a list of anomalies in the database which we might need to consider. Starting up with Schema Spy is very easy. Just download the jar, point it to your database and thats it.
I'm unable to attach the report generated as it is more than 25Mb (close to 30MB). *Command I used: * *java -jar schemaSpy_5.0.0.jar -t mysql -host localhost -dp ~/Desktop/mysql-connector-java-5.1.7-bin.jar -db openmrs -u root -p password -o ~/Desktop* -- Regards, Kishore Kumar Yekkanti. _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]

