Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkCategoryID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each system category |
||||
| CategoryName | varchar | 20 | null |
|
|
Category name - Short name of the functional category |
|||||
| CategoryDesc | varchar | 200 | √ | null |
|
|
Category description - Detailed description of the category’s purpose |
||||
| DateCreated | smalldatetime | 16 | (getdate()) |
|
|
Creation date - Timestamp when the category was created |
|||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the category |
||||
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Timestamp of the most recent category update |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified the category |
||||
| fkSecurableID | int | 4 | √ | null |
|
|
Security reference - Links to SecurableItems table for access control |
||||
| Deleted | bit | 1 | √ | null |
|
|
Deleted flag - Soft delete flag for audit trail purposes |
||||
| Documentation | ntext | 1073741823 | √ | null |
|
|
Documentation - Detailed documentation about the category |
||||
| actionPage | varchar | 100 | √ | null |
|
|
Action page - Default page or action for this category |
||||
| categoryOrder | int | 4 | √ | null |
|
|
Display order - Order for displaying categories in navigation |
||||
| CategoryIcon | varchar | 50 | √ | null |
|
|
Category icon - Icon identifier for visual representation |
||||
| helpURL | varchar | 255 | √ | null |
|
|
Help URL - Link to help documentation for this category |
||||
| videoURL | varchar | 255 | √ | null |
|
|
Video URL - Link to training video for this category |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Categories | Primary key | Asc | pkCategoryID |
Relationships
Close relationships within degrees of separation
