Schema › Property › Outside · extras Schema Page 39d8 Generated 2026-05-17 DAMA · Data Modeling & Design
Surveys · outside · conservatory, joinery, other 73 leaves 0.0% Declaration 100.0% Evidence 0.0% Derivation 0 in overlays 0 with worked example
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| ConservatoryPorches : "conservatoryPorches"
Outside ||--o| OtherJoinery : "otherJoinery"
Outside ||--o| Other : "other"
ConservatoryPorches ||--o{ Photo : "photos"
Other ||--o{ Photo : "photos"
OtherJoinery ||--o{ Photo : "photos"
Transaction {
}
PropertyPack {
}
Survey {
}
Outside {
}
ConservatoryPorches {
string advisories "advisories"
string condition "condition"
boolean conservatory "conservatory"
string conservatoryDefectDetail "conservatoryDefectDetail"
boolean conservatoryDefects "conservatoryDefects"
boolean conservatoryEconomic "conservatoryEconomic"
string conservatoryFrame "conservatoryFrame"
string conservatoryGlazing "conservatoryGlazing"
string conservatoryHeating "conservatoryHeating"
string conservatoryMovement "conservatoryMovement"
string conservatoryMovementCause "conservatoryMovementCause"
string conservatoryMovementStatus "conservatoryMovementStatus"
string conservatoryRoof "conservatoryRoof"
boolean conservatorySeparate "conservatorySeparate"
boolean conservatoryStructural "conservatoryStructural"
string conservatoryWall "conservatoryWall"
string defectLocation "defectLocation"
string defects "defects"
string _more_ "+20 more — see table"
}
Photo {
string description "description"
integer photoId "photoId"
boolean report "report"
}
Other {
string advisories "advisories"
string condition "condition"
string defectDetail "defectDetail"
string defects "defects"
boolean defectsFlag "defectsFlag"
string description "description"
string fireSafety "fireSafety"
string inspectionLimitations "inspectionLimitations"
string notes "notes"
string visibility "visibility"
}
OtherJoinery {
string advisories "advisories"
string bargeboardsDescription "bargeboardsDescription"
string claddingDescription "claddingDescription"
string condition "condition"
string defects "defects"
string description "description"
string fasciaDescription "fasciaDescription"
string features "features"
string inspectionLimitations "inspectionLimitations"
string issueDetail "issueDetail"
string issueLocation "issueLocation"
boolean issues "issues"
string notes "notes"
string restrictions "restrictions"
string soffitsDescription "soffitsDescription"
string visibility "visibility"
}
Physical model — every JSON object owned by this page is a node, every scalar field a row. 10 objects, 73 scalar fields. Generated from the schema walk; click any node to jump to its table. No scalar fields on this object — pure container.
No scalar fields on this object — pure container.
No scalar fields on this object — pure container.
No scalar fields on this object — pure container.
Title Description Type Kind Field Required Overlays Affordance advisories — string Evidence advisories — — — condition — string Evidence condition — — — conservatory Boolean flag: conservatory. boolean Evidence conservatory — — — conservatoryDefectDetail — string Evidence conservatoryDefectDetail — — — conservatoryDefects Boolean flag: conservatory defect. boolean Evidence conservatoryDefects — — — conservatoryEconomic Boolean flag: conservatory economic. boolean Evidence conservatoryEconomic — — — conservatoryFrame — string Evidence conservatoryFrame — — — conservatoryGlazing — string Evidence conservatoryGlazing — — — conservatoryHeating — string Evidence conservatoryHeating — — — conservatoryMovement — string Evidence conservatoryMovement — — — conservatoryMovementCause — string Evidence conservatoryMovementCause — — — conservatoryMovementStatus — string Evidence conservatoryMovementStatus — — — conservatoryRoof — string Evidence conservatoryRoof — — — conservatorySeparate Boolean flag: conservatory separate. boolean Evidence conservatorySeparate — — — conservatoryStructural Boolean flag: conservatory structural. boolean Evidence conservatoryStructural — — — conservatoryWall — string Evidence conservatoryWall — — — defectLocation — string Evidence defectLocation — — — defects — string Evidence defects — — — defectsFlag — boolean Evidence defectsFlag — — — description — string Evidence description — — — inspectionLimitations — string Evidence inspectionLimitations — — — notes — string Evidence notes — — — porch Boolean flag: porch. boolean Evidence porch — — — porchDefectDetail — string Evidence porchDefectDetail — — — porchDefects Boolean flag: porch defect. boolean Evidence porchDefects — — — porchEconomic Boolean flag: porch economic. boolean Evidence porchEconomic — — — porchFlat — string Evidence porchFlat — — — porchFrame — string Evidence porchFrame — — — porchGlazing — string Evidence porchGlazing — — — porchMovement — string Evidence porchMovement — — — porchMovementCause — string Evidence porchMovementCause — — — porchMovementStatus — string Evidence porchMovementStatus — — — porchPitched — string Evidence porchPitched — — — porchRoof — string Evidence porchRoof — — — porchStructural Boolean flag: porch structural. boolean Evidence porchStructural — — — porchWall — string Evidence porchWall — — — restrictions — string Evidence restrictions — — — visibility — string Evidence visibility — — —
Title Description Type Kind Field Required Overlays Affordance advisories — string Evidence advisories — — — condition — string Evidence condition — — — defectDetail — string Evidence defectDetail — — — defects — string Evidence defects — — — defectsFlag Boolean flag: defect flag. boolean Evidence defectsFlag — — — description — string Evidence description — — — fireSafety — string Evidence fireSafety — — — inspectionLimitations — string Evidence inspectionLimitations — — — notes — string Evidence notes — — — visibility — string Evidence visibility — — —
Title Description Type Kind Field Required Overlays Affordance advisories — string Evidence advisories — — — bargeboardsDescription — string Evidence bargeboardsDescription — — — claddingDescription — string Evidence claddingDescription — — — condition — string Evidence condition — — — defects — string Evidence defects — — — description — string Evidence description — — — fasciaDescription — string Evidence fasciaDescription — — — features — string Evidence features — — — inspectionLimitations — string Evidence inspectionLimitations — — — issueDetail Whether sue detail. string Evidence issueDetail — — — issueLocation Whether sue location. string Evidence issueLocation — — — issues Whether sue. boolean Evidence issues — — — notes — string Evidence notes — — — restrictions — string Evidence restrictions — — — soffitsDescription — string Evidence soffitsDescription — — — visibility — string Evidence visibility — — —
Title Description Type Kind Field Required Overlays Affordance description — string Evidence description — — — photoId — integer Evidence photoId — — — report — boolean Evidence report — — —
Title Description Type Kind Field Required Overlays Affordance description — string Evidence description — — — photoId — integer Evidence photoId — — — report — boolean Evidence report — — —
Title Description Type Kind Field Required Overlays Affordance description — string Evidence description — — — photoId — string Evidence photoId — — — report — boolean Evidence report — — —
Comments