SchemaPage 39bGenerated 2026-05-17DAMA · Data Modeling & Design
Condition
87 leaves100.0% Declaration0.0% Evidence0.0% Derivation87 in overlays23 with worked example
Entity relationships
---
config:
layout: elk
elk:
direction: DOWN
nodePlacementStrategy: BRANDES_KOEPF
mergeEdges: false
---
erDiagram
Transaction ||--o| PropertyPack : "propertyPack"
PropertyPack ||--o| AlterationsAndChanges : "alterationsAndChanges"
PropertyPack ||--o| ElectricalWorks : "electricalWorks"
AlterationsAndChanges ||--o| HasStructuralAlterations : "hasStructuralAlterations"
AlterationsAndChanges ||--o| ChangeOfUse : "changeOfUse"
AlterationsAndChanges ||--o| WindowReplacementsSince2002 : "windowReplacementsSince2002"
AlterationsAndChanges ||--o| HasAddedConservatory : "hasAddedConservatory"
AlterationsAndChanges ||--o| WorksUnfinished : "worksUnfinished"
AlterationsAndChanges ||--o| PlanningPermissionBreaches : "planningPermissionBreaches"
AlterationsAndChanges ||--o| UnresolvedPlanningIssues : "unresolvedPlanningIssues"
ChangeOfUse ||--o| BuildingRegApproval : "buildingRegApproval"
ChangeOfUse ||--o| PlanningPermission : "planningPermission"
ChangeOfUse ||--o| ListedBuildingConsent : "listedBuildingConsent"
ChangeOfUse ||--o| DeedRestrictionConsent : "deedRestrictionConsent"
HasAddedConservatory ||--o| BuildingRegApproval : "buildingRegApproval"
HasAddedConservatory ||--o| PlanningPermission : "planningPermission"
HasAddedConservatory ||--o| ListedBuildingConsent : "listedBuildingConsent"
HasAddedConservatory ||--o| DeedRestrictionConsent : "deedRestrictionConsent"
HasStructuralAlterations ||--o| BuildingRegApproval : "buildingRegApproval"
HasStructuralAlterations ||--o| PlanningPermission : "planningPermission"
HasStructuralAlterations ||--o| ListedBuildingConsent : "listedBuildingConsent"
HasStructuralAlterations ||--o| DeedRestrictionConsent : "deedRestrictionConsent"
WindowReplacementsSince2002 ||--o| BuildingRegApproval : "buildingRegApproval"
WindowReplacementsSince2002 ||--o| PlanningPermission : "planningPermission"
WindowReplacementsSince2002 ||--o| ListedBuildingConsent : "listedBuildingConsent"
WindowReplacementsSince2002 ||--o| DeedRestrictionConsent : "deedRestrictionConsent"
ElectricalWorks ||--o| TestedByQualifiedElectrician : "testedByQualifiedElectrician"
ElectricalWorks ||--o| ElectricalWorkSince2005 : "electricalWorkSince2005"
ElectricalWorkSince2005 ||--o| SuppliedCertificate : "suppliedCertificate"
Transaction {
}
PropertyPack {
}
AlterationsAndChanges {
}
ChangeOfUse {
string details "Please outline the nature of the work"
integer yearCompleted "What year was the change completed?"
string yesNo "yesNo"
}
BuildingRegApproval {
string attachments "Please provide a copy of the documents"
string details "Please outline the reasons why"
string yesNo "yesNo"
}
DeedRestrictionConsent {
string attachments "Please provide a copy of the documents"
string details "Please outline the reasons why"
string yesNo "yesNo"
}
ListedBuildingConsent {
string attachments "Please provide a copy of the documents"
string details "Please outline the reasons why"
string yesNo "yesNo"
}
PlanningPermission {
string attachments "Please provide a copy of the documents"
string details "Please outline the reasons why"
string yesNo "yesNo"
}
HasAddedConservatory {
string details "Confirm whether any walls were removed, an exterior quali…"
integer yearCompleted "What year was the installation completed?"
string yesNo "yesNo"
}
HasStructuralAlterations {
string details "Please give details including dates of all work undertaken"
string yesNo "yesNo"
}
PlanningPermissionBreaches {
string attachments "Attachments"
string details "Please give details"
string willingToInsure "Confirm whether you will pay for an insurance policy if t…"
string yesNo "yesNo"
}
UnresolvedPlanningIssues {
string attachments "Attachments"
string details "Please give details"
string willingToInsure "Confirm whether you will pay for an insurance policy if t…"
string yesNo "yesNo"
}
WindowReplacementsSince2002 {
string details "For each installation, please outline the nature of the w…"
integer yearCompleted "What year was the installation completed?"
string yesNo "yesNo"
}
WorksUnfinished {
string attachments "Attachments"
string details "Please provide details and explain why"
string yesNo "yesNo"
}
ElectricalWorks {
}
ElectricalWorkSince2005 {
string details "Provide details"
integer yearWorkCarriedOut "State the year the work was carried out"
string yesNo "yesNo"
}
SuppliedCertificate {
string attachments "Attachments"
string certificateType "certificateType"
}
TestedByQualifiedElectrician {
string attachments "Please upload the test certificate."
integer yearTested "State the year they were last tested"
string yesNo "yesNo"
}
Physical model — every JSON object owned by this page is a node, every scalar field a row. 30 objects, 87 scalar fields. Generated from the schema walk; click any node to jump to its table.
Confirm whether any walls were removed, an exterior quality door separates the conservatory from the main building and, since the conservatory was added, has any replacement or refurbishment of the roof been undertaken that reduces the glazed area of the roof?
Confirm whether you will pay for an insurance policy if the Local Authority still have power to enforce the breach. Your property lawyer can obtain a quote for you. (If you already have a policy please give it to your property lawyer and include details in Question 6 of Section B) [*Note: It will be a term of the insurance policy that the Local Authority is not contacted so if you have contacted the Local Authority the option of indemnity insurance will not be available.]
Confirm whether you will pay for an insurance policy if the Local Authority still have power to enforce the breach. Your property lawyer can obtain a quote for you. (If you already have a policy please give it to your property lawyer and include details in Question 6 of Section B) [*Note: It will be a term of the insurance policy that the Local Authority is not contacted so if you have contacted the Local Authority the option of indemnity insurance will not be available.]
Confirm whether you will pay for an insurance policy if the Local Authority still have power to enforce the breach. Your property lawyer can obtain a quote for you. (If you already have a policy please give it to your property lawyer and include detail in Question 6 of Section B) [*Note: It will be a term of the insurance policy that the Local Authority is not contacted so if you have contacted the Local Authority the option of indemnity insurance will not be available.]
Comments