Schema › Property › Services · water Schema Page 39d10 Generated 2026-05-17 DAMA · Data Modeling & Design
Surveys · services · water, drainage, common services 48 leaves0.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| Services : "services"
Services ||--o| Water : "water"
Services ||--o| Drainage : "drainage"
Services ||--o| CommonServices : "commonServices"
CommonServices ||--o{ Photo : "photos"
Drainage ||--o{ Photo : "photos"
Water ||--o{ Photo : "photos"
Transaction {
}
PropertyPack {
}
Survey {
}
Services {
}
CommonServices {
string advisories "advisories"
string condition "condition"
string defectDetail "defectDetail"
string defects "defects"
boolean defectsPresent "defectsPresent"
string description "description"
string inspectionLimitations "inspectionLimitations"
string notes "notes"
string type "type"
string visibility "visibility"
}
Photo {
string description "description"
string photoId "photoId"
boolean report "report"
}
Drainage {
string advisories "advisories"
string condition "condition"
string defectDetail "defectDetail"
string defects "defects"
boolean defectsPresent "defectsPresent"
string description "description"
string features "features"
string inspectionLimitations "inspectionLimitations"
string location "location"
string notes "notes"
string privateSystem "privateSystem"
string restrictions "restrictions"
boolean runOff "runOff"
string system "system"
string visibility "visibility"
}
Water {
string advisories "advisories"
string condition "condition"
string defectDetail "defectDetail"
string defects "defects"
boolean defectsPresent "defectsPresent"
string description "description"
string distribution "distribution"
string inspectionLimitations "inspectionLimitations"
string notes "notes"
string restrictions "restrictions"
string stopTap "stopTap"
string storageTank "storageTank"
string supply "supply"
string visibility "visibility"
}
Physical model — every JSON object owned by this page is a node, every scalar field a row. 10 objects, 48 scalar fields. Generated from the schema walk; click any node to jump to its table. Services · water, drainage, common services 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 — stringEvidence advisories — — — condition — stringEvidence condition — — — defectDetail — stringEvidence defectDetail — — — defects — stringEvidence defects — — — defectsPresent — booleanEvidence defectsPresent — — — description — stringEvidence description — — — inspectionLimitations — stringEvidence inspectionLimitations — — — notes — stringEvidence notes — — — type — stringEvidence type — — — visibility — stringEvidence visibility — — —
Title Description Type Kind Field Required Overlays Affordance advisories — stringEvidence advisories — — — condition — stringEvidence condition — — — defectDetail — stringEvidence defectDetail — — — defects — stringEvidence defects — — — defectsPresent — booleanEvidence defectsPresent — — — description — stringEvidence description — — — features — stringEvidence features — — — inspectionLimitations — stringEvidence inspectionLimitations — — — location — stringEvidence location — — — notes — stringEvidence notes — — — privateSystem — stringEvidence privateSystem — — — restrictions — stringEvidence restrictions — — — runOff Boolean flag: run off. booleanEvidence runOff — — — system — stringEvidence system — — — visibility — stringEvidence visibility — — —
Title Description Type Kind Field Required Overlays Affordance advisories — stringEvidence advisories — — — condition — stringEvidence condition — — — defectDetail — stringEvidence defectDetail — — — defects — stringEvidence defects — — — defectsPresent Boolean flag: defect present. booleanEvidence defectsPresent — — — description — stringEvidence description — — — distribution — stringEvidence distribution — — — inspectionLimitations — stringEvidence inspectionLimitations — — — notes — stringEvidence notes — — — restrictions — stringEvidence restrictions — — — stopTap — stringEvidence stopTap — — — storageTank — stringEvidence storageTank — — — supply — stringEvidence supply — — — visibility — stringEvidence visibility — — —
Title Description Type Kind Field Required Overlays Affordance description — stringEvidence description — — — photoId — stringEvidence photoId — — — report — booleanEvidence report — — —
Title Description Type Kind Field Required Overlays Affordance description — stringEvidence description — — — photoId — stringEvidence photoId — — — report — booleanEvidence report — — —
Title Description Type Kind Field Required Overlays Affordance description — stringEvidence description — — — photoId — stringEvidence photoId — — — report — booleanEvidence report — — —
Comments