DATABASE SCHEMA

Explore data model:

IMAGE

Referencing tables: None


Field Database column Data type Description Referenced table
agent_digitised agent_digitised int agent
author author int agent
author_free author_free varchar
classified classified tinyint
copyright_agent copyright_agent int agent
database database_id int database
date_added date_added datetime
date_changed date_changed datetime
date_digitised date_digitised date
date_digitised_free date_digitised_free varchar
date_taken date_taken date
date_taken_free date_taken_free varchar
description description varchar
device device int device
device_digitised device_digitised int device
filename filename varchar
id image_id int(auto increment)
image_number image_number varchar
imageset imageset_id int imageset
keywords keywords varchar
latitude latitude double
licence licence int list_licence
locality locality_id int locality
longitude longitude double
object object varchar
people people varchar
place place varchar
remarks remarks text
size_x size_x int
size_y size_y int
timestamp timestamp datetime
type type int list_image_type
user_added user_added varchar
user_changed user_changed varchar