public.category
| Documentation | Tickit |
| Name | category |
| Module | Tickit diagram |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | 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. | |||||
| Primary key, a unique ID value for each row. Each row represents a specific type of event for which tickets are bought and sold. |
||||||||
| 2 | catgroup | character varying(10) | Descriptive name for a group of events, such as Shows and Sports. | |||||
| Descriptive name for a group of events, such as Shows and Sports. |
||||||||
| 3 | catname | character varying(10) | Short descriptive name for a type of event within a group, such as Opera and Musicals. | |||||
| Short descriptive name for a type of event within a group, such as Opera and Musicals. |
||||||||
| 4 | catdesc | character varying(50) | Longer descriptive name for the type of event, such as Musical theatre. | |||||
| Longer descriptive name for the type of event, such as Musical theatre. |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| public.event | public.category | public.event.catid = public.category.catid | fk_category_event | |
|
public.event.catid = public.category.catid Name: fk_category_event |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| pk_category | catid |
Used by
| Name |
|---|
|
public.category
|
Exported: 2018-10-12 23:27, Last imported: 2018-10-01 10:44