← Back to team overview

dhis2-devs team mailing list archive

Re: DHIS2 tables of unknown origin/purpose

 

Hi,

Further to the list above, here are six additional tables we have in one
instance that do not exist in the standard current 2.28 data model:

*Query12*
table_name
importdatavalue
importobject
instanceconfig
metadatafilter
trackedentityattributegroup
translation

On Fri, 24 Aug 2018 at 13:48, Calle Hedberg <calle.hedberg@xxxxxxxxx> wrote:

> Devs,
>
> While investigating the many duplicates and gaps found in many existing
> 2.28 instances - most of them created in version 2.18 - 2.22 and then
> upgraded over time - we also found a number of tables (and at least one
> field) that no longer exist in a "clean" 2.28 instance.
>
> The single "missing" field is the field trackedentityattributeid in table datadimensionitem.
> Is that field outdated?
>
> The tables are below - can somebody please indicate if these are outdated
> tables no longer in use? (Jason P - note a number of them relate to
> translations. You might know if they are redundant?)
>
> Regards
> Calle
>
> table_name
>
> dependencysynchstatus
> desynchstatus
> desynchstatus
> indicatorsynchstatus
> indicatorsynchstatus
> instance_businessrules
> maplayertranslations
> maplayertranslations
> metadatafiltertranslations
> metadatafiltertranslations
> metadatasynchlog
> organisationunitsynchstatus
> organisationunitsynchstatus
> predictororglevels
> programinstance_outboundsms
> programinstance_outboundsms
> programstageinstance_outboundsms
> programstageinstance_outboundsms
> programvalidation
> programvalidation
> programvalidation
> programvalidationtranslations
> programvalidationtranslations
> trackedentityattributegrouptranslations
> trackedentityattributegrouptranslations
> trackedentityaudit
> trackedentityinstancereminder
> trackedentityinstancereminder
> trackedentityinstancereminder
> trackedentityinstanceremindertranslations
> trackedentityinstanceremindertranslations
> validationrulegroupusergroupstoalert
> validationrulegroupusergroupstoalert
> validationrulesynchstatus
> validationrulesynchstatus
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>

-- 

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************

Follow ups

References