dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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 <smmuyambo@xxxxxxxxx> 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.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 <+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.pickering@xxxxxxxxx
tel:+46764147049