Database Schema

OpenEMR Development
1

wjbaptis wrote on Tuesday, July 02, 2013:

Hi everyone,

Is there a place I can find an overview of the database tables and fields and how they are related? Thanks.

2

tmccormi wrote on Tuesday, July 02, 2013:

This is as close as we have: from version 4.0 (or just before that)

Lots and Lots has changed since then, though

–Tony

3

tmccormi wrote on Tuesday, July 02, 2013:

Oh, and before you ask. The foreign key references in this PDF were hand created for the purpose of creating the documentation but never implemented into the actual database schema…

Any volunteers?

–Tony

4

robyn03 wrote on Wednesday, July 03, 2013:

Attached the table schema for version 4.1.1 (13).
It is not the same as the one posted in the wiki, but if this may be fine, someone could post in the wiki. I hope I have been of help.

5

deschel wrote on Wednesday, July 03, 2013:

Robyn03,

No offense, but your attachment is not a database schema, and what you did does not really add much.

Anyone can go into the embedded PHPMyAdmin in OpenEMR to look at the tables and structures. With a few clicks, they can also generate a structure file or SQL file with the structure. Since it is so easy to generate, there is no point in posting your file. However, for newbies, I suggest that you post in the wiki directions about how to look at the structure using OpenEMR.

Now, if you look at Tony McCormack’s link, it is a graphical representation showing the relationships between the tables. It looks like it was created with MySQL Workbench, which is a free download. Now, this is useful. Too bad that no one has taken the time and research to generate this for later versions.

Robyn03, if you really want to create something useful, download MySQLWorkbench, use it to create a graphical representation of the tables, research the relationships between tables, add those to the graphical representation in MySQLWorkbench, create a pdf of it, and contribute that.

My estimate is that this would take 20-60 hours of time with multiple posts to this forum to clarify table relationships, or perhaps, private communication with Brady to clarify areas of uncertainty.

Up to the job?

David

6

robyn03 wrote on Wednesday, July 03, 2013:

Hi David,

Absolutely I’m not offend me. However, that is posted is the database schema, non relational and non graphical definitely like the one posted by Tony McCormack’s.
My post was not to be interpreted as if I was a “genius”, I just thought this was enough, that’s all. However, no, I’m sorry but I’m not able to perform a “procedure so complex” as shown.Sorry for that…

7

yehster wrote on Wednesday, July 03, 2013:

Instead of trying to deal with the massive problem of describing the whole schema. A wiki page that would allow us to describe one table at a time would probably be easier to develop and maintain.
In the meantime, some key tables are
patient_data - obvious purpose
forms and all the form_ tables - (a lot of clinical data goes here)
lists - stores medications/problems
lbf_data - Layout Based Forms data.

8

tmccormi wrote on Thursday, July 04, 2013:

Ensoftek told me that they had annotated the entire db with comments. I’ll
poke them and see if I can get that as a starting point
Tony
On Jul 3, 2013 8:07 AM, “Kevin Yeh” yehster@users.sf.net wrote:

Instead of trying to deal with the massive problem of describing the whole
schema. A wiki page that would allow us to describe one table at a time
would probably be easier to develop and maintain.
In the meantime, some key tables are
patient_data - obvious purpose
forms and all the form_ tables - (a lot of clinical data goes here)
lists - stores medications/problems
lbf_data - Layout Based Forms data.

Database Schemahttps://sourceforge.net/p/openemr/discussion/202506/thread/d7ae8282/?limit=25#b456

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

9

bradymiller wrote on Friday, July 05, 2013:

Hi,

Already exists here(haven’t updated some of the more recent tables, though; please feel free to do this):
http://www.open-emr.org/wiki/index.php/OpenEMR_System_Architecture#Database

-brady
OpenEMR

10

wjbaptis wrote on Monday, July 08, 2013:

Thanks everyone. Really appreciate it.