harmonize table and field names in db

[bbest]

• ctd_casts.cast_count = ctd_bottles.cst_cnt
  recommendation: *.cast_seq
  'seq' is short for "sequence" whereas the word "count" suggests how many of something occurred (ie how many casts occurred), whereas the values in this field represent the unique id per cast based on a sequential integer number
• ctd_bottles.depthm -> depth_m
  consistently show units as suffix seperated by '_'

[bbest]

Standardize naming practices:

• *_key for text identifiers
• *_id for integer identifiers
• *_seq for integer identifiers that are generated from automatic sequence

[bbest]

explore_db

From explore_db.html (source: explore_db.qmd)

See sections:

• 1.1 species_codes
• 1.2 species_codes_new
• 1.3 species_codes vs species_codes_new

Questions

• Why is.na(taxon_rank) (n=34) in species_codes_new but not species_codes?
• What is taxon_rank == 'None'?

Rename suggestions

• Drop species_codes_new since missing taxon_rank for 34 rows that are populated in species_codes
• Rename species_codes to species
• Drop field id , since confusing with spccode
• Rename field spccode to sp_id since