ATTACHMENT
Referencing tables: analysis | attachment_keyword | attachment_link | collection | dataset | doi | drillcore | drillcore_box | locality | locality_description | locality_image | location | preparation | project | reference | rock_image | sample | sample_series | selection | site | specimen | taxon | taxon_image | taxon_type_specimen |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| id | int(auto increment) | ||
| link_table | varchar | ||
| link_id | int | ||
| file | varchar | ||
| filename | varchar | ||
| original_filename | varchar | ||
| title | varchar | ||
| title_en | varchar | ||
| specimen_image_attachment | int | ||
| type | int | list_attachment_type | |
| attachment_format | int | list_mime_type | |
| author | int | agent | |
| author_free | varchar | ||
| date_created | date | ||
| date_created_free | varchar | ||
| device | int | device | |
| device_txt | varchar | ||
| date_digitised | date | ||
| date_digitised_free | varchar | ||
| agent_digitised | int | agent | |
| device_digitised | int | device | |
| copyright_agent | int | agent | |
| licence | int | list_licence | |
| description | varchar | ||
| description_en | varchar | ||
| size_mb | double | ||
| remarks | text | ||
| tags | varchar | ||
| stars | int | ||
| private | int | ||
| is_private | tinyint | ||
| is_preferred | tinyint | ||
| is_locked | tinyint | ||
| collection_id | int | ||
| specimen | int | specimen | |
| sample_id | int | ||
| analysis_id | int | ||
| dataset_id | int | ||
| locality | int | locality | |
| preparation_id | int | ||
| reference | reference | ||
| drillcore | int | drillcore | |
| drillcore_box | int | drillcore_box | |
| drillcore_image_id | int | ||
| image_id | int | ||
| imageset | int | imageset | |
| specimen_image_id | int | ||
| image_number | varchar | ||
| image_type | int | list_image_type | |
| image_width | int | ||
| image_height | int | ||
| image_width_mm | double | ||
| image_height_mm | double | ||
| image_category | int | list_image_category | |
| image_object | varchar | ||
| image_place | varchar | ||
| image_people | text | ||
| image_latitude | double | ||
| image_longitude | double | ||
| image_altitude | double | ||
| image_scalebar | varchar | ||
| image_description | text | ||
| image_description_en | text | ||
| storage | varchar | ||
| boolean1 | tinyint | ||
| timestamp | datetime | ||
| database | int | database | |
| uuid | uuid | ||
| uuid_filename | varchar | ||
| filename_old | varchar | ||
| upload | file | ||
| keywords | int | keyword |
