Schema reference / Tables / view MDX source

housing_record

Details about a single home or other residential setting of an individual during a specified period of time.

Purpose. To record details about a single home or other residential setting of an individual during a specified period of time.

Source

Model	Leg	Role
`openEHR-EHR-CLUSTER.housing_record.v1`	openEHR	defines this table

Columns

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`name_label`	`text`	yes	Name/label	`/items[at0005]`
`description`	`text`	yes	Description	`/items[at0016]`
`date_commenced`	`timestamptz`	yes	Date commenced	`/items[at0007]`
`residential_setting` `residential_setting_code` `residential_setting_system` `residential_setting_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Residential setting	`/items[at0001]`
`tenure` `tenure_code` `tenure_system` `tenure_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Tenure	`/items[at0013]`
`date_ceased`	`timestamptz`	yes	Date ceased	`/items[at0008]`
`comment`	`text`	yes	Comment	`/items[at0014]`

Constraints

check ((residential_setting_code is null and residential_setting_system is null and residential_setting_valueset_id is null) or (residential_setting is not null and residential_setting_code is not null and residential_setting_system is not null and residential_setting_valueset_id is not null))
check ((tenure_code is null and tenure_system is null and tenure_valueset_id is null) or (tenure is not null and tenure_code is not null and tenure_system is not null and tenure_valueset_id is not null))

References

Columns	Target	On delete
`residential_setting_valueset_id, residential_setting_code, residential_setting_system, residential_setting`	`valueset_code`	restrict
`tenure_valueset_id, tenure_code, tenure_system, tenure`	`valueset_code`	restrict

Referenced by

housing_summary_housing_record via housing_record_id