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 disclai...@hisp.org <mailto:disclai...@hisp.org> 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.*
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp