dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #51688
Re: DHIS2 tables of unknown origin/purpose
Hi Calle
I'm not going to start digging down in the HBM history we have... but if
you see tables not relevant anymore, you can just delete them.. most of
this is not relevant anymore I'm sure
--
Morten Olav Hansen
Senior Engineer, DHIS 2
Team Integration Lead
University of Oslo
http://www.dhis2.org
On Sat, Aug 25, 2018 at 8:32 PM Calle Hedberg <calle.hedberg@xxxxxxxxx>
wrote:
> 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
>
> *******************************************
>
> _______________________________________________
> 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