Table ptms..Users

  Column Name Type Length Nullable Description Relationships
Identity ID int identity   No    
  Password varchar 8 Yes    
  FirstName varchar 10 Yes    
  LastName varchar 20 Yes    
  Mi varchar 1 Yes    
  Department varchar 20 Yes    
  Phone varchar 13 Yes    
  Ext varchar 4 Yes    
  Note varchar 50 Yes    
  SystemProcessingOption1 bit   Yes    
  SystemProcessingOption2 bit   Yes    
  SystemProcessingOption3 bit   Yes    
  SchedulingPurgeTripsPurgeAll bit   Yes    
  SchedulingSupsendTripsSuspendAll bit   Yes    
  Suspnall bit   Yes    
  SetupFileInitialization bit   Yes    
  SetupParameters bit   Yes    
  SetupPasswords bit   Yes    
  SetupGeocoding bit   Yes    
  SetupSystemCodes bit   Yes    
  Setupf bit   Yes    
  SetupReports bit   Yes    
  Filler3 varchar 3 Yes    
  SetupAccess bit   Yes    
  WriteRecords bit   Yes    
  ReportWriter bit   Yes    
  ManagementReports bit   Yes    
  Setrptpriv bit   Yes    
  FileMaintenance bit   Yes    
  ClientRecords bit   Yes    
  VehicleServiceSummary bit   Yes    
  AccountsReceivable bit   Yes    
  Timestamp datetime   Yes    

Indexes on this table

Index Name Index Description Index Keys
PK_Users clustered, unique, primary key located on PRIMARY ID
U_UserNumber nonclustered, unique located on PRIMARY Timestamp