Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CategoryDescription | Unknown | 0 | null |
|
|
Category description - Detailed description of the category’s purpose |
||
| DisplayOrder | Unknown | 0 | null |
|
|
Display order - Numeric order for displaying categories in lists |
||
| pkCategoryID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each checklist category |
|
| CategoryName | varchar | 50 | √ | null |
|
|
Category name - Short name of the checklist category |
|
| CategoryDesc | varchar | 200 | √ | null |
|
|
Category description - Detailed description of the category purpose |
|
| pkChecklistCategoryID | Unknown | 0 | null |
|
|
Primary key - Unique identifier for each checklist category |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__CheckLis__9457383F3F162224 | Primary key | Asc | pkCategoryID |
Relationships
Close relationships within degrees of separation
