---
title: "housing_summary"
description: "Summary or persistent information about an individual's current and past housing or accommodation situation."
---

Summary or persistent information about an individual's current and past housing or accommodation situation.

**Purpose.** To record summary or persistent information about an individual's current and past housing or accommodation situation.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-EVALUATION.housing_summary.v1` | openEHR | defines this table |

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `form_id` | `uuid` → [`form`](/docs/tables/form) | no | The form this entry was recorded on. | — |
| `form_block_id` | `uuid` | yes | The block within the form, when the entry is bound to one. | — |
| `description` | `text` | yes | Description | `/data[at0001]/items[at0002]` |
| `comment` | `text` | yes | Comment | `/data[at0001]/items[at0005]` |
| `last_updated` | `timestamptz` | yes | Last updated | `/protocol[at0012]/items[at0013]` |

## Unique

- `form_block_id`

## References

| Columns | Target | On delete |
|---|---|---|
| `form_id` | [`form`](/docs/tables/form) | cascade |
| `form_id, form_block_id` | [`form_block`](/docs/tables/form_block) | cascade |

## Referenced by

- [`housing_summary_housing_record`](/docs/tables/housing_summary_housing_record) via `housing_summary_id`

## Indexes

- `housing_summary_form_id_idx` on `form_id`

## Child tables

1 table hang off `housing_summary`, one row per repetition.

### `housing_summary_housing_record`

Child table — one row per repetition, deleted with its parent.

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `housing_summary_id` | `uuid` → [`housing_summary`](/docs/tables/housing_summary) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `housing_record_id` | `uuid` | no | Housing record | `/data[at0001]/items[at0009]` |

#### Unique

- `housing_summary_id, position`
- `housing_summary_id, housing_record_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `housing_summary_id` | [`housing_summary`](/docs/tables/housing_summary) | cascade |
| `housing_record_id` | [`housing_record`](/docs/tables/housing_record) | no action |

#### Indexes

- `housing_summary_housing_record_housing_record_id_idx` on `housing_record_id`