Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CatTypeID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|||||||
| CatName | varchar | 255 | √ | null |
|
|
Name field - Descriptive name or identifier for CategoryType records |
|||||||
| CatTypeDescription | Unknown | 0 | null |
|
|
Description - Detailed explanation of the category type’s purpose |
||||||||
| CatTypeName | Unknown | 0 | null |
|
|
Category type name - Descriptive name of the category type |
||||||||
| IsHierarchical | Unknown | 0 | null |
|
|
Hierarchical flag - Whether this category type supports hierarchical organization |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__CategoryType__22751F6C | Primary key | Asc | CatTypeID |