This file auto-generated 2022-02-08 10:47:05 -0600 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, character_states, citation_topics, citations, collecting_events, collection_object_observations, collection_objects, collection_profiles, common_names, confidences, container_items, containers, contents, controlled_vocabulary_terms, data_attributes, dataset_record_fields, dataset_records, depictions, derived_collection_objects, descriptors, documentation, documents, extracts, gene_attributes, geographic_area_types, geographic_areas, geographic_areas_geographic_items, geographic_items, georeferences, identifiers, images, import_datasets, labels, languages, 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, otus, people, preparation_types, project_members, project_sources, protocol_relationships, protocols, ranged_lot_categories, repositories, roles, sequence_relationships, sequences, serial_chronologies, serials, sled_images, sources, 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 |
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 |
biological_collection_object_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 |
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 |
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
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 | 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 |
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_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 |
verbatim_trip_identifier | 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 |
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
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
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 | 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
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
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
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 |
geometry_collection | geography(GeometryCollectionZ,4326) |
line_string | geography(LineStringZ,4326) |
multi_line_string | geography(MultiLineStringZ,4326) |
multi_point | geography(MultiPointZ,4326) |
multi_polygon | geography(MultiPolygonZ,4326) |
point | geography(PointZ,4326) |
polygon | geography(PolygonZ,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_median_z | boolean |
is_public | boolean |
is_undefined_z | 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 |
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
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 |
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 |
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 |
collection_object_id | integer |
controlled_vocabulary_term_id | integer |
observation_matrix_id | integer |
otu_id | integer |
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 |
collection_object_id | integer |
name | character varying |
observation_matrix_id | integer |
otu_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,api
Name | Type |
---|
id | integer |
cached | character varying |
cached_column_label | character varying |
cached_row_label | character varying |
character_state_id | integer |
collection_object_id | integer |
continuous_unit | character varying |
continuous_value | numeric |
description | text |
descriptor_id | integer |
frequency | character varying |
otu_id | integer |
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 |
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 | 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,api
Name | Type |
---|
id | integer |
name | character varying |
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 |
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 |
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 |
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 | 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 |
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
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 | integer |
day_made | integer |
month_made | integer |
otu_id | integer |
position | integer |
print_label | text |
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 | character varying |
cached_author_year | character varying |
cached_classified_as | character varying |
cached_html | character varying |
cached_is_valid | boolean |
cached_misspelling | boolean |
cached_nomenclature_date | date |
cached_original_combination | character varying |
cached_original_combination_html | character varying |
cached_primary_homonym | character varying |
cached_primary_homonym_alternative_spelling | character varying |
cached_secondary_homonym | character varying |
cached_secondary_homonym_alternative_spelling | character varying |
cached_valid_taxon_name_id | integer |
etymology | text |
feminine_name | character varying |
masculine_name | character varying |
name | character varying |
neuter_name | character varying |
parent_id | integer |
rank_class | character varying |
type | character varying |
verbatim_author | character varying |
verbatim_name | character varying |
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 |