REFERENCE
Contents: publications
Description: table REFERENCE contains information about all the publications connected to the collections, incl. for example paleontological works that reference to certain specific objects; field diaries that contain description of cross sections (that are on record in table LOCALITY and that in itself are localities for objects, samples) etc.
Referencing tables: analysis | attachment_link | collection | conop_distribution | dataset | dataset_reference | doi | library | library_reference | locality_description | locality_reference | locality_stratigraphy | locality_synonym | reference_author | reference_keyword | rock_classification | rock_property | rock_reference | rock_synonym | sample_reference | sample_series_reference | selection | 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 |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | User who first saved record | |
| date_added | datetime | Timestamp when record was created | |
| user_changed | varchar | User who last saved record | |
| date_changed | datetime | Timestamp of last change | |
| reference | varchar | unique reference of publication / manuscript | |
| author | varchar | names of authors spelled out and following bibliography formatting | |
| author_original | varchar | ||
| year | varchar | year of publication with letter when neccesary | |
| title | varchar | title | |
| language | int | language (English, German etc) | list_language |
| title_original | varchar | title in original language, mostly necessary to save transcribed Russian original titles | |
| title_translated | varchar | ||
| title_translated_language | int | list_language | |
| type | int | type of literature (for example article in journal, article in publication etc) | list_reference_type |
| book | varchar | the title of book, publication or some other literature that is used when type has been chosen | |
| book_original | varchar | ||
| book_translated | varchar | ||
| book_translated_language | int | list_language | |
| book_editor | varchar | ||
| publisher | varchar | publisher is used to orientate when object itself has not been entered yet | |
| publisher_place | varchar | location of the publisher | |
| journal | int | journal | |
| journal_txt | varchar | title of periodic literature, must be first saved on table journal | |
| journal_additional | varchar | ||
| volume | varchar | volume | |
| number | varchar | number | |
| pages | varchar | pages as text | |
| page_start | int | first page | |
| page_end | int | last page | |
| figures | varchar | figures, photo tables | |
| issn | varchar | ISSN number | |
| isbn | varchar | ISBN number | |
| doi | varchar | ||
| url | varchar | ||
| abstract | text | ||
| author_keywords | text | ||
| tags | varchar | ||
| remarks | text | additional information about publication | |
| remarks_private | text | ||
| is_oa | tinyint | ||
| licence | int | list_licence | |
| is_private | tinyint | ||
| is_locked | tinyint | ||
| copy_exists | tinyint | choosing a record (yes / no) | |
| location_txt | varchar | ||
| egf | int | ||
| category | reference_category | ||
| is_estonian_reference | tinyint | ||
| is_estonian_author | tinyint | ||
| parent_reference | int | reference | |
| translated_reference | int | reference | |
| id | int(auto increment) | Automatically generated unique sequential primary key (record ID) | |
| uuid | uuid | ||
| timestamp | datetime | timestamp that also reflects date when data was last saved, generated by database engine | |
| keywords | int | keyword | |
| attachments | int | attachment |
