CATEGORY table - Amazon Redshift

CATEGORY table

Column name Data type Description
CATID SMALLINT Primary key, a unique ID value for each row. Each row represents a specific type of event for which tickets are bought and sold.
CATGROUP VARCHAR(10) Descriptive name for a group of events, such as Shows and Sports.
CATNAME VARCHAR(10) Short descriptive name for a type of event within a group, such as Opera and Musicals.
CATDESC VARCHAR(50) Longer descriptive name for the type of event, such as Musical theatre.