DATABASE SCHEMA

Explore data model:

VISIT

Referencing tables: None


Field Database column Data type Description Referenced table
collections_studied collections_studied varchar
database database_id int database
date_added date_added datetime
date_arrived date_arrived date
date_changed date_changed datetime
date_left date_left date
host host_id int agent
id id int(auto increment)
items_studied items_studied int
purpose purpose text
remarks remarks text
timestamp timestamp datetime
user_added user_added varchar
user_changed user_changed varchar
visitor visitor_id int agent
visitor_country visitor_country int list_country
visitor_free visitor_free varchar
visitor_institution visitor_institution_id int agent