← Back to team overview

dhis2-devs team mailing list archive

Re: schema - anyone?

 

I have just added a section to the user documentation which produces
an HTML WebHelp for the database schema.

The basic procecdure for this was to create the DocBook XML using
http://www.rbt.ca/autodoc/
. This tool will also create HTML, DIA and some other formats, but
given the size of the database, the dia diagram is rather large to say
the least.

If you want to build the WebHelp, just execute the pom from the
documentation source.

mvn package -f db-pom.xml

Once this is done, you will have the HTML  in  the
"dhis2-docbook-docs\target\docbkx\webhelp\dhis2_database_schema"
directory.

If you are interested in the dia format, let me know and I will send
it to you by email. It is rather a mess of spaghetti.

Regards,
Jason





On Mon, Dec 12, 2011 at 10:29 PM, Ime Asangansi <asangansi@xxxxxxxxx> wrote:
>
> Oh, okay.
> There used to be one on our wiki those days.
> Thanks.
>
> Ime
>
>
> --- On Mon, 12/12/11, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>
> From: Knut Staring <knutst@xxxxxxxxx>
> Subject: Re: [Dhis2-devs] schema - anyone?
> To: "Ime Asangansi" <asangansi@xxxxxxxxx>
> Cc: "Dhis2" <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> Date: Monday, December 12, 2011, 4:17 PM
>
>
> Hi Ime,
>
> Not that I'm aware of, but perhaps you could have a go at SchemaSpy or one of the other tools linked to below?
> http://stackoverflow.com/questions/3223770/tools-to-generate-database-tables-diagram-with-postgresql
>
> Please let us know if you get it to work well.
>
> Knut
>
> On Mon, Dec 12, 2011 at 2:56 PM, Ime Asangansi <asangansi@xxxxxxxxx> wrote:
>
> Hi,
>
> Good day everyone.
>
> Please does anyone have a schema diagram of our latest version of the dhis db?
>
> Would be very appreciated.
>
> thanks
>
> Ime
>
> _______________________________________________
> 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
>
>
>
>
> --
> Knut Staring
> Informatics, U. of Oslo
> http://hisp.uio.no
> +4791880522
>
>
> _______________________________________________
> 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
>


Follow ups

References