Table: People Badges
Primary Key: People
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| People Badge ID | Long | 4 | ✓ | |
| People ID | Long | 4 | ||
| Badge ID | Long | 4 | ||
| Date Assigned | DateTime | 8 |
Indexes
- PK_People Badges [PRIMARY KEY] [UNIQUE]
Primary Key: People
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| People Badge ID | Long | 4 | ✓ | |
| People ID | Long | 4 | ||
| Badge ID | Long | 4 | ||
| Date Assigned | DateTime | 8 |