This file auto-generated 2025-06-17 14:33:39 -0500 via 'rake tw:docs:table_markdown'. Do not hand-edit.
alternate_values, asserted_distributions, attributions, biocuration_classifications, biological_associations, biological_associations_biological_associations_graphs, biological_associations_graphs, biological_relationship_types, biological_relationships, cached_map_item_translations, cached_map_items, cached_map_registers, cached_maps, character_states, citation_topics, citations, collecting_events, collection_object_observations, collection_objects, collection_profiles, common_names, confidences, container_items, containers, contents, controlled_vocabulary_terms, conveyances, data_attributes, dataset_record_fields, dataset_records, depictions, derived_collection_objects, descriptors, documentation, documents, downloads, extracts, field_occurrences, gazetteers, gene_attributes, geographic_area_types, geographic_areas, geographic_areas_geographic_items, geographic_items, georeferences, identifiers, images, import_datasets, labels, languages, leads, loan_items, loans, namespaces, notes, observation_matrices, observation_matrix_column_items, observation_matrix_columns, observation_matrix_row_items, observation_matrix_rows, observations, organizations, origin_relationships, otu_page_layout_sections, otu_page_layouts, otu_relationships, otus, people, preparation_types, project_members, project_sources, protocol_relationships, protocols, ranged_lot_categories, repositories, roles, sequence_relationships, sequences, serial_chronologies, serials, sled_images, sounds, sources, sqed_depictions, tagged_section_keywords, tags, taxon_determinations, taxon_name_classifications, taxon_name_relationships, taxon_names, type_materials
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| alternate_value_object_attribute | character varying |
| alternate_value_object_id | integer |
| alternate_value_object_type | character varying |
| language_id | integer |
| type | character varying |
| value | text |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| asserted_distribution_shape_id | integer |
| asserted_distribution_shape_type | character varying |
| geographic_area_id | integer |
| is_absent | boolean |
| otu_id | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | bigint |
| attribution_object_id | bigint |
| attribution_object_type | character varying |
| copyright_year | integer |
| license | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | bigint |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| biocuration_class_id | integer |
| biocuration_classification_object_id | bigint |
| biocuration_classification_object_type | character varying |
| biological_collection_object_id | bigint |
| position | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| biological_association_object_id | integer |
| biological_association_object_type | character varying |
| biological_association_subject_id | integer |
| biological_association_subject_type | character varying |
| biological_relationship_id | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| biological_association_id | integer |
| biological_associations_graph_id | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| layout | jsonb |
| name | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| biological_property_id | integer |
| biological_relationship_id | integer |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| definition | text |
| inverted_name | character varying |
| is_reflexive | boolean |
| is_transitive | boolean |
| name | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | bigint |
| cached_map_type | character varying |
| geographic_item_id | bigint |
| translated_geographic_item_id | bigint |
| created_at | timestamp(6) without time zone |
| updated_at | timestamp(6) without time zone |
top,er,rdoc
| Name | Type |
|---|
| id | bigint |
| geographic_item_id | bigint |
| is_absent | boolean |
| level0_geographic_name | character varying |
| level1_geographic_name | character varying |
| level2_geographic_name | character varying |
| otu_id | bigint |
| reference_count | integer |
| type | character varying |
| untranslated | boolean |
| created_at | timestamp(6) without time zone |
| updated_at | timestamp(6) without time zone |
| project_id | bigint |
top,er,rdoc
| Name | Type |
|---|
| id | bigint |
| cached_map_register_object_id | bigint |
| cached_map_register_object_type | character varying |
| created_at | timestamp(6) without time zone |
| updated_at | timestamp(6) without time zone |
| project_id | bigint |
top,er,rdoc,api
| Name | Type |
|---|
| id | bigint |
| cached_map_type | character varying |
| geometry | geography(Geometry,4326) |
| otu_id | bigint |
| reference_count | integer |
| created_at | timestamp(6) without time zone |
| updated_at | timestamp(6) without time zone |
| project_id | bigint |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| description_name | character varying |
| descriptor_id | integer |
| key_name | character varying |
| label | character varying |
| name | character varying |
| position | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| citation_id | integer |
| pages | character varying |
| topic_id | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| citation_object_id | integer |
| citation_object_type | character varying |
| is_original | boolean |
| pages | character varying |
| source_id | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| cached | text |
| cached_level0_geographic_name | character varying |
| cached_level1_geographic_name | character varying |
| cached_level2_geographic_name | character varying |
| document_label | text |
| elevation_precision | character varying |
| end_date_day | integer |
| end_date_month | integer |
| end_date_year | integer |
| field_notes | text |
| formation | character varying |
| geographic_area_id | integer |
| group | character varying |
| lithology | character varying |
| max_ma | numeric |
| maximum_elevation | numeric |
| md5_of_verbatim_label | character varying |
| member | character varying |
| meta_prioritize_geographic_area | boolean |
| min_ma | numeric |
| minimum_elevation | numeric |
| print_label | text |
| start_date_day | integer |
| start_date_month | integer |
| start_date_year | integer |
| time_end_hour | smallint |
| time_end_minute | smallint |
| time_end_second | smallint |
| time_start_hour | smallint |
| time_start_minute | smallint |
| time_start_second | smallint |
| verbatim_collectors | character varying |
| verbatim_date | character varying |
| verbatim_datum | character varying |
| verbatim_elevation | character varying |
| verbatim_field_number | character varying |
| verbatim_geolocation_uncertainty | character varying |
| verbatim_habitat | text |
| verbatim_label | text |
| verbatim_latitude | character varying |
| verbatim_locality | character varying |
| verbatim_longitude | character varying |
| verbatim_method | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| data | text |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| accessioned_at | date |
| buffered_collecting_event | text |
| buffered_determinations | text |
| buffered_other_labels | text |
| collecting_event_id | integer |
| current_repository_id | integer |
| deaccession_reason | character varying |
| deaccessioned_at | date |
| preparation_type_id | integer |
| ranged_lot_category_id | integer |
| repository_id | integer |
| total | integer |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| arrangement_level | integer |
| collection_type | character varying |
| computerization_level | integer |
| condition_of_labels | integer |
| conservation_status | integer |
| container_condition | integer |
| container_id | integer |
| data_quality | integer |
| identification_level | integer |
| number_of_collection_objects | integer |
| number_of_containers | integer |
| otu_id | integer |
| processing_state | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| end_year | integer |
| geographic_area_id | integer |
| language_id | integer |
| name | character varying |
| otu_id | integer |
| start_year | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| confidence_level_id | integer |
| confidence_object_id | integer |
| confidence_object_type | character varying |
| position | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| contained_object_id | integer |
| contained_object_type | character varying |
| disposition | character varying |
| disposition_x | integer |
| disposition_y | integer |
| disposition_z | integer |
| parent_id | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| disposition | character varying |
| name | character varying |
| print_label | text |
| size_x | integer |
| size_y | integer |
| size_z | integer |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| language_id | bigint |
| otu_id | integer |
| revision_id | integer |
| text | text |
| topic_id | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| css_color | character varying |
| definition | text |
| name | character varying |
| position | integer |
| type | character varying |
| uri | character varying |
| uri_relation | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | bigint |
| conveyance_object_id | bigint |
| conveyance_object_type | character varying |
| end_time | numeric |
| position | integer |
| sound_id | bigint |
| start_time | numeric |
| created_by_id | bigint |
| updated_by_id | bigint |
| created_at | timestamp(6) without time zone |
| updated_at | timestamp(6) without time zone |
| project_id | bigint |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| attribute_subject_id | integer |
| attribute_subject_type | character varying |
| controlled_vocabulary_term_id | integer |
| import_predicate | character varying |
| type | character varying |
| value | text |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | bigint |
| dataset_record_id | bigint |
| encoded_dataset_record_type | integer |
| import_dataset_id | integer |
| position | integer |
| value | character varying |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | bigint |
| import_dataset_id | bigint |
| metadata | jsonb |
| status | character varying |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp(6) without time zone |
| updated_at | timestamp(6) without time zone |
| project_id | bigint |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| caption | text |
| depiction_object_id | integer |
| depiction_object_type | character varying |
| figure_label | character varying |
| image_id | integer |
| is_metadata_depiction | boolean |
| position | integer |
| sled_image_id | bigint |
| sled_image_x_position | integer |
| sled_image_y_position | integer |
| svg_clip | xml |
| svg_view_box | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| collection_object_id | integer |
| collection_object_observation_id | integer |
| position | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| cached_gene_attribute_sql | character varying |
| default_unit | character varying |
| description | text |
| description_name | character varying |
| gene_attribute_logic | character varying |
| key_name | character varying |
| name | character varying |
| position | integer |
| short_name | character varying |
| type | character varying |
| weight | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| document_id | integer |
| documentation_object_id | integer |
| documentation_object_type | character varying |
| position | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| document_file_content_type | character varying |
| document_file_file_name | character varying |
| document_file_file_size | integer |
| document_file_fingerprint | character varying |
| document_file_updated_at | timestamp without time zone |
| is_public | boolean |
| page_map | jsonb |
| page_total | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | bigint |
| description | character varying |
| expires | timestamp without time zone |
| filename | character varying |
| is_public | boolean |
| name | character varying |
| request | character varying |
| times_downloaded | integer |
| total_records | integer |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | bigint |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| day_made | integer |
| month_made | integer |
| repository_id | bigint |
| verbatim_anatomical_origin | character varying |
| year_made | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | bigint |
| collecting_event_id | bigint |
| is_absent | boolean |
| ranged_lot_category_id | bigint |
| total | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp(6) without time zone |
| updated_at | timestamp(6) without time zone |
| project_id | bigint |
top,er,rdoc
| Name | Type |
|---|
| id | bigint |
| geographic_item_id | integer |
| iso_3166_a2 | character varying |
| iso_3166_a3 | character varying |
| name | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp(6) without time zone |
| updated_at | timestamp(6) without time zone |
| project_id | bigint |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| controlled_vocabulary_term_id | integer |
| descriptor_id | integer |
| position | integer |
| sequence_id | integer |
| sequence_relationship_type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| name | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| data_origin | character varying |
| geographic_area_type_id | integer |
| iso_3166_a2 | character varying |
| iso_3166_a3 | character varying |
| level0_id | integer |
| level1_id | integer |
| level2_id | integer |
| name | character varying |
| parent_id | integer |
| tdwgID | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| data_origin | character varying |
| date_valid_from | character varying |
| date_valid_to | character varying |
| geographic_area_id | integer |
| geographic_item_id | integer |
| origin_gid | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| cached_total_area | numeric |
| geography | geography(GeometryZ,4326) |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| api_request | character varying |
| collecting_event_id | integer |
| day_georeferenced | integer |
| error_depth | numeric |
| error_geographic_item_id | integer |
| error_radius | numeric |
| geographic_item_id | integer |
| is_public | boolean |
| month_georeferenced | integer |
| position | integer |
| type | character varying |
| year_georeferenced | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| cached | text |
| cached_numeric_identifier | double precision |
| identifier | character varying |
| identifier_object_id | integer |
| identifier_object_type | character varying |
| namespace_id | integer |
| position | integer |
| relation | character varying |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| height | integer |
| image_file_content_type | character varying |
| image_file_file_name | character varying |
| image_file_file_size | integer |
| image_file_fingerprint | character varying |
| image_file_meta | text |
| image_file_updated_at | timestamp without time zone |
| pixels_to_centimeter | double precision |
| user_file_name | character varying |
| width | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | bigint |
| description | character varying |
| metadata | jsonb |
| source_content_type | character varying |
| source_file_name | character varying |
| source_file_size | bigint |
| source_updated_at | timestamp without time zone |
| status | character varying |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp(6) without time zone |
| updated_at | timestamp(6) without time zone |
| project_id | bigint |
top,er,rdoc
| Name | Type |
|---|
| id | bigint |
| is_copy_edited | boolean |
| is_printed | boolean |
| label_object_id | bigint |
| label_object_type | character varying |
| style | character varying |
| text | character varying |
| total | integer |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| alpha_2 | character varying |
| alpha_3_bibliographic | character varying |
| alpha_3_terminologic | character varying |
| english_name | character varying |
| french_name | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
top,er,rdoc,api
| Name | Type |
|---|
| id | bigint |
| description | text |
| is_public | boolean |
| link_out | text |
| link_out_text | character varying |
| origin_label | character varying |
| otu_id | bigint |
| parent_id | bigint |
| position | integer |
| redirect_id | bigint |
| text | text |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp(6) without time zone |
| updated_at | timestamp(6) without time zone |
| project_id | bigint |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| date_returned | date |
| disposition | character varying |
| loan_id | integer |
| loan_item_object_id | integer |
| loan_item_object_type | character varying |
| position | integer |
| total | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| date_closed | date |
| date_received | date |
| date_requested | date |
| date_return_expected | date |
| date_sent | date |
| is_gift | boolean |
| lender_address | text |
| recipient_address | character varying |
| recipient_country | character varying |
| recipient_email | character varying |
| recipient_honorific | character varying |
| recipient_phone | character varying |
| request_method | character varying |
| supervisor_email | character varying |
| supervisor_phone | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| delimiter | character varying |
| institution | character varying |
| is_virtual | boolean |
| name | character varying |
| short_name | character varying |
| verbatim_short_name | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| note_object_attribute | character varying |
| note_object_id | integer |
| note_object_type | character varying |
| text | text |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| is_public | boolean |
| name | character varying |
| otu_id | bigint |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| controlled_vocabulary_term_id | integer |
| descriptor_id | integer |
| observation_matrix_id | integer |
| position | integer |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| cached_observation_matrix_column_item_id | integer |
| descriptor_id | integer |
| observation_matrix_id | integer |
| position | integer |
| reference_count | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| controlled_vocabulary_term_id | integer |
| observation_matrix_id | integer |
| observation_object_id | integer |
| observation_object_type | character varying |
| position | integer |
| taxon_name_id | bigint |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| cached_observation_matrix_row_item_id | integer |
| name | character varying |
| observation_matrix_id | integer |
| observation_object_id | integer |
| observation_object_type | character varying |
| position | integer |
| reference_count | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| cached | character varying |
| cached_column_label | character varying |
| cached_row_label | character varying |
| character_state_id | integer |
| continuous_unit | character varying |
| continuous_value | numeric |
| day_made | integer |
| description | text |
| descriptor_id | integer |
| frequency | character varying |
| month_made | integer |
| observation_object_id | integer |
| observation_object_type | character varying |
| presence | boolean |
| sample_max | numeric |
| sample_mean | numeric |
| sample_median | numeric |
| sample_min | numeric |
| sample_n | integer |
| sample_standard_deviation | numeric |
| sample_standard_error | numeric |
| sample_units | character varying |
| time_made | time without time zone |
| type | character varying |
| year_made | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | bigint |
| address | character varying |
| alternate_name | character varying |
| area_served_id | integer |
| department_id | integer |
| description | text |
| disambiguating_description | text |
| duns | character varying |
| email | character varying |
| global_location_number | character varying |
| legal_name | character varying |
| name | character varying |
| parent_organization_id | integer |
| same_as_id | integer |
| telephone | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| new_object_id | integer |
| new_object_type | character varying |
| old_object_id | integer |
| old_object_type | character varying |
| position | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| dynamic_content_class | character varying |
| otu_page_layout_id | integer |
| position | integer |
| topic_id | integer |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| name | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | bigint |
| object_otu_id | integer |
| subject_otu_id | integer |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp(6) without time zone |
| updated_at | timestamp(6) without time zone |
| project_id | bigint |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| name | text |
| taxon_name_id | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| cached | text |
| first_name | character varying |
| last_name | character varying |
| prefix | character varying |
| suffix | character varying |
| type | character varying |
| year_active_end | integer |
| year_active_start | integer |
| year_born | integer |
| year_died | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| definition | text |
| name | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| clipboard | jsonb |
| is_project_administrator | boolean |
| last_seen_at | timestamp without time zone |
| time_active | integer |
| user_id | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| source_id | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| position | integer |
| protocol_id | integer |
| protocol_relationship_object_id | integer |
| protocol_relationship_object_type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| description | text |
| is_machine_output | boolean |
| name | character varying |
| short_name | text |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| maximum_value | integer |
| minimum_value | integer |
| name | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| acronym | character varying |
| institutional_LSID | character varying |
| is_index_herbariorum | boolean |
| name | character varying |
| status | character varying |
| url | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| organization_id | bigint |
| person_id | integer |
| position | integer |
| role_object_id | integer |
| role_object_type | character varying |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| object_sequence_id | integer |
| subject_sequence_id | integer |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| name | character varying |
| sequence | text |
| sequence_type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| preceding_serial_id | integer |
| succeeding_serial_id | integer |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| first_year_of_issue | smallint |
| is_electronic_only | boolean |
| last_year_of_issue | smallint |
| name | text |
| place_published | character varying |
| primary_language_id | integer |
| publisher | text |
| translated_from_serial_id | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
top,er,rdoc
| Name | Type |
|---|
| id | bigint |
| cached_total_collection_objects | integer |
| cached_total_columns | integer |
| cached_total_rows | integer |
| image_id | bigint |
| metadata | jsonb |
| object_layout | jsonb |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp(6) without time zone |
| updated_at | timestamp(6) without time zone |
| project_id | bigint |
top,er,rdoc,api
| Name | Type |
|---|
| id | bigint |
| name | text |
| created_by_id | bigint |
| updated_by_id | bigint |
| created_at | timestamp(6) without time zone |
| updated_at | timestamp(6) without time zone |
| project_id | bigint |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| abstract | text |
| address | character varying |
| annote | character varying |
| author | text |
| bibtex_type | character varying |
| booktitle | character varying |
| cached | text |
| cached_author_string | text |
| cached_nomenclature_date | date |
| chapter | character varying |
| copyright | text |
| crossref | character varying |
| day | smallint |
| doi | character varying |
| edition | character varying |
| editor | character varying |
| howpublished | character varying |
| institution | character varying |
| isbn | character varying |
| issn | character varying |
| journal | character varying |
| key | character varying |
| language | character varying |
| language_id | integer |
| month | character varying |
| note | character varying |
| number | character varying |
| organization | character varying |
| pages | character varying |
| publisher | character varying |
| school | character varying |
| serial_id | integer |
| series | character varying |
| stated_year | character varying |
| title | text |
| translator | character varying |
| type | character varying |
| url | character varying |
| verbatim | character varying |
| verbatim_contents | text |
| verbatim_keywords | text |
| volume | character varying |
| year | smallint |
| year_suffix | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| boundary_color | character varying |
| boundary_finder | character varying |
| depiction_id | integer |
| has_border | boolean |
| in_progress | timestamp without time zone |
| layout | character varying |
| metadata_map | jsonb |
| result_boundary_coordinates | jsonb |
| result_ocr | jsonb |
| specimen_coordinates | jsonb |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| keyword_id | integer |
| otu_page_layout_section_id | integer |
| position | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| keyword_id | integer |
| position | integer |
| tag_object_attribute | character varying |
| tag_object_id | integer |
| tag_object_type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| biological_collection_object_id | bigint |
| day_made | integer |
| month_made | integer |
| otu_id | integer |
| position | integer |
| print_label | text |
| taxon_determination_object_id | bigint |
| taxon_determination_object_type | character varying |
| year_made | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| taxon_name_id | integer |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| object_taxon_name_id | integer |
| subject_taxon_name_id | integer |
| type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc,api
| Name | Type |
|---|
| id | integer |
| cached | text |
| cached_author | text |
| cached_author_year | text |
| cached_classified_as | text |
| cached_gender | text |
| cached_html | text |
| cached_is_available | boolean |
| cached_is_valid | boolean |
| cached_misspelling | boolean |
| cached_nomenclature_date | date |
| cached_original_combination | text |
| cached_original_combination_html | text |
| cached_primary_homonym | text |
| cached_primary_homonym_alternative_spelling | text |
| cached_secondary_homonym | text |
| cached_secondary_homonym_alternative_spelling | text |
| cached_valid_taxon_name_id | integer |
| etymology | text |
| feminine_name | text |
| masculine_name | text |
| name | text |
| neuter_name | text |
| parent_id | integer |
| rank_class | text |
| type | character varying |
| verbatim_author | text |
| verbatim_name | text |
| year_of_publication | integer |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |
top,er,rdoc
| Name | Type |
|---|
| id | integer |
| collection_object_id | integer |
| protonym_id | integer |
| type_type | character varying |
| created_by_id | integer |
| updated_by_id | integer |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
| project_id | integer |