Yeah, this is a particularly tricky part of the model to work with directly through the database. It is very easy to mess things up here. Using the WebAPI would be a much better option if at all possible.
At any rate, that part of the documentation should be fairly up to date, but unwinding everything in SQL can be a task, depending on what you need to do. Regards, Jason On Tue, Dec 30, 2014 at 12:34 PM, Simon Muyambo <smmuya...@gmail.com> wrote: > Thanks Jason. > > > > I want to understand the categories/category options so that I can do low > level adjustments for changes in the options > > > > *Regards* > > *Simon Muyambo* > > > > > > *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com] > *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 <smmuya...@gmail.com> > 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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > > > > > -- > > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 <+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 > > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 10943 (20141230) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp