← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] DHIS2 database tables

 

Of particular interest is the relationships between dataelementcategory, dataelementcategoryoption, categorycombo, categoryoptioncombo, categories_categoryoptions, categorycombos_categories and categoryoptioncombos_categoryoptions.

 

Regards

Simon Muyambo

 

 

From: Jason Pickering [mailto:jason.p.pickering@xxxxxxxxx] 
Sent: 30 December 2014 13:11
To: Simon Muyambo
Cc: dhis2-devs; DHIS 2 Users list
Subject: Re: [Dhis2-devs] [Dhis2-users] DHIS2 database tables

 

Hi Simon,

There is not much really in terms of documenting what each and every table does, but you can build the db schema (a bit out of data) from the documentation branch. 

 

Simply execute 

 

mvn -f db-pom.xml clean package

 

This will produce an HTML file which links all of the tables and relationships together. Note, that not all foreign keys which are in place in the logic of DHIS2 are present in the database. 

 

If you can give more specifics about what you need, then we might be able to point you in the right direction. 

 

Regards,

Jason

 

 

 

 

On Tue, Dec 30, 2014 at 11:16 AM, Simon Muyambo <smmuyambo@xxxxxxxxx> wrote:

Where can I find the documentation on the DHIS2 database tables and relationships?

 

Regards

 

Simon Muyambo



__________ Information from ESET NOD32 Antivirus, version of virus signature database 10943 (20141230) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp





 

-- 

Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049

 

__________ Information from ESET NOD32 Antivirus, version of virus signature database 10943 (20141230) __________

 

The message was checked by ESET NOD32 Antivirus.

 

http://www.eset.com


References