Simplify db schema

13544
Reporter: mdoering
Assignee: mdoering
Type: Improvement
Summary: Simplify db schema
Priority: Major
Resolution: Fixed
Status: Closed
Created: 2013-08-02 06:59:11.046
Updated: 2013-12-09 14:01:18.617
Resolved: 2013-10-11 12:15:35.807
        
Description: Once the main ECAT legacy code is being deprecated (especially ecat-checklistbank, ecat-portal) the db schema for checklist bank can be significantly simplified in some areas:

 - remove {{checklist}} table. Not needed anymore if registry datasets and tagging is used. Use the dataset UUID key instead of name_usage.checklist_fk

 - remove {{term}} and {{term_type}} tables and use enum persistence values directly on the various tables (e.g. for rank_fk) or in the few cases where we dont have enums, use verbatim strings (distribution area?)

- remove {{hits}} table. Used in ecat portal only

- remove {{agent}} table. Used in ecat portal only

- remove {{news}} table. Used in ecat portal only

- remove {{clb_stats}} table. Used in ecat portal only

- remove {{bibref}} table which was never used and remove the corresponding citation foreign key

- merge {{parsed_name}} and {{name_string}} into single {{name}} table. Add missing ParsedName fields and update field names to match the class. Remove canonical_name_fk and persist the canonical_name directly instead to avoid the numerous extra joins we see in mybatis queries to get the higher rank values

- remove {{term_gbif_portal_rank}} once we stop doing classic rollovers

- remove {{templ_XYZ}} tables]]>
    

Author: mdoering@gbif.org
Comment: done in latest clb since a few months
Created: 2013-10-11 12:15:35.839
Updated: 2013-10-11 12:15:35.839