94 leaves0.0% Declaration100.0% Evidence0.0% Derivation0 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| LocalSearches : "localSearches"
LocalSearches ||--o| LocalAuthoritySearches : "localAuthoritySearches"
LocalAuthoritySearches ||--o| PlanningAndBuildingRegulations : "planningAndBuildingRegulations"
PlanningAndBuildingRegulations ||--o| DecisionsAndPendingApplications : "decisionsAndPendingApplications"
PlanningAndBuildingRegulations ||--o| DesignationsAndProposals : "designationsAndProposals"
DecisionsAndPendingApplications ||--o{ PlanningPermission : "planningPermission"
DecisionsAndPendingApplications ||--o{ ListedBuildingConsent : "listedBuildingConsent"
DecisionsAndPendingApplications ||--o{ ConservationAreaConsent : "conservationAreaConsent"
DecisionsAndPendingApplications ||--o{ LawfulnessOfExistingUse : "lawfulnessOfExistingUse"
DecisionsAndPendingApplications ||--o{ CertificateOfLawfulnessOfProposedUse : "certificateOfLawfulnessOfProposedUse"
DecisionsAndPendingApplications ||--o{ LawfulnessOfProposedListedWork : "lawfulnessOfProposedListedWorks"
DecisionsAndPendingApplications ||--o{ HeritagePartnershipAgreement : "heritagePartnershipAgreement"
DecisionsAndPendingApplications ||--o{ ListedBuildingConsentOrder : "listedBuildingConsentOrder"
DecisionsAndPendingApplications ||--o{ LocalListedBuildingConsentOrder : "localListedBuildingConsentOrder"
DecisionsAndPendingApplications ||--o{ BuildingRegulationsApproval : "buildingRegulationsApproval"
DecisionsAndPendingApplications ||--o{ BuildingRegulationsCompletion : "buildingRegulationsCompletion"
DecisionsAndPendingApplications ||--o{ BuildingRegulationsSelfCertification : "buildingRegulationsSelfCertification"
DesignationsAndProposals ||--o{ Plan : "plans"
Plan ||--o{ Designation : "designations"
Transaction {
}
PropertyPack {
}
LocalSearches {
}
LocalAuthoritySearches {
}
PlanningAndBuildingRegulations {
}
DecisionsAndPendingApplications {
string buildingControlStartDate "The earliest date from which building control decisions w…"
string planningStartDate "The earliest date from which planning applications would …"
}
BuildingRegulationsApproval {
string applicationDate "On what date was the application made?"
string applicationType "What type of application was this?"
string decision "What decision was made?"
string decisionDate "When was the decision made?"
string description "Description of the application"
string isProposal "Is this a proposal?"
string refNumber "Reference number for the planning application"
}
BuildingRegulationsCompletion {
string applicationDate "On what date was the application made?"
string applicationType "What type of application was this?"
string decision "What decision was made?"
string decisionDate "When was the decision made?"
string description "Description of the application"
string isProposal "Is this a proposal?"
string refNumber "Reference number for the planning application"
}
BuildingRegulationsSelfCertification {
string applicationDate "On what date was the application made?"
string applicationType "What type of application was this?"
string decision "What decision was made?"
string decisionDate "When was the decision made?"
string description "Description of the application"
string isProposal "Is this a proposal?"
string refNumber "Reference number for the planning application"
}
CertificateOfLawfulnessOfProposedUse {
string applicationDate "On what date was the application made?"
string applicationType "What type of application was this?"
string decision "What decision was made?"
string decisionDate "When was the decision made?"
string description "Description of the application"
string isProposal "Is this a proposal?"
string refNumber "Reference number for the planning application"
}
ConservationAreaConsent {
string applicationDate "On what date was the application made?"
string applicationType "What type of application was this?"
string decision "What decision was made?"
string decisionDate "When was the decision made?"
string description "Description of the application"
string isProposal "Is this a proposal?"
string refNumber "Reference number for the planning application"
}
HeritagePartnershipAgreement {
string applicationDate "On what date was the application made?"
string applicationType "What type of application was this?"
string decision "What decision was made?"
string decisionDate "When was the decision made?"
string description "Description of the application"
string isProposal "Is this a proposal?"
string refNumber "Reference number for the planning application"
}
LawfulnessOfExistingUse {
string applicationDate "On what date was the application made?"
string applicationType "What type of application was this?"
string decision "What decision was made?"
string decisionDate "When was the decision made?"
string description "Description of the application"
string isProposal "Is this a proposal?"
string refNumber "Reference number for the planning application"
}
LawfulnessOfProposedListedWork {
string applicationDate "On what date was the application made?"
string applicationType "What type of application was this?"
string decision "What decision was made?"
string decisionDate "When was the decision made?"
string description "Description of the application"
string isProposal "Is this a proposal?"
string refNumber "Reference number for the planning application"
}
ListedBuildingConsentOrder {
string applicationDate "On what date was the application made?"
string applicationType "What type of application was this?"
string decision "What decision was made?"
string decisionDate "When was the decision made?"
string description "Description of the application"
string isProposal "Is this a proposal?"
string refNumber "Reference number for the planning application"
}
ListedBuildingConsent {
string applicationDate "On what date was the application made?"
string applicationType "What type of application was this?"
string decision "What decision was made?"
string decisionDate "When was the decision made?"
string description "Description of the application"
string isProposal "Is this a proposal?"
string refNumber "Reference number for the planning application"
}
LocalListedBuildingConsentOrder {
string applicationDate "On what date was the application made?"
string applicationType "What type of application was this?"
string decision "What decision was made?"
string decisionDate "When was the decision made?"
string description "Description of the application"
string isProposal "Is this a proposal?"
string refNumber "Reference number for the planning application"
}
PlanningPermission {
string address "Location of the property to which the application relates"
string applicationDate "On what date was the application made?"
string applicationType "What type of application was this?"
string decision "What decision was made?"
string decisionDate "When was the decision made?"
string description "Description of the application"
string isProposal "Is this a proposal?"
string refNumber "Reference number for the planning application"
string status "Application status"
string url "Link to application on council planning portal"
}
DesignationsAndProposals {
}
Plan {
string name "What is the name of the plan?"
string status "What is the current status of the plan?"
string statusDate "When did the plan move to this status?"
}
Designation {
string description "What is the description given for this designation?"
string designationType "What type of designation is this?"
}
Physical model — every JSON object owned by this page is a node, every scalar field a row. 21 objects, 94 scalar fields. Generated from the schema walk; click any node to jump to its table.
Object model
Parent containers — shown for reference; their own content lives in the sections below.
Comments
Loading comments…
Sign in to post a comment