Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each training category |
|
| AppID | int | 4 | null |
|
|
Application reference - Links to the application or system module |
||
| Name | varchar | 250 | null |
|
|
Category name - Name of the training category |
||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the category |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date and time when the category was created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the category |
|
| UpdatedDate | datetime | 16,3 | √ | null |
|
|
Update date - Date and time when the category was last updated |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the category was soft-deleted |
|
| Order | int | 4 | √ | null |
|
|
Display order - Order in which categories are displayed in the user interface |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_TrainingCategory | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
