with Name

KDOT PMS Replacement Project

ERModel : Model . Modeling : Package

Entity - GPSLRSWHATYEAR link

Properties



	Name		Value

	Data Model		Physical
	Schema		dbo
	Primary Key Clustered		Unspecified
	Unlogged		false
	Temporal		false

Columns Summary



	Column Name		Data Type		PK / FK		Nullable		Description

	COUNTY		number(0)				Yes
	RTNO		number(0)				Yes
	CODE		number(0)				Yes
	REFPOST		number(8, 5)				Yes
	LANE		number(0)				Yes
	LATITUDE		number(11, 7)				Yes
	LONGITUDE		number(12, 7)				Yes
	TRACK_T		number(5, 1)				Yes
	ELEV		number(8, 3)				Yes
	AINDEX		number(0)				Yes
	PMMINDEX		number(0)				Yes
	HZ_RADIUS		number(0)				Yes
	VERT_CURVE		number(12, 5)				Yes

Columns Detail



	Name		Value

	Name		COUNTY
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RTNO
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CODE
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		REFPOST
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		8
	Scale		5
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LANE
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		smallint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LATITUDE
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		11
	Scale		7
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LONGITUDE
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		12
	Scale		7
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		TRACK_T
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		5
	Scale		1
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		ELEV
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		8
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		AINDEX
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PMMINDEX
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		HZ_RADIUS
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		bigint
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		VERT_CURVE
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		12
	Scale		5
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes

KDOT PMS Replacement Project