---
title: "family_prevalence"
description: "Summary information about the prevalence of a risk factor, problem or diagnosis in family members."
---

Summary information about the prevalence of a risk factor, problem or diagnosis in family members.

**Purpose.** To record information about the prevalence of an identified risk factor, problem or diagnosis in genetic and non-genetic family members.

## Source

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

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `description` | `text` | yes | Description | `/items[at0030]` |
| `genetic_predisposition` | `boolean` | yes | Genetic predisposition? | `/items[at0055]` |
| `inheritance_type`<br />`inheritance_type_code`<br />`inheritance_type_system`<br />`inheritance_type_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Inheritance type | `/items[at0056]` |

## Constraints

```sql
check ((inheritance_type_code is null and inheritance_type_system is null and inheritance_type_valueset_id is null) or (inheritance_type is not null and inheritance_type_code is not null and inheritance_type_system is not null and inheritance_type_valueset_id is not null))
```

## References

| Columns | Target | On delete |
|---|---|---|
| `inheritance_type_valueset_id, inheritance_type_code, inheritance_type_system, inheritance_type` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Referenced by

- [`family_history_per_problem_problem_details`](/docs/tables/family_history_per_problem_problem_details) via `family_prevalence_id`
- [`family_prevalence_affected_family`](/docs/tables/family_prevalence_affected_family) via `family_prevalence_id`
- [`health_risk_risk_factors_detail`](/docs/tables/health_risk_risk_factors_detail) via `family_prevalence_id`

## Child tables

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

### `family_prevalence_affected_family`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `family_prevalence_id` | `uuid` → [`family_prevalence`](/docs/tables/family_prevalence) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `relationship_degree`<br />`relationship_degree_code`<br />`relationship_degree_system`<br />`relationship_degree_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Relationship degree | `/items[at0031]/items[at0032]` |
| `relationship_group`<br />`relationship_group_code`<br />`relationship_group_system`<br />`relationship_group_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Relationship group | `/items[at0031]/items[at0057]` |
| `family_line`<br />`family_line_code`<br />`family_line_system`<br />`family_line_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Family line | `/items[at0031]/items[at0051]` |
| `biological_sex`<br />`biological_sex_code`<br />`biological_sex_system`<br />`biological_sex_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Biological sex | `/items[at0031]/items[at0033]` |
| `number_affected` | `integer` | yes | Number affected | `/items[at0031]/items[at0034]` |
| `number_eligible` | `integer` | yes | Number eligible | `/items[at0031]/items[at0054]` |

#### Constraints

```sql
check ((relationship_degree_code is null and relationship_degree_system is null and relationship_degree_valueset_id is null and relationship_degree is null) or (relationship_degree is not null and relationship_degree_code is not null and relationship_degree_system is not null and relationship_degree_valueset_id is not null))
check ((relationship_group_code is null and relationship_group_system is null and relationship_group_valueset_id is null) or (relationship_group is not null and relationship_group_code is not null and relationship_group_system is not null and relationship_group_valueset_id is not null))
check ((family_line_code is null and family_line_system is null and family_line_valueset_id is null and family_line is null) or (family_line is not null and family_line_code is not null and family_line_system is not null and family_line_valueset_id is not null))
check ((biological_sex_code is null and biological_sex_system is null and biological_sex_valueset_id is null and biological_sex is null) or (biological_sex is not null and biological_sex_code is not null and biological_sex_system is not null and biological_sex_valueset_id is not null))
check (number_affected is null or number_affected >= 0)
check (number_eligible is null or number_eligible >= 0)
```

#### Unique

- `family_prevalence_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `family_prevalence_id` | [`family_prevalence`](/docs/tables/family_prevalence) | cascade |
| `relationship_degree_valueset_id, relationship_degree_code, relationship_degree_system, relationship_degree` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `relationship_group_valueset_id, relationship_group_code, relationship_group_system, relationship_group` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `family_line_valueset_id, family_line_code, family_line_system, family_line` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `biological_sex_valueset_id, biological_sex_code, biological_sex_system, biological_sex` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-CLUSTER.family_prevalence.v1/biological_sex` | 3 |
| `org.openehr::openEHR-EHR-CLUSTER.family_prevalence.v1/family_line` | 2 |
| `org.openehr::openEHR-EHR-CLUSTER.family_prevalence.v1/relationship_degree` | 5 |

