recheck CTs for structure

[dustymc]

Source

ArctosDB/arctos#9673

Summary

Missed at least one table, check others for proper refs and issue slots

[dustymc]

blocked by #551

[dustymc]

SELECT table_name from information_schema.columns where table_name like 'ct%' and column_name='description' and table_name not in (
                select table_name from  information_schema.columns where table_name like 'ct%' and column_name='issue_url'
        );

probably just do

ctagent_type
ctcontainer_env_parameter
ctconductivity_units
ctcoll_contact_role
ctproject_agent_role
cttaxon_concept_relationship
cttaxon_variable
cttransaction_type
ctlength_units
ctcitation_type_status
ctterms
cttaxonomy_source
cttemperature_units
ctconcentration
ctordinal
ctlicense
cttaxa_formula
ctcollecting_source
ctcollector_role
ctnumeric_age_units
ctpart_preservation_need

help...

ctagent_rank

ArctosDB/arctos#9450

---

ctcatalog_number_format

I don't think this will ever change so don't see much value in documentation

---

ctchronostrat_informal
ctchronostrat_substage_subage
ctchronostrat_era_erathem

ctchronostrat_eon_eonothem
ctchronostrat_series_epoch
ctchronostrat_system_period

ctlithodemic_suite ????

ArctosDB/arctos#7404

---

ctcollection_cde

this is entirely arbitrary, don't think that needs documentation??

---

ctdownload_purpose

internal - useful??

---

ctdatum
ctutm_zone
SRID is sufficient documentation, and anything with a functional SRID can be added - no need for more?

---

ctew
ctns

inventing a new direction seems unlikely....

---

ctlat_long_units

??

---

ctinfraspecific_rank
ctprefix
ctnomenclatural_code
ctsuffix
cttaxon_term

internal/arbitrary, strip documentation column, drop and hard-code into UIs, ???

---

ctlocality_access

no need for documentation?

---

cttaxon_relation

ArctosDB/arctos#9545

---

cttaxon_name_type

kinda internalish??

---

cttaxon_status
ArctosDB/arctos#9545

---

cttrs_section

what the hell is this???

---

ctencumbrance_action

open issue to drop

---

ctcoll_other_id_type

has this stopped changing??

---