search

zimmerman-team / IATI.cloud

IATI datastore powered by Apache Solr. Automatically Extracts and parses IATI XML files referenced in the IATI Registry & refreshed every 3 hrs. IATI is a global initiative to improve the transparency of development and humanitarian resources and their results for addressing poverty and crises.
https://datastore.iati.cloud
MIT License
32 stars 28 forks source link

PostgreSQL clean up #2146

Closed siemvaessen closed 4 years ago

siemvaessen commented 4 years ago

Lets review PostgreSQL for a nice cleanup, check conventions, remove dead tables. Etc.etc.

HeleneBourgoin commented 4 years ago

List of empty table (check made using Metabase) : traceability_chainnodeerror traceability_chainnode traceability_chainlinkrelation traceability_chainlink traceability_chain socialaccount_socialtoken socialaccount_socialapp_sites socialaccount_socialapp socialaccount_socialaccount permissions_organisationuser_organisation_groups permissions_organisationuser_organisation_admin_groups permissions_organisationuser permissions_organisationgroup permissions_organisationadmingroup iati_documentsearch iati_document iati_codelists_valuetype iati_codelists_cashandvouchermodalities iati_codelists_aidtypeflag iati_activitywebsite iati_activitysearchdata geodata_adm1region django_celery_beat_solarschedule django_celery_beat_clockedschedule currency_convert_monthlyaverage auth_user_user_permissions auth_user_groups account_emailconfirmation account_emailaddress

List of empty tables from my machine that do not appear on metabase : authtoken_token auth_group_permissions auth_group