IMAGE
Referencing tables: None
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| imageset | int | imageset | |
| image_number | varchar | ||
| type | int | ||
| device | int | device | |
| color | int | ||
| size_x | int | ||
| size_y | int | ||
| image_category | int | ||
| object | varchar | ||
| place | varchar | ||
| people | varchar | ||
| keywords | varchar | ||
| description | text | ||
| specimen_id | int | ||
| locality | int | locality | |
| latitude | double | ||
| longitude | double | ||
| altitude | double | ||
| person | int | agent | |
| drillcore_box_id | int | ||
| author | int | agent | |
| author_free | varchar | ||
| date_taken | date | ||
| date_taken_free | varchar | ||
| date_digitised | date | ||
| date_digitised_free | varchar | ||
| device_digitised | int | device | |
| agent_digitised | int | agent | |
| filename | varchar | ||
| file_source | varchar | ||
| location | int | location | |
| remarks | text | ||
| classified | int | ||
| is_private | int | ||
| copyright_agent | int | agent | |
| licence | int | list_licence | |
| stars | int | ||
| database | int | database | |
| uuid | varchar | ||
| uuid_filename | varchar | ||
| image_id | int(auto increment) | ||
| timestamp | datetime | ||
| imageset_series | varchar | ||
| imageset_number | varchar |
