DATABASE SCHEMA

Explore data model:

ATTACHMENT

Referencing tables: attachment_link |


Field Database column Data type Description Referenced table
agent_digitised agent_digitised int agent
author author int agent
author_free author_free varchar
database database_id int database
date_added date_added datetime
date_changed date_changed datetime
date_created date_created date
date_created_free date_created_free varchar
date_digitised date_digitised date
date_digitised_free date_digitised_free varchar
description description varchar
description_en description_en varchar
device device int device
filename filename varchar
format format int list_mime_type
id attachment_id int(auto increment)
link_id link_id int
link_table link_table varchar
original_filename original_filename varchar
private private tinyint
remarks remarks text
type type int list_attachment_type
user_added user_added varchar
user_changed user_changed varchar