alcohol_consumption_summary

Summary or persistent information about the typical alcohol consumption of an individual.

Summary or persistent information about the typical alcohol consumption of an individual.

Purpose. To record summary information about the individual's typical pattern of alcohol consumption.

Source

Columns

Constraints

check ((overall_status_code is null and overall_status_system is null and overall_status_valueset_id is null and overall_status is null) or (overall_status is not null and overall_status_code is not null and overall_status_system is not null and overall_status_valueset_id is not null))
check ((alcohol_unit_definition_mass_magnitude is null and alcohol_unit_definition_mass_units is null) or (alcohol_unit_definition_mass_magnitude is not null and alcohol_unit_definition_mass_units is not null))
check (alcohol_unit_definition_mass_magnitude is null or (alcohol_unit_definition_mass_units = 'g' and alcohol_unit_definition_mass_magnitude >= 0) or (alcohol_unit_definition_mass_units = '[oz_av]' and alcohol_unit_definition_mass_magnitude >= 0))

Unique

• form_block_id

References

Referenced by

• alcohol_consumption_summary_per_episode via alcohol_consumption_summary_id

Indexes

• alcohol_consumption_summary_form_id_idx on form_id

Child tables

2 tables hang off alcohol_consumption_summary, one row per repetition.

alcohol_consumption_summary_per_episode

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

Constraints

check ((status_code is null and status_system is null and status_valueset_id is null and status is null) or (status is not null and status_code is not null and status_system is not null and status_valueset_id is not null))
check ((pattern_code is null and pattern_system is null and pattern_valueset_id is null) or (pattern is not null and pattern_code is not null and pattern_system is not null and pattern_valueset_id is not null))
check ((binge_drinking_frequency_magnitude is null and binge_drinking_frequency_units is null) or (binge_drinking_frequency_magnitude is not null and binge_drinking_frequency_units is not null))
check (binge_drinking_frequency_magnitude is null or (binge_drinking_frequency_units = '1/wk' and binge_drinking_frequency_magnitude between 0 and 7) or (binge_drinking_frequency_units = '1/mo' and binge_drinking_frequency_magnitude between 0 and 31) or (binge_drinking_frequency_units = '1/a' and binge_drinking_frequency_magnitude between 0 and 365))
check ((alcohol_free_days_magnitude is null and alcohol_free_days_units is null) or (alcohol_free_days_magnitude is not null and alcohol_free_days_units is not null))
check (alcohol_free_days_magnitude is null or (alcohol_free_days_units = '1/wk' and alcohol_free_days_magnitude between 0 and 7) or (alcohol_free_days_units = '1/mo' and alcohol_free_days_magnitude between 0 and 31))
check ((typical_consumption_alcohol_units_magnitude is null and typical_consumption_alcohol_units_units is null) or (typical_consumption_alcohol_units_magnitude is not null and typical_consumption_alcohol_units_units is not null))
check (typical_consumption_alcohol_units_magnitude is null or (typical_consumption_alcohol_units_units = '1/d' and typical_consumption_alcohol_units_magnitude >= 0) or (typical_consumption_alcohol_units_units = '1/wk' and typical_consumption_alcohol_units_magnitude >= 0) or (typical_consumption_alcohol_units_units = '1/mo' and typical_consumption_alcohol_units_magnitude >= 0))
check ((typical_consumption_mass_magnitude is null and typical_consumption_mass_units is null) or (typical_consumption_mass_magnitude is not null and typical_consumption_mass_units is not null))
check (typical_consumption_mass_magnitude is null or (typical_consumption_mass_units = 'g/d' and typical_consumption_mass_magnitude >= 0) or (typical_consumption_mass_units = 'g/wk' and typical_consumption_mass_magnitude >= 0) or (typical_consumption_mass_units = 'g/mo' and typical_consumption_mass_magnitude >= 0))
check (number_of_quit_attempts is null or number_of_quit_attempts >= 0)

Unique

• alcohol_consumption_summary_id, position

References

Referenced by

• alcohol_consumption_summary_per_episode_per_type via alcohol_consumption_summary_per_episode_id

alcohol_consumption_summary_per_episode_per_type

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

Constraints

check ((type_code is null and type_system is null and type_valueset_id is null) or (type is not null and type_code is not null and type_system is not null and type_valueset_id is not null))
check ((typical_consumption_alcohol_units_magnitude is null and typical_consumption_alcohol_units_units is null) or (typical_consumption_alcohol_units_magnitude is not null and typical_consumption_alcohol_units_units is not null))
check (typical_consumption_alcohol_units_magnitude is null or (typical_consumption_alcohol_units_units = '1/d' and typical_consumption_alcohol_units_magnitude >= 0) or (typical_consumption_alcohol_units_units = '1/wk' and typical_consumption_alcohol_units_magnitude >= 0) or (typical_consumption_alcohol_units_units = '1/mo' and typical_consumption_alcohol_units_magnitude >= 0))
check ((typical_consumption_mass_magnitude is null and typical_consumption_mass_units is null) or (typical_consumption_mass_magnitude is not null and typical_consumption_mass_units is not null))
check (typical_consumption_mass_magnitude is null or (typical_consumption_mass_units = 'g/d' and typical_consumption_mass_magnitude >= 0) or (typical_consumption_mass_units = 'g/wk' and typical_consumption_mass_magnitude >= 0) or (typical_consumption_mass_units = 'g/mo' and typical_consumption_mass_magnitude >= 0))

Unique

• alcohol_consumption_summary_per_episode_id, position

References

Value sets