EVENT table
| Column name | Data type | Description |
|---|---|---|
| EVENTID | INTEGER | Primary key, a unique ID value for each row. Each row represents a separate event that takes place at a specific venue at a specific time. |
| VENUEID | SMALLINT | Foreign-key reference to the VENUE table. |
| CATID | SMALLINT | Foreign-key reference to the CATEGORY table. |
| DATEID | SMALLINT | Foreign-key reference to the DATE table. |
| EVENTNAME | VARCHAR(200) | Name of the event, such as
Hamlet or
La Traviata.
|
| STARTTIME | TIMESTAMP | Full date and start time for the event, such
as
2008-10-10 19:30:00.
|