Surveys · outside · walls, windows, doors
Entity relationships
---
config:
layout: elk
elk:
direction: DOWN
nodePlacementStrategy: BRANDES_KOEPF
mergeEdges: false
---
erDiagram
Transaction ||--o| PropertyPack : "propertyPack"
PropertyPack ||--o{ Survey : "surveys"
Survey ||--o| Outside : "outside"
Outside ||--o| MainWalls : "mainWalls"
Outside ||--o| Windows : "windows"
Outside ||--o| OutsideDoors : "outsideDoors"
MainWalls ||--o{ Photo : "photos"
MainWalls ||--o| Extension1 : "extension1"
MainWalls ||--o| Extension2 : "extension2"
MainWalls ||--o| Extension3 : "extension3"
OutsideDoors ||--o{ Photo : "photos"
Windows ||--o{ Photo : "photos"
Transaction {
}
PropertyPack {
}
Survey {
}
Outside {
}
MainWalls {
string advice "advice"
string advisories "advisories"
string cladding "cladding"
string condition "condition"
string construction "construction"
string defects "defects"
string description "description"
string dpc "dpc"
string extensions "extensions"
string externalElevation "externalElevation"
string features "features"
boolean fireRisk "fireRisk"
string inspectionLimitations "inspectionLimitations"
string movementCause "movementCause"
string movementLocation "movementLocation"
string movementStatus "movementStatus"
string movementType "movementType"
string notes "notes"
string _more_ "+5 more — see table"
}
Extension1 {
string construction "construction"
string defectDescription "defectDescription"
boolean defects "defects"
string detail "detail"
string dpc "dpc"
string movementCause "movementCause"
string movementStatus "movementStatus"
string movementType "movementType"
}
Extension2 {
string construction "construction"
string defectDescription "defectDescription"
boolean defects "defects"
string detail "detail"
string dpc "dpc"
string movementCause "movementCause"
string movementStatus "movementStatus"
string movementType "movementType"
}
Extension3 {
string construction "construction"
string defectDescription "defectDescription"
boolean defects "defects"
string detail "detail"
string dpc "dpc"
string movementCause "movementCause"
string movementStatus "movementStatus"
string movementType "movementType"
}
Photo {
string description "description"
integer photoId "photoId"
boolean report "report"
}
OutsideDoors {
string advisories "advisories"
string condition "condition"
string defects "defects"
string description "description"
string glazingDefectDetails "glazingDefectDetails"
boolean glazingDefects "glazingDefects"
string glazingDescription "glazingDescription"
boolean glazingHeight "glazingHeight"
boolean glazingSafety "glazingSafety"
string glazingType "glazingType"
string inspectionLimitations "inspectionLimitations"
string notes "notes"
string restrictions "restrictions"
string visibility "visibility"
}
Windows {
string advisories "advisories"
string condition "condition"
string defects "defects"
string description "description"
string glazingDefectList "glazingDefectList"
boolean glazingDefects "glazingDefects"
string glazingDescription "glazingDescription"
boolean glazingHeight "glazingHeight"
boolean glazingSafety "glazingSafety"
string glazingType "glazingType"
string inspectionLimitations "inspectionLimitations"
string notes "notes"
string visibility "visibility"
string visibilityRestrictions "visibilityRestrictions"
}
Object model
Outside · walls, windows, doors
Transaction
transaction (root) No scalar fields on this object — pure container.
Property Pack
propertyPack No scalar fields on this object — pure container.
Surveys[]
propertyPack.surveys[] No scalar fields on this object — pure container.
Outside
propertyPack.surveys[].outside No scalar fields on this object — pure container.
Main Walls
propertyPack.surveys[].outside.mainWalls | Title | Description | Type | Kind | Field | Required | Overlays | Affordance |
|---|---|---|---|---|---|---|---|
| advice | — | string | Evidence | advice | — | — | — |
| advisories | — | string | Evidence | advisories | — | — | — |
| cladding | — | string | Evidence | cladding | — | — | — |
| condition | — | string | Evidence | condition | — | — | — |
| construction | — | string | Evidence | construction | — | — | — |
| defects | — | string | Evidence | defects | — | — | — |
| description | — | string | Evidence | description | — | — | — |
| dpc | — | string | Evidence | dpc | — | — | — |
| extensions | — | string | Evidence | extensions | — | — | — |
| externalElevation | — | string | Evidence | externalElevation | — | — | — |
| features | — | string | Evidence | features | — | — | — |
| fireRisk | Boolean flag: fire risk. | boolean | Evidence | fireRisk | — | — | — |
| inspectionLimitations | — | string | Evidence | inspectionLimitations | — | — | — |
| movementCause | — | string | Evidence | movementCause | — | — | — |
| movementLocation | — | string | Evidence | movementLocation | — | — | — |
| movementStatus | — | string | Evidence | movementStatus | — | — | — |
| movementType | — | string | Evidence | movementType | — | — | — |
| notes | — | string | Evidence | notes | — | — | — |
| otherDefects | — | boolean | Evidence | otherDefects | — | — | — |
| otherDefectsDescription | — | string | Evidence | otherDefectsDescription | — | — | — |
| restrictions | — | string | Evidence | restrictions | — | — | — |
| structuralMovement | — | boolean | Evidence | structuralMovement | — | — | — |
| visibility | — | string | Evidence | visibility | — | — | — |
Outside Doors
propertyPack.surveys[].outside.outsideDoors | Title | Description | Type | Kind | Field | Required | Overlays | Affordance |
|---|---|---|---|---|---|---|---|
| advisories | — | string | Evidence | advisories | — | — | — |
| condition | — | string | Evidence | condition | — | — | — |
| defects | — | string | Evidence | defects | — | — | — |
| description | — | string | Evidence | description | — | — | — |
| glazingDefectDetails | — | string | Evidence | glazingDefectDetails | — | — | — |
| glazingDefects | — | boolean | Evidence | glazingDefects | — | — | — |
| glazingDescription | — | string | Evidence | glazingDescription | — | — | — |
| glazingHeight | — | boolean | Evidence | glazingHeight | — | — | — |
| glazingSafety | — | boolean | Evidence | glazingSafety | — | — | — |
| glazingType | — | string | Evidence | glazingType | — | — | — |
| inspectionLimitations | — | string | Evidence | inspectionLimitations | — | — | — |
| notes | — | string | Evidence | notes | — | — | — |
| restrictions | — | string | Evidence | restrictions | — | — | — |
| visibility | — | string | Evidence | visibility | — | — | — |
Windows
propertyPack.surveys[].outside.windows | Title | Description | Type | Kind | Field | Required | Overlays | Affordance |
|---|---|---|---|---|---|---|---|
| advisories | — | string | Evidence | advisories | — | — | — |
| condition | — | string | Evidence | condition | — | — | — |
| defects | — | string | Evidence | defects | — | — | — |
| description | — | string | Evidence | description | — | — | — |
| glazingDefectList | — | string | Evidence | glazingDefectList | — | — | — |
| glazingDefects | Boolean flag: glazing defect. | boolean | Evidence | glazingDefects | — | — | — |
| glazingDescription | — | string | Evidence | glazingDescription | — | — | — |
| glazingHeight | Boolean flag: glazing height. | boolean | Evidence | glazingHeight | — | — | — |
| glazingSafety | Boolean flag: glazing safety. | boolean | Evidence | glazingSafety | — | — | — |
| glazingType | — | string | Evidence | glazingType | — | — | — |
| inspectionLimitations | — | string | Evidence | inspectionLimitations | — | — | — |
| notes | — | string | Evidence | notes | — | — | — |
| visibility | — | string | Evidence | visibility | — | — | — |
| visibilityRestrictions | — | string | Evidence | visibilityRestrictions | — | — | — |
Extension1
propertyPack.surveys[].outside.mainWalls.extension1 | Title | Description | Type | Kind | Field | Required | Overlays | Affordance |
|---|---|---|---|---|---|---|---|
| construction | — | string | Evidence | construction | — | — | — |
| defectDescription | — | string | Evidence | defectDescription | — | — | — |
| defects | — | boolean | Evidence | defects | — | — | — |
| detail | — | string | Evidence | detail | — | — | — |
| dpc | — | string | Evidence | dpc | — | — | — |
| movementCause | — | string | Evidence | movementCause | — | — | — |
| movementStatus | — | string | Evidence | movementStatus | — | — | — |
| movementType | — | string | Evidence | movementType | — | — | — |
Extension2
propertyPack.surveys[].outside.mainWalls.extension2 | Title | Description | Type | Kind | Field | Required | Overlays | Affordance |
|---|---|---|---|---|---|---|---|
| construction | — | string | Evidence | construction | — | — | — |
| defectDescription | — | string | Evidence | defectDescription | — | — | — |
| defects | — | boolean | Evidence | defects | — | — | — |
| detail | — | string | Evidence | detail | — | — | — |
| dpc | — | string | Evidence | dpc | — | — | — |
| movementCause | — | string | Evidence | movementCause | — | — | — |
| movementStatus | — | string | Evidence | movementStatus | — | — | — |
| movementType | — | string | Evidence | movementType | — | — | — |
Extension3
propertyPack.surveys[].outside.mainWalls.extension3 | Title | Description | Type | Kind | Field | Required | Overlays | Affordance |
|---|---|---|---|---|---|---|---|
| construction | — | string | Evidence | construction | — | — | — |
| defectDescription | — | string | Evidence | defectDescription | — | — | — |
| defects | — | boolean | Evidence | defects | — | — | — |
| detail | — | string | Evidence | detail | — | — | — |
| dpc | — | string | Evidence | dpc | — | — | — |
| movementCause | — | string | Evidence | movementCause | — | — | — |
| movementStatus | — | string | Evidence | movementStatus | — | — | — |
| movementType | — | string | Evidence | movementType | — | — | — |
Photos[]
propertyPack.surveys[].outside.mainWalls.photos[] | Title | Description | Type | Kind | Field | Required | Overlays | Affordance |
|---|---|---|---|---|---|---|---|
| description | — | string | Evidence | description | — | — | — |
| photoId | — | integer | Evidence | photoId | — | — | — |
| report | — | boolean | Evidence | report | — | — | — |
Photos[]
propertyPack.surveys[].outside.outsideDoors.photos[] | Title | Description | Type | Kind | Field | Required | Overlays | Affordance |
|---|---|---|---|---|---|---|---|
| description | — | string | Evidence | description | — | — | — |
| photoId | — | integer | Evidence | photoId | — | — | — |
| report | — | boolean | Evidence | report | — | — | — |
Photos[]
propertyPack.surveys[].outside.windows.photos[] | Title | Description | Type | Kind | Field | Required | Overlays | Affordance |
|---|---|---|---|---|---|---|---|
| description | — | string | Evidence | description | — | — | — |
| photoId | — | string | Evidence | photoId | — | — | — |
| report | — | boolean | Evidence | report | — | — | — |
Comments