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