Table: Training Modules
Primary Key: Training
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Training Module ID | Long | 4 | ✓ | |
| Module | Text | 255 | ||
| Module Descriptor | Text | 255 | ||
| Module Objectives | Text | 255 | ||
| Module Duration | Text | 255 | ||
| Presentation Type | Long | 4 | ||
| Content Created | Long | 4 | ||
| Training Created | Long | 4 | ||
| Training Version | Text | 255 | ||
| Assessment | Long | 4 | ||
| Assessment Version | Text | 255 | ||
| Quiz | Long | 4 | ||
| Quiz Version | Text | 255 | ||
| Approved Trainer | Long | 4 | ||
| Trainers | Text | 255 | ||
| Engage Course Codes | Text | 255 | ||
| Default Module | Boolean | 1 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ | |
| Module Cost | Double | 8 |
Indexes
- Training Modules$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Training Modules$Training Module ID