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

	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