FLOOR_COVERING Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
ComponentAdjustmentAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar amount (either positive or negative) adjustment being made for a specific component of the property.
ComponentClassificationType	ComponentClassificationEnum	VARCHAR(0)	YES	Specifies whether the component is considered real or personal property.
ConditionRatingDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to describe in detail the condition rating of the identified component.
ConditionRatingType	ConditionRatingEnum	VARCHAR(0)	YES	A rating of the quality of the identified component.
FloorCoveringDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to describe in detail the identified floor covering.
FloorCoveringType	FloorCoveringEnum	VARCHAR(0)	YES	Specifies the type of interior floor covering material used in the property.
FloorCoveringTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe the floor covering if Other is selected as the Interior Features Floor Material Type.
QualityRatingDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to describe in detail the quality rating of the identified component.
QualityRatingType	QualityRatingEnum	VARCHAR(0)	YES	A rating of the quality of the identified component type.

FLOOR_COVERING Keys

Key Name

Key Type

Keys

FLOOR_COVERING Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
ROOM	Identifying	One to Zero or One					NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

FLOOR_COVERING Check Constraints

Check Constraint Name

CheckConstraint

FLOOR_COVERING Bound Attachments

Name	Current Value

FLOOR_COVERING User-Defined Mappings

Model

Name

Description

FLOOR_COVERING Data Movement Rules

Name

Type

Rule Text/Value