Hi Riddy, The resource tables are not part of the schema or data model as such, but generated by the system (from data administration) to make it easier for db people to make select queries for reports etc. One example is the hierarchical listing of orgunits in the _orgunitstructure table. This table is updated by the nightly scheduling job, if that is enabled, or manually from Data Administration. So that table might be out of sync with the orgunit table, if you do not make sure it is re-generated.
The levels/hierarchy of orgunits are managed through the parent reference in the organisationunit table. The orgunitlevel table is just to store labels for each level, e.g. used in the level selector in GIS. Ola ------ On 14 Nov 2013 14:54, "riddy ndoma" <[email protected]> wrote: > It is managed from the resource table _orgunitstructure. Since according > to the diagram you gave me the orgunitlevel table is connected only with > the Map table > > > 2013/11/14 Knut Staring <[email protected]> > >> One place to start is the *generated* table (resource table) called >> _orgunitstructure >> >> Knut >> >> >> On Thu, Nov 14, 2013 at 2:43 PM, riddy ndoma <[email protected]>wrote: >> >>> Hello, >>> I am trying to explore the structure of the database administrator >>> entant that perfect mastery of queries that the GUI does not allow dhis2, I >>> wanted to know the table that connects organisationunit table and >>> organitlevel table? >>> >>> -- >>> Riddy NDOMA >>> Software Developer >>> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma >>> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma >>> *Blog:* http://riddyndoma.blogspot.com/ >>> >>> Vous servir est mon désire (Serving you is my desire) >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : [email protected] >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Knut Staring >> Dept. of Informatics, University of Oslo >> +4791880522 >> http://dhis2.org >> > > > > -- > Riddy NDOMA > Software Developer > *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma > *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma > *Blog:* http://riddyndoma.blogspot.com/ > > Vous servir est mon désire (Serving you is my desire) > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
