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 |