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 .
|