Table: People Qualifications and Certifications
Primary Key: People
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| People Qualification ID | Long | 4 | ✓ | |
| People ID | Long | 4 | ||
| Qualification | Text | 255 | ||
| Date Obtained | DateTime | 8 | ||
| Institution | Text | 255 | ||
| Qualification Cost | Double | 8 | ||
| Own or Company | Long | 4 | ||
| Expiry Date | DateTime | 8 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- People Qualifications and Certifications$People ID
- People Qualifications and Certifications$People Training Module
- People Qualifications and Certifications$PrimaryKey [PRIMARY KEY] [UNIQUE]