Tables [dbo].[RemoteTechUsers]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:58:42 AM Thursday, March 21, 2019
Last Modified1:05:39 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsDefault
UserNamevarchar(50)50
False
Technicianvarchar(15)15
False
Passwordvarchar(50)50
False
Servervarchar(50)50
False
Companyvarchar(50)50
False
PerfViewint4
False
((1))
CallSyncDatedatetime8
False
CodeSyncDatedatetime8
False
InventorySyncDatedatetime8
False
TimeDifferentialint4
False
LastCallTimeStampvarchar(255)255
True
ServerBiasint4
False
CREATE TABLE [dbo].[RemoteTechUsers]
(
[UserName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Technician] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Password] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Server] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Company] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PerfView] [int] NOT NULL CONSTRAINT [DF_RemoteTechUsers_PerfView] DEFAULT ((1)),
[CallSyncDate] [datetime] NOT NULL,
[CodeSyncDate] [datetime] NOT NULL,
[InventorySyncDate] [datetime] NOT NULL,
[TimeDifferential] [int] NOT NULL,
[LastCallTimeStamp] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ServerBias] [int] NOT NULL
) ON [PRIMARY]
GO