KITCHEN_EQUIPMENT 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.
SequenceNumber	XSD:Integer	INTEGER	YES	An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element.
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.
KitchenEquipmentCount	MISMOCount	INTEGER	NO	Holds the number of kitchen items specified by Kitchen Equipment Type
KitchenEquipmentDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to describe in detail the identified kitchen equipment.
KitchenEquipmentMakeModelDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to capture the make and model of the kitchen equipment.
KitchenEquipmentType	KitchenEquipmentEnum	VARCHAR(0)	YES	Specifies the kitchen equipment normally found in a living unit or residence.
KitchenEquipmentTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe the kitchen equipment if Other is selected as the Kitchen Equipment 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.

KITCHEN_EQUIPMENT Keys

Key Name

Key Type

Keys

KITCHEN_EQUIPMENT Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
KITCHEN_EQUIPMENTS	Identifying	One To Zero or More					NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

KITCHEN_EQUIPMENT Check Constraints

Check Constraint Name

CheckConstraint

KITCHEN_EQUIPMENT Bound Attachments

Name	Current Value

KITCHEN_EQUIPMENT User-Defined Mappings

Model

Name

Description

KITCHEN_EQUIPMENT Data Movement Rules

Name

Type

Rule Text/Value