Using DbSchema to look at the db

OpenEMR Development
1

fndtn357 wrote on Tuesday, July 21, 2015:

Used DbSchema to reverse-engineer and auto-generate foreign keys - simulate column dependencies. Posting here for anyone that might find it useful. See at following address - scroll around the image is very large.
http://htmlpreview.github.io/?https://github.com/fndtn357/openemr/blob/master/assets/openemrER.html

still needs some work - but it’s a start

2

bradymiller wrote on Saturday, July 25, 2015:

Hi James,

Very neat. Feel free to place this(or link to it) on the wiki:
http://www.open-emr.org/wiki/index.php/Database_Structure

-brady
OpenEMR

3

fndtn357 wrote on Saturday, July 25, 2015:

Thanks, I will wait and post a final diagram when I go over the first and
second auto-generated ones - I am uploading another reverse-engineered ER
diagram of the same db and there are differences. The best ER diagram will
be when I manually go over both of them and map it in the best possible
way. In the first diagram, the entire User table is not showing and much is
connected to it. But the first diagram also highlights the significance of
the address table in our database.
Second reverse-engineered diagram using Workbench
https://github.com/fndtn357/openemr/blob/master/assets/openemrER.png is
posted in my github repo.

James

On Sat, Jul 25, 2015 at 6:57 AM, Brady Miller bradymiller@users.sf.net
wrote:

Hi James,

Very neat. Feel free to place this on the wiki:
Database Structure - OpenEMR Project Wiki

-brady
OpenEMR http://www.open-emr.org

Using DbSchema to look at the db
https://sourceforge.net/p/openemr/discussion/202506/thread/c60b39b3/?limit=25#d7ee

Sent from sourceforge.net because you indicated interest in
OpenEMR / Discussion / Developers

To unsubscribe from further messages, please visit
SourceForge.net: Log In to SourceForge.net

4

fndtn357 wrote on Wednesday, August 05, 2015:

Hi Brady

I decided to add the generated db ER diagram to the Database_Structure
page. I don’t think I have a user account for the Open EMR wiki. Would you
be able to check or provide one for me?

Thanks, James

On Sat, Jul 25, 2015 at 6:57 AM, Brady Miller bradymiller@users.sf.net
wrote:

Hi James,

Very neat. Feel free to place this on the wiki:
Database Structure - OpenEMR Project Wiki

-brady
OpenEMR http://www.open-emr.org

Using DbSchema to look at the db
https://sourceforge.net/p/openemr/discussion/202506/thread/c60b39b3/?limit=25#d7ee

Sent from sourceforge.net because you indicated interest in
OpenEMR / Discussion / Developers

To unsubscribe from further messages, please visit
SourceForge.net: Log In to SourceForge.net

5

fndtn357 wrote on Wednesday, August 05, 2015:

Hi Brady

Nevermind. I do have an Open EMR account with my developer email address
fndtn357@gmail.com. I will be posting the diagram on the page. Thanks for
allowing me to share/contribute.

Regards
James

On Wed, Aug 5, 2015 at 8:23 AM, James R Stone fndtn357@users.sf.net wrote:

Hi Brady

I decided to add the generated db ER diagram to the Database_Structure
page. I don’t think I have a user account for the Open EMR wiki. Would you
be able to check or provide one for me?

Thanks, James

On Sat, Jul 25, 2015 at 6:57 AM, Brady Miller bradymiller@users.sf.net
wrote:

Hi James,

Very neat. Feel free to place this on the wiki:
Database Structure - OpenEMR Project Wiki

-brady
OpenEMR http://www.open-emr.org

Using DbSchema to look at the db

OpenEMR / Discussion / Developers: Using DbSchema to look at the db

Sent from sourceforge.net because you indicated interest in
OpenEMR / Discussion / Developers

To unsubscribe from further messages, please visit
SourceForge.net: Log In to SourceForge.net

Using DbSchema to look at the db
http://sourceforge.net/p/openemr/discussion/202506/thread/c60b39b3/?limit=50#d7ee/e29d

Sent from sourceforge.net because you indicated interest in
OpenEMR / Discussion / Developers

To unsubscribe from further messages, please visit
SourceForge.net: Log In to SourceForge.net