Surveys · outside · conservatory, joinery, other
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"
}
Object model
Parent containers — shown for reference; their own content lives in the sections below.
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.
Outside · conservatory, joinery, other
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…
Sign in to post a comment