1. SIGNIFICANT EVENT
The significant_event table lists all events considered to be
significant in the history of the Backbay area. This includes natural
disasters, legal decisions, and cultural and sporting events.
| significant_event |
| significant_event_id |
(primary key) |
A unique id number assigned to the
event
|
| display_name |
 |
The event's name |
| start_day |
|
The day the event began |
| start_month |
|
The month the event began |
| start_year |
|
The year the event began |
| end_day |
|
The day the event ended |
| end_month |
|
The month the event ended |
| end_year |
|
The year the event ended |
| descriptive_note |
|
Textual description of the event |
| area_location_id |
(foreign key) |
Links the event to a specific area |
This table has names popularly associated with significant events.
Not all significant events are listed here. It probably is supposed to be the
popular, well-known name for well-known events, such as "The Great War" or "the
Spanish Flu", where as display_name is the official, historical-sanctioned
name, such as "World War I" and "1918 Spanish Flu Pandemic"
| significant_event_name |
| significant_event_name_id
|
(primary key) |
A unique number assigned to the event's
name
|
| sig_evt_name |
|
A name describing the event. This name may
or may not be the same as the display_name field in the significant_event
table.
|
| significant_event_id |
(foreign key) |
Links the event name to the event's unique
ID number.
|
The event_class table describes events according to a classification
scheme. For example, an event might be a legislative decision, a military
action, or something people have built.
| event_class |
| event_class_id |
(primary key) |
A unique ID number to identify the event
class
|
| event_class |
|
What class the event falls into. |
| significant_event_id |
(foreign key) |
A link to the event's unique ID. |
2. OBJECT
3. CORPORATE BODY
4. PERSON
5. MANIFESTATION
6. WORK
© 2002 IATH at the University of Virginia. All rights reserved.
|