OPDA Knowledge base
Schema Page 39d8 Generated 2026-05-17 DAMA · Data Modeling & Design

Surveys · outside · conservatory, joinery, other

73 leaves 0.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| Outside : "outside" Outside ||--o| ConservatoryPorches : "conservatoryPorches" Outside ||--o| OtherJoinery : "otherJoinery" Outside ||--o| Other : "other" ConservatoryPorches ||--o{ Photo : "photos" Other ||--o{ Photo : "photos" OtherJoinery ||--o{ Photo : "photos" Transaction { } PropertyPack { } Survey { } Outside { } ConservatoryPorches { string advisories "advisories" string condition "condition" boolean conservatory "conservatory" string conservatoryDefectDetail "conservatoryDefectDetail" boolean conservatoryDefects "conservatoryDefects" boolean conservatoryEconomic "conservatoryEconomic" string conservatoryFrame "conservatoryFrame" string conservatoryGlazing "conservatoryGlazing" string conservatoryHeating "conservatoryHeating" string conservatoryMovement "conservatoryMovement" string conservatoryMovementCause "conservatoryMovementCause" string conservatoryMovementStatus "conservatoryMovementStatus" string conservatoryRoof "conservatoryRoof" boolean conservatorySeparate "conservatorySeparate" boolean conservatoryStructural "conservatoryStructural" string conservatoryWall "conservatoryWall" string defectLocation "defectLocation" string defects "defects" string _more_ "+20 more — see table" } Photo { string description "description" integer photoId "photoId" boolean report "report" } Other { string advisories "advisories" string condition "condition" string defectDetail "defectDetail" string defects "defects" boolean defectsFlag "defectsFlag" string description "description" string fireSafety "fireSafety" string inspectionLimitations "inspectionLimitations" string notes "notes" string visibility "visibility" } OtherJoinery { string advisories "advisories" string bargeboardsDescription "bargeboardsDescription" string claddingDescription "claddingDescription" string condition "condition" string defects "defects" string description "description" string fasciaDescription "fasciaDescription" string features "features" string inspectionLimitations "inspectionLimitations" string issueDetail "issueDetail" string issueLocation "issueLocation" boolean issues "issues" string notes "notes" string restrictions "restrictions" string soffitsDescription "soffitsDescription" string visibility "visibility" }
Physical model — every JSON object owned by this page is a node, every scalar field a row. 10 objects, 73 scalar fields. Generated from the schema walk; click any node to jump to its table.

Object model

Outside · conservatory, joinery, other

Transaction

transaction (root)

No scalar fields on this object — pure container.

Property Pack

propertyPack

No scalar fields on this object — pure container.

Surveys[]

propertyPack.surveys[]

No scalar fields on this object — pure container.

Outside

propertyPack.surveys[].outside

No scalar fields on this object — pure container.

Conservatory Porches

propertyPack.surveys[].outside.conservatoryPorches
Title Description Type Kind Field Required Overlays Affordance
advisories string Evidence advisories
condition string Evidence condition
conservatory Boolean flag: conservatory. boolean Evidence conservatory
conservatoryDefectDetail string Evidence conservatoryDefectDetail
conservatoryDefects Boolean flag: conservatory defect. boolean Evidence conservatoryDefects
conservatoryEconomic Boolean flag: conservatory economic. boolean Evidence conservatoryEconomic
conservatoryFrame string Evidence conservatoryFrame
conservatoryGlazing string Evidence conservatoryGlazing
conservatoryHeating string Evidence conservatoryHeating
conservatoryMovement string Evidence conservatoryMovement
conservatoryMovementCause string Evidence conservatoryMovementCause
conservatoryMovementStatus string Evidence conservatoryMovementStatus
conservatoryRoof string Evidence conservatoryRoof
conservatorySeparate Boolean flag: conservatory separate. boolean Evidence conservatorySeparate
conservatoryStructural Boolean flag: conservatory structural. boolean Evidence conservatoryStructural
conservatoryWall string Evidence conservatoryWall
defectLocation string Evidence defectLocation
defects string Evidence defects
defectsFlag boolean Evidence defectsFlag
description string Evidence description
inspectionLimitations string Evidence inspectionLimitations
notes string Evidence notes
porch Boolean flag: porch. boolean Evidence porch
porchDefectDetail string Evidence porchDefectDetail
porchDefects Boolean flag: porch defect. boolean Evidence porchDefects
porchEconomic Boolean flag: porch economic. boolean Evidence porchEconomic
porchFlat string Evidence porchFlat
porchFrame string Evidence porchFrame
porchGlazing string Evidence porchGlazing
porchMovement string Evidence porchMovement
porchMovementCause string Evidence porchMovementCause
porchMovementStatus string Evidence porchMovementStatus
porchPitched string Evidence porchPitched
porchRoof string Evidence porchRoof
porchStructural Boolean flag: porch structural. boolean Evidence porchStructural
porchWall string Evidence porchWall
restrictions string Evidence restrictions
visibility string Evidence visibility

Other

propertyPack.surveys[].outside.other
Title Description Type Kind Field Required Overlays Affordance
advisories string Evidence advisories
condition string Evidence condition
defectDetail string Evidence defectDetail
defects string Evidence defects
defectsFlag Boolean flag: defect flag. boolean Evidence defectsFlag
description string Evidence description
fireSafety string Evidence fireSafety
inspectionLimitations string Evidence inspectionLimitations
notes string Evidence notes
visibility string Evidence visibility

Other Joinery

propertyPack.surveys[].outside.otherJoinery
Title Description Type Kind Field Required Overlays Affordance
advisories string Evidence advisories
bargeboardsDescription string Evidence bargeboardsDescription
claddingDescription string Evidence claddingDescription
condition string Evidence condition
defects string Evidence defects
description string Evidence description
fasciaDescription string Evidence fasciaDescription
features string Evidence features
inspectionLimitations string Evidence inspectionLimitations
issueDetail Whether sue detail. string Evidence issueDetail
issueLocation Whether sue location. string Evidence issueLocation
issues Whether sue. boolean Evidence issues
notes string Evidence notes
restrictions string Evidence restrictions
soffitsDescription string Evidence soffitsDescription
visibility string Evidence visibility

Photos[]

propertyPack.surveys[].outside.conservatoryPorches.photos[]
Title Description Type Kind Field Required Overlays Affordance
description string Evidence description
photoId integer Evidence photoId
report boolean Evidence report

Photos[]

propertyPack.surveys[].outside.other.photos[]
Title Description Type Kind Field Required Overlays Affordance
description string Evidence description
photoId integer Evidence photoId
report boolean Evidence report

Photos[]

propertyPack.surveys[].outside.otherJoinery.photos[]
Title Description Type Kind Field Required Overlays Affordance
description string Evidence description
photoId string Evidence photoId
report boolean Evidence report

Comments

Loading comments…