dbo.GS_EEGeocodeTrackerResultJurisdictions 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
GS_EEGeocodeTrackerResultJurisdiction_ID	int	4
EmployeeID	varchar	15
DexID	int	4
Jurisdiction	varchar	100
JurisAbbreviation	varchar	100
JurisName	varchar	100
JurisType	varchar	50
Segment	varchar	50
IsCertain	tinyint	1
Modified	datetime	4
GeocodeTrackerResults_ID	int	4

Relationships

Relationship	Description
FK__GS_EEGeoc__Geoco__51288083

Objects that depend on dbo.GS_EEGeocodeTrackerResultJurisdictions

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

Objects that dbo.GS_EEGeocodeTrackerResultJurisdictions 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_EEGeocodeTrackerResultJurisdictions](
	[GS_EEGeocodeTrackerResultJurisdiction_ID] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeID] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[DexID] [int] NOT NULL,
	[Jurisdiction] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[JurisAbbreviation] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[JurisName] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[JurisType] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Segment] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[IsCertain] [tinyint] NOT NULL,
	[Modified] [datetime] NULL,
	[GeocodeTrackerResults_ID] [int] NULL
) ON [PRIMARY]

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

Related Objects

dbo Schema
SQL Objects Database