| SITE_DETAIL |
| EntityType | Dependent |
| Logical Entity Name | SITE_DETAIL |
| Default Table Name | DEAL/SERVICES/SERVICE/TITLE/TITLE_RESPONSE/PROPERTY/SITE/SITE_DETAIL |
| Definition | |
| Note |
| SITE_DETAIL Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| CharacteristicsAffectMarketabilityDescription | MISMOString | VARCHAR(0) | NO | A free-form text field describing the characteristics that affect marketability |
| ConditionRatingType | ConditionRatingEnum | VARCHAR(0) | YES | A rating of the quality of the identified component. |
| CornerLotIndicator | MISMOIndicator | BIT | NO | Indicates that the property lot or site is situated on a corner. |
| SiteAdverseConditionsIndicator | MISMOIndicator | BIT | NO | Indicates that there adverse site conditions or external factors. |
| SiteHighestBestUseDescription | MISMOString | VARCHAR(0) | NO | Specifies a use, other than the present use, that would constitute a higher and best use of the site. |
| SiteHighestBestUseIndicator | MISMOIndicator | BIT | NO | Indicates that the present use is the highest and best of the site as improved. |
| SITE_DETAIL Keys |
| Key Name | Key Type | Keys |
| SITE_DETAIL Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| SITE | Identifying | One to Zero or One | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| SITE_DETAIL Check Constraints |
| Check Constraint Name | CheckConstraint |
| SITE_DETAIL Bound Attachments |
| Name | Current Value |
| SITE_DETAIL User-Defined Mappings |
| Model | Name | Description |
| SITE_DETAIL Data Movement Rules |
| Name | Type | Rule Text/Value |