dbo.GS_EEAddressTrackerResults Table

Properties

Creation Date	9/25/2015 3:11 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	0
Data Space Used	0.00 KB
Index Space Used	0.00 KB

Columns

Column Name	Datatype	Length
AddressTrackerResults_ID	int	4
EmployeeID	varchar	15
CurrentAddressCode	varchar	15
Result	varchar	50
CurrentAddressString	varchar	500
CurrentAddress1	varchar	61
CurrentAddress2	varchar	62
CurrentAddress3	varchar	61
CurrentCity	varchar	35
CurrentState	varchar	29
CurrentZipCode	varchar	11
CurrentZipExt	varchar	6
CurrentCounty	varchar	61
CurrentCountry	varchar	61
Modified	datetime	4

Indexes

Index	Description	Primary	Unique
PK__GS_EEAdd__CE9488702E77FACA
UQ__GS_EEAdd__7AD04FF016891628

Relationships

Relationship	Description
FK__GS_EEAddr__Addre__48933A82

Objects that depend on dbo.GS_EEAddressTrackerResults

	Database Object	Object Type	Description	Dep Level
	dbo.GS_EEAddressTrackerResultSuggestions	Table		1
	dbo.GS_RefreshEEAddressTrackerResults	Stored Procedure		1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[GS_EEAddressTrackerResults](
	[AddressTrackerResults_ID] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeID] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[CurrentAddressCode] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Result] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[CurrentAddressString] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[CurrentAddress1] [varchar](61) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CurrentAddress2] [varchar](62) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CurrentAddress3] [varchar](61) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CurrentCity] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CurrentState] [varchar](29) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CurrentZipCode] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CurrentZipExt] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CurrentCounty] [varchar](61) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CurrentCountry] [varchar](61) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Modified] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[AddressTrackerResults_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED 
(
	[EmployeeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Related Objects

dbo Schema
SQL Objects Database