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 |
Index Name | Index Description | Index Keys |
PK_Users | clustered, unique, primary key located on PRIMARY | ID |
U_UserNumber | nonclustered, unique located on PRIMARY | Timestamp |