Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each training program |
|
| AppID | int | 4 | null |
|
|
Application reference - Links to the application or system module |
||
| CategoryID | int | 4 | null |
|
|
Category reference - Links to the training category for organization |
||
| Title | varchar | 250 | null |
|
|
Training title - Title or name of the training program |
||
| Description | ntext | 1073741823 | √ | null |
|
|
Training description - Detailed description of the training content and objectives |
|
| FileID | int | 4 | √ | null |
|
|
File reference - Links to training materials, documents, or media files |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the training program |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date and time when the training was created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the training |
|
| UpdatedDate | datetime | 16,3 | √ | null |
|
|
Update date - Date and time when the training was last updated |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the training was soft-deleted |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Training | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
