with Name

KDOT PMS Replacement Project

ERModel : Model . Modeling : Package

Entity - STOPPERS2016BKUPOKAY 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

	STOP_CALCDATE		timestamp(0)				Yes
	STOPPER_ID		varchar2(19)				Yes
	COUNTY		number(0)				Yes
	RTNO		number(0)				Yes
	CODE		number(0)				Yes
	LANE		float(10)				Yes
	MILEPOST_MIN		number(12, 7)				Yes
	SITE_DIST_MIN		number(12, 7)				Yes
	LAT_MIN		number(12, 7)				Yes
	LONG_MIN		number(12, 7)				Yes
	HEAD_MIN		number(12, 7)				Yes
	MILEPOST_BEG		number(12, 7)				Yes
	LAT_BEG		number(12, 7)				Yes
	LONG_BEG		number(12, 7)				Yes
	HEAD_BEG		number(12, 7)				Yes
	MILEPOST_END		number(12, 7)				Yes
	LAT_END		number(12, 7)				Yes
	LONG_END		number(12, 7)				Yes
	HEAD_END		number(12, 7)				Yes
	STOP_LENGTH		number(12, 7)				Yes

Columns Detail



	Name		Value

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



	Name		Value

	Name		STOPPER_ID
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		COUNTY
	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		RTNO
	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		CODE
	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		LANE
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		MILEPOST_MIN
	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		SITE_DIST_MIN
	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		LAT_MIN
	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		LONG_MIN
	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		HEAD_MIN
	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		MILEPOST_BEG
	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		LAT_BEG
	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		LONG_BEG
	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		HEAD_BEG
	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		MILEPOST_END
	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		LAT_END
	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		LONG_END
	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		HEAD_END
	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		STOP_LENGTH
	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

KDOT PMS Replacement Project