housing_summary

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

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`form_id`	`uuid` → `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]`

Columns	Target	On delete
`form_id`	`form`	cascade
`form_id, form_block_id`	`form_block`	cascade

1 table hang off housing_summary, one row per repetition.

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`	no	—	—
`position`	`integer`	no	Order of this row within its parent, from zero.	—
`housing_record_id`	`uuid`	no	Housing record	`/data[at0001]/items[at0009]`

Columns	Target	On delete
`housing_summary_id`	`housing_summary`	cascade
`housing_record_id`	`housing_record`	no action