dbo.GS_EEAddressTrackerResultSuggestions 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
AddressTrackerResultSuggestions_ID	int	4
EmployeeID	varchar	15
SuggestedAddressCode	varchar	15
SuggestedAddressString	varchar	500
SuggestedAddress1	varchar	61
SuggestedAddress2	varchar	62
SuggestedAddress3	varchar	61
SuggestedCity	varchar	35
SuggestedState	varchar	29
SuggestedZipCode	varchar	11
SuggestedZipExt	varchar	6
SuggestedCounty	varchar	61
SuggestedCountry	varchar	61
Modified	datetime	4
AddressTrackerResults_ID	int	4

Relationships

Relationship	Description
FK__GS_EEAddr__Addre__48933A82

Objects that depend on dbo.GS_EEAddressTrackerResultSuggestions

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

Objects that dbo.GS_EEAddressTrackerResultSuggestions depends on

	Database Object	Object Type	Description	Dep Level
	dbo.GS_EEAddressTrackerResults	Table		1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[GS_EEAddressTrackerResultSuggestions](
	[AddressTrackerResultSuggestions_ID] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeID] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[SuggestedAddressCode] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedAddressString] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedAddress1] [varchar](61) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedAddress2] [varchar](62) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedAddress3] [varchar](61) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedCity] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedState] [varchar](29) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedZipCode] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedZipExt] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedCounty] [varchar](61) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedCountry] [varchar](61) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Modified] [datetime] NULL,
	[AddressTrackerResults_ID] [int] NULL
) ON [PRIMARY]

ALTER TABLE [dbo].[GS_EEAddressTrackerResultSuggestions]  WITH CHECK ADD FOREIGN KEY([AddressTrackerResults_ID])
REFERENCES [dbo].[GS_EEAddressTrackerResults] ([AddressTrackerResults_ID])

Related Objects

dbo Schema
SQL Objects Database