Schema › Property › Services · energy Schema Page 39d9 Generated 2026-05-17 DAMA · Data Modeling & Design
Surveys · services · electricity, gas/oil, heating, water-heating 77 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| Electricity : "electricity"
Services ||--o| GasOil : "gasOil"
Services ||--o| Heating : "heating"
Services ||--o| WaterHeating : "waterHeating"
Electricity ||--o{ Photo : "photos"
GasOil ||--o{ Photo : "photos"
Heating ||--o{ Photo : "photos"
WaterHeating ||--o{ Photo : "photos"
Transaction {
}
PropertyPack {
}
Survey {
}
Services {
}
Electricity {
string additionalFeatures "additionalFeatures"
string advisories "advisories"
string condition "condition"
string consumerUnit "consumerUnit"
string cutOffDevices "cutOffDevices"
string defectDetail "defectDetail"
string defects "defects"
boolean defectsPresent "defectsPresent"
string description "description"
string inspectionLimitations "inspectionLimitations"
string meter "meter"
string notes "notes"
string restrictions "restrictions"
string supplementary "supplementary"
string testCertificate "testCertificate"
string visibility "visibility"
string wiring "wiring"
}
Photo {
string description "description"
integer photoId "photoId"
boolean report "report"
}
GasOil {
string advisories "advisories"
string condition "condition"
string defectDetail "defectDetail"
string defects "defects"
boolean defectsPresent "defectsPresent"
string description "description"
string inspectionLimitations "inspectionLimitations"
string meter "meter"
string notes "notes"
string privateGas "privateGas"
string restrictions "restrictions"
string tankInside "tankInside"
string tankLocation "tankLocation"
string tankOutside "tankOutside"
string tankType "tankType"
string testCertificate "testCertificate"
string visibility "visibility"
}
Heating {
string advisories "advisories"
string condition "condition"
string controls "controls"
string defectDetail "defectDetail"
string defects "defects"
boolean defectsPresent "defectsPresent"
string description "description"
string emitter "emitter"
string extent "extent"
string inspectionLimitations "inspectionLimitations"
string notes "notes"
string otherFeatures "otherFeatures"
string pipework "pipework"
string restrictions "restrictions"
string source "source"
string testCertificate "testCertificate"
string visibility "visibility"
}
WaterHeating {
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 pipework "pipework"
string primarySource "primarySource"
string restrictions "restrictions"
string storage "storage"
string supplementarySource "supplementarySource"
string visibility "visibility"
}
Physical model — every JSON object owned by this page is a node, every scalar field a row. 12 objects, 77 scalar fields. Generated from the schema walk; click any node to jump to its table. Services · electricity, gas/oil, heating, water-heating 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 additionalFeatures — stringEvidence additionalFeatures — — — advisories — stringEvidence advisories — — — condition — stringEvidence condition — — — consumerUnit — stringEvidence consumerUnit — — — cutOffDevices — stringEvidence cutOffDevices — — — defectDetail — stringEvidence defectDetail — — — defects — stringEvidence defects — — — defectsPresent — booleanEvidence defectsPresent — — — description — stringEvidence description — — — inspectionLimitations — stringEvidence inspectionLimitations — — — meter — stringEvidence meter — — — notes — stringEvidence notes — — — restrictions — stringEvidence restrictions — — — supplementary — stringEvidence supplementary — — — testCertificate — stringEvidence testCertificate — — — visibility — stringEvidence visibility — — — wiring — stringEvidence wiring — — —
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 — — — meter — stringEvidence meter — — — notes — stringEvidence notes — — — privateGas — stringEvidence privateGas — — — restrictions — stringEvidence restrictions — — — tankInside — stringEvidence tankInside — — — tankLocation — stringEvidence tankLocation — — — tankOutside — stringEvidence tankOutside — — — tankType — stringEvidence tankType — — — testCertificate — stringEvidence testCertificate — — — visibility — stringEvidence visibility — — —
Title Description Type Kind Field Required Overlays Affordance advisories — stringEvidence advisories — — — condition — stringEvidence condition — — — controls — stringEvidence controls — — — defectDetail — stringEvidence defectDetail — — — defects — stringEvidence defects — — — defectsPresent — booleanEvidence defectsPresent — — — description — stringEvidence description — — — emitter — stringEvidence emitter — — — extent — stringEvidence extent — — — inspectionLimitations — stringEvidence inspectionLimitations — — — notes — stringEvidence notes — — — otherFeatures — stringEvidence otherFeatures — — — pipework — stringEvidence pipework — — — restrictions — stringEvidence restrictions — — — source — stringEvidence source — — — testCertificate — stringEvidence testCertificate — — — 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 — — — inspectionLimitations — stringEvidence inspectionLimitations — — — notes — stringEvidence notes — — — pipework — stringEvidence pipework — — — primarySource — stringEvidence primarySource — — — restrictions — stringEvidence restrictions — — — storage — stringEvidence storage — — — supplementarySource — stringEvidence supplementarySource — — — visibility — stringEvidence visibility — — —
Title Description Type Kind Field Required Overlays Affordance description — stringEvidence description — — — photoId — integerEvidence photoId — — — report — booleanEvidence report — — —
Title Description Type Kind Field Required Overlays Affordance description — stringEvidence description — — — photoId — integerEvidence photoId — — — report — booleanEvidence report — — —
Title Description Type Kind Field Required Overlays Affordance description — stringEvidence description — — — photoId — integerEvidence photoId — — — report — booleanEvidence report — — —
Title Description Type Kind Field Required Overlays Affordance description — stringEvidence description — — — photoId — integerEvidence photoId — — — report — booleanEvidence report — — —
Comments