BASEMENT_FEATURE Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
BasementFeatureDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe or comment on the feature specified in the Basement Feature Type.
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.
BasementFeatureType	BasementFeatureEnum	VARCHAR(0)	YES	Specifies the basement feature that is present in the basement.
BasementFeatureTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe the Basement Feature if Other is selected as the Basement Feature Type.
ConditionRatingType	ConditionRatingEnum	VARCHAR(0)	YES	A rating of the quality of the identified component.
MaterialDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to describe in detail the material used in the identified component.
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.

BASEMENT_FEATURE Keys

Key Name

Key Type

Keys

BASEMENT_FEATURE Relationships

Parent Relationships:

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

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

BASEMENT_FEATURE Check Constraints

Check Constraint Name

CheckConstraint

BASEMENT_FEATURE Bound Attachments

Name	Current Value

BASEMENT_FEATURE User-Defined Mappings

Model

Name

Description

BASEMENT_FEATURE Data Movement Rules

Name

Type

Rule Text/Value