Referencing tables: None
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| specimen | int | specimen | |
| image | varchar | ||
| source | varchar | ||
| type | int | list_image_type | |
| mime_type | varchar | ||
| agent | int | agent | |
| author_free | varchar | ||
| date | date | ||
| date_taken_free | varchar | ||
| date_digitised | date | ||
| date_digitised_free | varchar | ||
| device_digitised | int | device | |
| agent_digitised | int | agent | |
| magnification | int | ||
| scalebar | varchar | ||
| camera | varchar | ||
| device_id | int | device | |
| view | varchar | ||
| description | text | ||
| description_en | text | ||
| location | varchar | ||
| remarks | text | ||
| remarks_en | text | ||
| tags | varchar | ||
| stars | int | ||
| public | int | ||
| is_private | tinyint | ||
| is_classified | tinyint | ||
| copyright_agent | int | agent | |
| licence | int | list_licence | |
| id | int(auto increment) | ||
| database | int | database | |
| uuid | varchar | ||
| uuid_filename | varchar | ||
| timestamp | datetime | ||
| image_url | varchar |