SchemaPage 46d5Generated 2026-05-17DAMA · Data Modeling & Design
Infrastructure, energy, transport, planning
96 leaves100.0% Declaration0.0% Evidence0.0% Derivation3 in overlays0 with worked example
Entity relationships
---
config:
layout: elk
elk:
direction: DOWN
nodePlacementStrategy: BRANDES_KOEPF
mergeEdges: false
---
erDiagram
Transaction ||--o| PropertyPack : "propertyPack"
PropertyPack ||--o| NearbyFacilities : "nearbyFacilities"
PropertyPack ||--o| EnvironmentalIssues : "environmentalIssues"
EnvironmentalIssues ||--o| Infrastructure : "infrastructure"
EnvironmentalIssues ||--o| Energy : "energy"
EnvironmentalIssues ||--o| Transportation : "transportation"
EnvironmentalIssues ||--o| Planning : "planning"
EnvironmentalIssues ||--o| OtherEnvironmental : "otherEnvironmental"
Energy ||--o| EnergyRisk : "energyRisk"
EnergyRisk ||--o{ RiskSubcategorie : "riskSubcategories"
Infrastructure ||--o| InfrastructureRisk : "infrastructureRisk"
InfrastructureRisk ||--o{ RiskSubcategorie : "riskSubcategories"
Planning ||--o| PlanningRisk : "planningRisk"
PlanningRisk ||--o{ RiskSubcategorie : "riskSubcategories"
Transportation ||--o| TransportationRisk : "transportationRisk"
TransportationRisk ||--o{ RiskSubcategorie : "riskSubcategories"
NearbyFacilities ||--o{ School : "schools"
NearbyFacilities ||--o{ Transport : "transport"
NearbyFacilities ||--o{ HealthCare : "healthCare"
HealthCare ||--o| Contact : "contact"
HealthCare ||--o{ OpeningHour : "openingHours"
Contact ||--o| Address : "address"
School ||--o| Contact : "contact"
School ||--o| SchoolType : "schoolType"
Contact ||--o| Address : "address"
Transaction {
}
PropertyPack {
}
EnvironmentalIssues {
}
Energy {
}
EnergyRisk {
integer actionAlertRating "Action alert rating (1 is Green, 5 is Red)"
string datasetAttribution "Licensing, distribution and copyright information"
string recommendations "Recommendations"
string result "Result"
string riskIndicator "Is the property impacted?"
string summary "Summary of risk"
}
RiskSubcategorie {
integer actionAlertRating "Action alert rating (1 is Green, 5 is Red)"
string datasetAttribution "Licensing, distribution and copyright information"
string recommendations "Recommendations"
string result "Result"
string riskIndicator "Is action recommended?"
string subCategory "Risk sub-category name"
string summary "Summary of risk"
}
Infrastructure {
}
InfrastructureRisk {
integer actionAlertRating "Action alert rating (1 is Green, 5 is Red)"
string datasetAttribution "Licensing, distribution and copyright information"
string recommendations "Recommendations"
string result "Result"
string riskIndicator "Is the property impacted?"
string summary "Summary of risk"
}
OtherEnvironmental {
string riskIndicator "riskIndicator"
string summary "Please provide details. For example the level of air poll…"
}
Planning {
}
PlanningRisk {
integer actionAlertRating "Action alert rating (1 is Green, 5 is Red)"
string datasetAttribution "Licensing, distribution and copyright information"
string recommendations "Recommendations"
string result "Result"
string riskIndicator "Is the property impacted?"
string summary "Summary of risk"
}
Transportation {
}
TransportationRisk {
integer actionAlertRating "Action alert rating (1 is Green, 5 is Red)"
string datasetAttribution "Licensing, distribution and copyright information"
string recommendations "Recommendations"
string result "Result"
string riskIndicator "Is the property impacted?"
string summary "Summary of risk"
}
NearbyFacilities {
}
HealthCare {
string containsAccidentAndEmergencyFacility "containsAccidentAndEmergencyFacility"
number distanceInMiles "Approximate Distance in miles"
string name "Name"
string[] specialties "Specialties"
string typeOfHealthCare "Type of healthcare facility: hospital, dental surgery etc"
}
Contact {
string emailAddress "Email address"
string telephone "Telephone"
string website "Website Url"
}
Address {
string line1 "Address line 1"
string line2 "Address line 2"
string line3 "Address line 3"
string postcode "Postcode"
string town "Town"
}
OpeningHour {
string day "day"
string hours "hours"
}
School {
string ageRange "Age Range of student in format minimumAge-maximimAge"
number distanceInMiles "Distance in miles"
string name "Name"
string ofstedRating "ofstedRating"
string otherRating "Please describe the other rating"
integer pupils "Number of Pupils"
string religiousCharacter "Religious character of school, if any"
}
SchoolType {
object college "College"
object nursery "Nursery"
object primary "Primary"
object private "Private"
object secondary "Secondary"
}
Transport {
number distanceInMiles "Distance in miles"
number latitude "Latitude"
number longitude "Longitude"
string name "Name"
string transportType "Type of transport service"
}
Physical model — every JSON object owned by this page is a node, every scalar field a row. 26 objects, 96 scalar fields. Generated from the schema walk; click any node to jump to its table.
Comments