Table ptms..Drivers

  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    

Indexes on this table

Index Name Index Description Index Keys
PK_Drivers clustered, unique, primary key located on PRIMARY ID
U_Driver nonclustered, unique located on PRIMARY Driver