FLOOD_RISK_FACTOR Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
BaseFloodElevationFeetNumber	MISMONumeric	DECIMAL(0, 2)	NO	The elevation of flood water in relation to sea level at its highest point for a property. Measured in feet.
FloodDepthFeetNumber	MISMONumeric	DECIMAL(0, 2)	NO	The depth of the flood water in relation to the ground for a particular property. Measured in feet.
PropertyElevationFeetNumber	MISMONumeric	DECIMAL(0, 2)	NO	The ground elevation in relation to sea level for a particular property. Measured in feet.
SpecialFloodHazardAreaDistanceFeetNumber	MISMONumeric	DECIMAL(0, 2)	NO	The distance in feet of the nearest Special Flood Hazard Area to a particular property

FLOOD_RISK_FACTOR Keys

Key Name

Key Type

Keys

FLOOD_RISK_FACTOR Relationships

Parent Relationships:

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

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

FLOOD_RISK_FACTOR Check Constraints

Check Constraint Name

CheckConstraint

FLOOD_RISK_FACTOR Bound Attachments

Name	Current Value

FLOOD_RISK_FACTOR User-Defined Mappings

Model

Name

Description

FLOOD_RISK_FACTOR Data Movement Rules

Name

Type

Rule Text/Value