dbo.GS_EEGeocodeTrackerResultSuggestions 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
GeocodeTrackerResultSuggestions_ID	int	4
EmployeeID	varchar	15
ConflictType	varchar	100
GeoExplanation	varchar	500
ShortDescription	varchar	500
TaxType	varchar	50
TaxSubType	varchar	50
CurrentGSTaxCodeID	varchar	25
CurrentGSTaxCodeDescriptionReadable	varchar	100
CurrentTheirTaxCodeID	varchar	25
CurrentTheirTaxCodeDescriptionReadable	varchar	100
CurrentJurisdictionType	varchar	50
SuggestedGSTaxCodeID	varchar	25
SuggestedGSTaxCodeDescriptionReadable	varchar	100
SuggestedTheirTaxCodeID	varchar	25
SuggestedTheirTaxCodeDescriptionReadable	varchar	100
SuggestedJurisdictionType	varchar	50
IsCertain	tinyint	1
Modified	datetime	4
GeocodeTrackerResults_ID	int	4

Indexes

Index	Description	Primary	Unique
PK__GS_EEGeo__A4303003C02138D6

Relationships

Relationship	Description
FK__GS_EEGeoc__Geoco__4F403811
FK__GS_EEGeoc__Geoco__5310C8F5

Objects that depend on dbo.GS_EEGeocodeTrackerResultSuggestions

	Database Object	Object Type	Description	Dep Level
	dbo.GS_EEGeocodeTrackerResultUncertainPossibilities	Table		1
	dbo.GS_RefreshEEGeocodeTrackerResults	Stored Procedure		1

Objects that dbo.GS_EEGeocodeTrackerResultSuggestions depends on

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

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[GS_EEGeocodeTrackerResultSuggestions](
	[GeocodeTrackerResultSuggestions_ID] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeID] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[ConflictType] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[GeoExplanation] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ShortDescription] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[TaxType] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[TaxSubType] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CurrentGSTaxCodeID] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CurrentGSTaxCodeDescriptionReadable] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CurrentTheirTaxCodeID] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CurrentTheirTaxCodeDescriptionReadable] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CurrentJurisdictionType] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedGSTaxCodeID] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedGSTaxCodeDescriptionReadable] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedTheirTaxCodeID] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedTheirTaxCodeDescriptionReadable] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SuggestedJurisdictionType] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[IsCertain] [tinyint] NOT NULL,
	[Modified] [datetime] NULL,
	[GeocodeTrackerResults_ID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[GeocodeTrackerResultSuggestions_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [dbo].[GS_EEGeocodeTrackerResultSuggestions]  WITH CHECK ADD FOREIGN KEY([GeocodeTrackerResults_ID])
REFERENCES [dbo].[GS_EEGeocodeTrackerResults] ([GeocodeTrackerResults_ID])

Related Objects

dbo Schema
SQL Objects Database