REFERENCE
Referencing tables: analysis | attachment | attachment_link | collection | dataset | dataset_reference | doi | journal | keyword | library | library_reference | locality_description | locality_reference | locality_stratigraphy | locality_synonym | reference_keyword | list_reference_type | rock_classification | rock_property | rock_reference | rock_synonym | sample_reference | sample_series_reference | specimen_identification | specimen_identification_geology | specimen_reference | specimen_union | stratigraphy | stratigraphy_reference | stratigraphy_stratotype | stratigraphy_synonym | taxon | taxon_description | taxon_occurrence | taxon_opinion | taxon_synonym | taxon_type_specimen | list_language | list_licence | selection |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| reference | varchar | ||
| author | varchar | ||
| author_original | varchar | ||
| year | varchar | ||
| type | int | list_reference_type | |
| language | int | list_language | |
| title | varchar | ||
| title_original | varchar | ||
| title_translated | varchar | ||
| title_translated_language | int | list_language | |
| book | varchar | ||
| book_original | varchar | ||
| book_translated | varchar | ||
| book_translated_language | int | list_language | |
| book_editor | varchar | ||
| publisher | varchar | ||
| publisher_place | varchar | ||
| journal | int | journal | |
| journal_txt | varchar | ||
| journal_additional | varchar | ||
| volume | varchar | ||
| number | varchar | ||
| pages | varchar | ||
| figures | varchar | ||
| doi | varchar | ||
| url | varchar | ||
| issn | varchar | ||
| isbn | varchar | ||
| abstract | text | ||
| author_keywords | varchar | ||
| tags | varchar | ||
| remarks | text | ||
| remarks_private | text | ||
| is_oa | tinyint | ||
| licence | int | list_licence | |
| egf | int | ||
| is_private | tinyint | ||
| is_locked | tinyint | ||
| location_txt | varchar | ||
| is_estonian_reference | tinyint | ||
| is_estonian_author | tinyint | ||
| parent_reference | int | reference | |
| translated_reference | int | reference | |
| id | int(auto increment) | ||
| uuid | uuid | ||
| keywords | int | keyword | |
| attachments | int | attachment |
