Data storage in DHIS2

Hi everyone,

I’d like to know which table in DHIS2 contains data. To be more specifc, where can I found all the data captured by users in data set, event and tracker program.

Thanks in advance.

Hello @Lanja

here is an attempt to answer :

DataSet = datavalue , datavalueaudit

Tracker = trackedentityinstance, trackedentityattributevalue , trackedentityattributevalueaudit , programinstance, programstageinstance

Event = programstageinstance

I remind you that I only listed the main tables

Regards

1 Like

Thanks! @didate! (:
Another user once asked for the DB schema which I think you might find interesting: Database Scheme of DHIS2 Tracker - #5 by jaime.bosque

Additionally, another approach would be to check out the api resources. For example in DHIS 2 Demo - Sierra Leone (after logging in): https://play.dhis2.org/2.37.0/api/resources

1 Like