| Column Name | Type | Length | Nullable | Description | Relationships | |
| Identity | ID | int identity | No | |||
| Driver | varchar | 3 | Yes | |||
| Provider | varchar | 4 | Yes | |||
| Vendor | varchar | 30 | Yes | |||
| FirstName | varchar | 10 | Yes | |||
| MI | varchar | 1 | Yes | |||
| LastName | varchar | 15 | Yes | |||
| DrugTestDate | datetime | Yes | ||||
| DrugTestResult | varchar | 30 | Yes | |||
| Misc1 | varchar | 6 | Yes | |||
| Misc2 | varchar | 4 | Yes | |||
| Filler10 | varchar | 10 | Yes | |||
| LicenseType | varchar | 30 | Yes | |||
| LicenseNumber | varchar | 15 | Yes | |||
| LicenseExpirationDate | datetime | Yes | ||||
| LicenseIssueDate | datetime | Yes | ||||
| Timestamp | datetime | Yes |
| Index Name | Index Description | Index Keys |
| PK_Drivers | clustered, unique, primary key located on PRIMARY | ID |
| U_Driver | nonclustered, unique located on PRIMARY | Driver |