Referencing tables: None
| 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 | ||
| title | varchar | ||
| language | int | ||
| title_original | varchar | ||
| title_translated | varchar | ||
| title_translated_language_id | int | ||
| type | int | ||
| book | varchar | ||
| book_original | varchar | ||
| book_translated | varchar | ||
| book_translated_language_id | int | ||
| book_editor | varchar | ||
| publisher | varchar | ||
| publisher_place | varchar | ||
| journal_id | int | ||
| journal | varchar | ||
| journal_additional | varchar | ||
| volume | varchar | ||
| number | varchar | ||
| pages | varchar | ||
| page_start | int | ||
| page_end | int | ||
| figures | varchar | ||
| issn | varchar | ||
| isbn | varchar | ||
| doi | varchar | ||
| url | varchar | ||
| abstract | text | ||
| author_keywords | varchar | ||
| tags | text | ||
| remarks | text | ||
| remarks_private | text | ||
| is_oa | int | ||
| licence_id | int | ||
| is_private | int | ||
| is_locked | int | ||
| copy_exists | int | ||
| location_txt | varchar | ||
| egf | int | ||
| category_id | int | ||
| is_estonian_reference | int | ||
| is_estonian_author | int | ||
| parent_reference_id | int | ||
| translated_reference_id | int | ||
| uuid | varchar | ||
| timestamp | datetime |