dhis2-devs team mailing list archive

[Ant Snyman <ant@xxxxxxxx>]

Dear Dev,

We have noticed on numerous DHIS2 databases that there sometimes are
multiple Foreign Key constraints on the same table for the same column. On
Sierra Leone some examples:


categories_categoryoptions FOREIGN KEY
fk_categories_categoryoptions_categoryid categoryid
categories_categoryoptions FOREIGN KEY fkf453b3bdd24076b3 categoryid
categorycombos_categories FOREIGN KEY fk731150b827f29ff categorycomboid
categorycombos_categories FOREIGN KEY
fk_categorycombos_categories_categorycomboid categorycomboid
indicatorgroupmembers FOREIGN KEY fkf01275498be51834 indicatorgroupid
indicatorgroupmembers FOREIGN KEY fk_indicatorgroupmembers_indicatorgroupid
indicatorgroupid

organisationunitattributevalues FOREIGN KEY fk601dda02b8e4fd1
attributevalueid
organisationunitattributevalues FOREIGN KEY fkcoo6svgtx8pre5fabnjuyhgpf
attributevalueid
organisationunitattributevalues FOREIGN KEY fk601dda0fb4caaad
organisationunitid
organisationunitattributevalues FOREIGN KEY fk7utgogpv8n5r4yxm41lhd70i0
organisationunitid
orgunitgroupmembers FOREIGN KEY fk55fa7022b8b57b9d orgunitgroupid
orgunitgroupmembers FOREIGN KEY fk_orgunitgroupmembers_orgunitgroupid
orgunitgroupid
programstageinstancecomments FOREIGN KEY fk5323f083fc199ca1
trackedentitycommentid
programstageinstancecomments FOREIGN KEY fkki1hrag24gcjuq78oafhuk1wh
trackedentitycommentid
programstageinstancecomments FOREIGN KEY
fk_programstageinstancecomments_trackedentitycommentid
trackedentitycommentid
reporttable_organisationunits FOREIGN KEY fk4b7becf027251155 reporttableid
reporttable_organisationunits FOREIGN KEY fk4b7becf03aab0439 reporttableid
reporttable_organisationunits FOREIGN KEY fk4b7becf0cc2046c1 reporttableid
Are these "duplicates" a matter of concern and should this be maintained
regularly by removing them? Do these "duplicates" add to the database
overheads/performance degradation?

Best Regards

*Ant Snyman*

*Cell: 0824910449*

*Landline: 028 2713242*


Health Information Systems Program - SA

-- 


*This message and any attachments are subject to a disclaimer published

at http://www.hisp.org/policies.html#comms_disclaimer 
<http://www.hisp.org/policies.html#comms_disclaimer>. 
Please read the 
disclaimer before opening any attachment or taking any other
action in 
terms of this electronic transmission.  If you cannot access the

disclaimer, kindly send an email to disclaimer@xxxxxxxx 
<mailto:disclaimer@xxxxxxxx> and a copy will be provided to you. By

replying to this e-mail or opening any attachment you agree to be bound by 
the
provisions of the disclaimer.*