Referencing tables: attachment | image |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| imageset_number | varchar | ||
| imageset_number_old | varchar | ||
| imageset_series | varchar | ||
| num_images | int | ||
| type | int | ||
| device | int | device | |
| color | tinyint | ||
| size_x | int | ||
| size_y | int | ||
| lens | varchar | ||
| image_category | int | ||
| object | varchar | ||
| place | varchar | ||
| keywords | varchar | ||
| description | varchar | ||
| author | int | agent | |
| author_free | varchar | ||
| client | int | agent | |
| date_start | date | ||
| date_end | date | ||
| date_free | varchar | ||
| date_digitised | date | ||
| date_digitised_free | varchar | ||
| device_digitised | int | device | |
| agent_digitised | int | agent | |
| file_source | varchar | ||
| location | int | location | |
| remarks | text | ||
| classified | tinyint | ||
| is_private | tinyint | ||
| database | int | database | |
| id | int(auto increment) | ||
| timestamp | datetime |