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