VENUE table - Amazon Redshift

VENUE table

Column name Data type Description
VENUEID SMALLINT Primary key, a unique ID value for each row. Each row represents a specific venue where events take place.
VENUENAME VARCHAR(100) Exact name of the venue, such as Cleveland Browns Stadium.
VENUECITY VARCHAR(30) City name, such as Cleveland.
VENUESTATE CHAR(2) Two-letter state or province abbreviation (United States and Canada), such as OH.
VENUESEATS INTEGER Maximum number of seats available at the venue, if known, such as 73200. For demonstration purposes, this column contains some null values and zeroes.