with Name

KDOT PMS Replacement Project

ERModel : Model . Modeling : Package

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

	SSEGID		number(0)				Yes
	SURVDATE		timestamp(0)				Yes
	SESSIONFILE		varchar2(22)				Yes
	FRAME		number(0)				Yes
	SCRACKID		number(0)				Yes
	SMOOTHNESSI		number(6, 3)				Yes
	SMOOTHNESSO		number(6, 3)				Yes
	SEALAVGINTENSITY		number(0)				Yes
	SEALAREA		number(8, 3)				Yes
	SBBMINX		number(0)				Yes
	SBBMAXX		number(0)				Yes
	SBBMINY		number(0)				Yes
	SBBMAXY		number(0)				Yes

Columns Detail



	Name		Value

	Name		SSEGID
	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		SURVDATE
	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		SESSIONFILE
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		22
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		FRAME
	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		SCRACKID
	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		SMOOTHNESSI
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		6
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

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



	Name		Value

	Name		SEALAVGINTENSITY
	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		SEALAREA
	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		SBBMINX
	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		SBBMAXX
	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		SBBMINY
	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		SBBMAXY
	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

Appears In



	Diagram

	KDOT_RPMS_Modeling(Reduced) : Entity Relationship Diagram

KDOT PMS Replacement Project