Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

modernize code tables #42

Open
dustymc opened this issue Aug 19, 2024 · 3 comments
Open

modernize code tables #42

dustymc opened this issue Aug 19, 2024 · 3 comments
Labels
CodeTableCleanup Our bad data leads to more bad data. Fix it! Enhancement I think this would make Arctos even awesomer!

Comments

@dustymc
Copy link
Contributor

dustymc commented Aug 19, 2024

Is your feature request related to a problem? Please describe.

Some code tables are more functional than others; make them all awesome

Describe what you're trying to accomplish

Better control and structure

Describe the solution you'd like

Various; I will edit this comment for individual table.

Describe alternatives you've considered

Slowly improve (and probably deal with broken links and such)

Additional context

nope

Priority

high?
@dustymc dustymc added Enhancement I think this would make Arctos even awesomer! CodeTableCleanup Our bad data leads to more bad data. Fix it! labels Aug 19, 2024
@dustymc
Copy link
Contributor Author

dustymc commented Aug 19, 2024 •
edited
Loading

This comment is for to-dos:

priority

these are annoying me

ctspec_part_att_att

column_name datatype precision todo
attribute_type character varying 30 ---
value_code_table character varying 38 ---
unit_code_table character varying 38 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctspecpart_attribute_type

column_name datatype precision todo
attribute_type character varying 30 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

eventually....

ctaccn_status

column_name datatype precision todo
accn_status character varying 30 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctaccn_type

column_name datatype precision todo
accn_type character varying 35 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctagent_rank

column_name datatype precision todo
agent_rank character varying 50 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctagent_type

column_name datatype precision todo
agent_type character varying 30 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctauthor_role

column_name datatype precision todo
author_role character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctbiochronology

column_name datatype precision todo
biochronology character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctbiostratigraphic_zone

column_name datatype precision todo
biostratigraphic_zone character varying 255 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctborrow_status

column_name datatype precision todo
borrow_status character varying 20 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcaste

column_name datatype precision todo
caste character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcatalog_number_format

column_name datatype precision todo
catalog_number_format character varying 21 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcataloged_item_type

column_name datatype precision todo
cataloged_item_type character varying 20 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcitation_type_status

column_name datatype precision todo
type_status character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcoll_contact_role

column_name datatype precision todo
contact_role character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcoll_event_att_att

column_name datatype precision todo
event_attribute_type character varying 30 ---
value_code_table character varying 38 ---
unit_code_table character varying 38 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcoll_event_attr_type

column_name datatype precision todo
event_attribute_type character varying 255 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcoll_other_id_type

column_name datatype precision todo
other_id_type character varying 59 ---
description character varying 4000 ---
base_url character varying 4000 ---
sort_order integer ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcollecting_source

column_name datatype precision todo
collecting_source character varying 30 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcollection_attribute_type

column_name datatype precision todo
attribute_type character varying 255 ---
description character varying 4000 ---
issue_url ARRAY ---
documentation_url ARRAY ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcollection_cde

column_name datatype precision todo
collection_cde character varying 5 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcollection_terms

column_name datatype precision todo
collection_terms_id integer ---
display character varying 30 ---
description character varying 255 ---
uri character varying 255 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcollector_role

column_name datatype precision todo
collector_role character varying 30 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctconcentration

column_name datatype precision todo
concentration character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctconductivity_units

column_name datatype precision todo
conductivity_units character varying 40 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcontainer_env_parameter

column_name datatype precision todo
parameter_type character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcontainer_type

column_name datatype precision todo
container_type character varying 30 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcopyright_status

column_name datatype precision todo
copyright_status character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcount_units

column_name datatype precision todo
count_units character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctcrystal_habit

column_name datatype precision todo
crystal_habit character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctculture

column_name datatype precision todo
culture character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctdata_license

column_name datatype precision todo
data_license_id integer ---
display character varying 30 ---
description character varying 255 ---
uri character varying 255 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctdatum

column_name datatype precision todo
datum character varying 55 ---
description character varying 4000 ---
srid integer ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctdisposition

column_name datatype precision todo
disposition character varying 20 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctdownload_purpose

column_name datatype precision todo
download_purpose character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctdrainage

column_name datatype precision todo
drainage character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctencumbrance_action

column_name datatype precision todo
encumbrance_action character varying 30 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctew

column_name datatype precision todo
e_or_w character 1 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctexamined_detected

column_name datatype precision todo
examined_detected character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctfeature

column_name datatype precision todo
feature character varying 50 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctgeoreference_protocol

column_name datatype precision todo
georeference_protocol character varying 255 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctid_references

column_name datatype precision todo
id_references character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctidentification_attribute_code_tables

column_name datatype precision todo
attribute_type character varying ---
value_code_table character varying 60 ---
units_code_table character varying 60 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctidentification_attribute_type

column_name datatype precision todo
attribute_type character varying 30 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctidentification_confidence

column_name datatype precision todo
identification_confidence character varying 30 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctinfraspecific_rank

column_name datatype precision todo
infraspecific_rank character varying 20 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctisland_group

column_name datatype precision todo
island_group character varying 50 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctlandholder

column_name datatype precision todo
landholder character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctlat_long_units

column_name datatype precision todo
orig_lat_long_units character varying 20 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctlength_units

column_name datatype precision todo
length_units character varying 20 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctlithodemic_suite

column_name datatype precision todo
lithodemic_suite character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctlithostratigraphic_bed

column_name datatype precision todo
lithostratigraphic_bed character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctlithostratigraphic_formation

column_name datatype precision todo
lithostratigraphic_formation character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctlithostratigraphic_group

column_name datatype precision todo
lithostratigraphic_group character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctlithostratigraphic_informal

