family_prevalence

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

Columns

Constraints

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

Referenced by

• family_history_per_problem_problem_details via family_prevalence_id
• family_prevalence_affected_family via family_prevalence_id
• 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.

Constraints

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

Value sets