VISIT
Referencing tables: None
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| visitor | int | agent | |
| visitor_free | varchar | ||
| visitor_institution | int | agent | |
| visitor_country | int | list_country | |
| host | int | agent | |
| date_arrived | date | ||
| date_left | date | ||
| purpose | text | ||
| collections_studied | varchar | ||
| items_studied | int | ||
| remarks | text | ||
| database | int | database | |
| timestamp_created | datetime | ||
| timestamp_modified | datetime | ||
| id | int(auto increment) | ||
| timestamp | datetime |