column_name datatype precision todo
lithostratigraphic_informal character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctlithostratigraphic_member

column_name datatype precision todo
lithostratigraphic_member character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctloan_status

column_name datatype precision todo
loan_status character varying 20 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctloan_type

column_name datatype precision todo
loan_type character varying 25 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctlocality_access

column_name datatype precision todo
locality_access character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctlocation_in_host

column_name datatype precision todo
location_in_host character varying 255 ---
description character varying 255 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctluster

column_name datatype precision todo
luster character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctmedia_label

column_name datatype precision todo
media_label character varying 255 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctmedia_license

column_name datatype precision todo
media_license_id integer ---
display character varying 30 ---
description character varying 255 ---
uri character varying 255 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctmedia_relationship

column_name datatype precision todo
media_relationship character varying 40 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctmedia_type

column_name datatype precision todo
media_type character varying 40 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctmime_type

column_name datatype precision todo
mime_type character varying 40 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctmonetary_units

column_name datatype precision todo
monetary_units character varying 30 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctmortality_cause

column_name datatype precision todo
mortality_cause character varying 60 ---
description character varying ---
search_terms character varying ---
issue_url ARRAY ---
documentation_url ARRAY ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctnagpra_category

column_name datatype precision todo
nagpra_category character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctnature_of_id

column_name datatype precision todo
nature_of_id character varying 35 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctnomenclatural_code

column_name datatype precision todo
nomenclatural_code character varying 20 ---
description character varying 255 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctns

column_name datatype precision todo
n_or_s character 1 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctnumeric_age_units

column_name datatype precision todo
numeric_age_units character varying 6 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctordinal

column_name datatype precision todo
ordinal character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctpart_modifier

column_name datatype precision todo
part_modifier character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctpart_preservation

column_name datatype precision todo
part_preservation character varying 255 ---
description character varying 4000 ---
tissue_fg integer ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctpart_preservation_need

column_name datatype precision todo
preservation_need character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctpermit_agent_role

column_name datatype precision todo
permit_agent_role character varying 255 ---
description character varying 255 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctpermit_regulation

column_name datatype precision todo
permit_regulation character varying 255 ---
description character varying 255 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctpermit_type

column_name datatype precision todo
permit_type character varying 50 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctprefix

column_name datatype precision todo
prefix character varying 20 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctpreparation_method

column_name datatype precision todo
preparation_method character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctprocessing_history

column_name datatype precision todo
processing_history character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctproject_agent_role

column_name datatype precision todo
project_agent_role character varying 25 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctpublication_type

column_name datatype precision todo
publication_type character varying 21 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctquad

column_name datatype precision todo
quad character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctshipment_type

column_name datatype precision todo
shipment_type character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctshipped_carrier_method

column_name datatype precision todo
shipped_carrier_method character varying 30 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctspecimen_event_type

column_name datatype precision todo
specimen_event_type character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctsubject_term

column_name datatype precision todo
subject_term character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctsuffix

column_name datatype precision todo
suffix character varying 20 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttaxa_formula

column_name datatype precision todo
taxa_formula character varying 25 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttaxon_concept_relationship

column_name datatype precision todo
relationship character varying 30 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttaxon_name_type

column_name datatype precision todo
taxon_name_type character varying 30 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttaxon_relation

column_name datatype precision todo
taxon_relationship character varying 40 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttaxon_status

column_name datatype precision todo
taxon_status character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttaxon_term

column_name datatype precision todo
taxon_term character varying 255 ---
description character varying 4000 ---
is_classification integer ---
relative_position integer ---
cttaxon_term_id integer ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttaxon_variable

column_name datatype precision todo
taxon_variable character 1 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttaxonomy_source

column_name datatype precision todo
source character varying 255 ---
description character varying 4000 ---
edit_tools character varying ---
edit_users character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttemperature_units

column_name datatype precision todo
temperature_units character varying 40 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttrans_agent_role

column_name datatype precision todo
trans_agent_role character varying 60 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttransaction_type

column_name datatype precision todo
transaction_type character varying 18 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttrs_range

column_name datatype precision todo
trs_range character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttrs_section

column_name datatype precision todo
trs_section character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

cttrs_township

column_name datatype precision todo
trs_township character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctutm_zone

column_name datatype precision todo
utm_zone character varying 20 ---
description character varying 4000 ---
srid integer ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctverificationstatus

column_name datatype precision todo
verificationstatus character varying 40 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctvolume_units

column_name datatype precision todo
volume_units character varying 60 ---
description character varying ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctwater_body

column_name datatype precision todo
water_body character varying 255 ---
water_body_type character varying ---
description character varying 4000 ---
search_terms character varying ---
issue_url ARRAY ---
documentation_url ARRAY ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctweight_units

column_name datatype precision todo
weight_units character varying 15 ---
description character varying 4000 ---
documentation_url varchar[] - add
issue_url varchar[] - add

ctyes_no

column_name datatype precision todo
yes_or_no character varying 3 ---
documentation_url varchar[] - add
issue_url varchar[] - add

@dustymc

This comment was marked as resolved.

Sign in to view
@dustymc

This comment was marked as resolved.

Sign in to view
@dustymc dustymc mentioned this issue Aug 19, 2024
Closed
@dustymc dustymc mentioned this issue Aug 30, 2024
Open
@dustymc dustymc transferred this issue from ArctosDB/arctos Sep 5, 2024
@dustymc dustymc mentioned this issue Nov 12, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
CodeTableCleanup Our bad data leads to more bad data. Fix it! Enhancement I think this would make Arctos even awesomer!
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@dustymc