tobacco_smoking_summary

Summary or persistent information about the tobacco smoking habits of an individual.

Summary or persistent information about the tobacco smoking habits of an individual.

Purpose. To record summary information about the individual's pattern of smoking of tobacco and tobacco-containing products.

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 ((overall_years_of_smoking_magnitude is null and overall_years_of_smoking_units is null) or (overall_years_of_smoking_magnitude is not null and overall_years_of_smoking_units is not null))
check (overall_years_of_smoking_magnitude is null or (overall_years_of_smoking_units = 'a' and overall_years_of_smoking_magnitude >= 0))
check (smoking_index is null or smoking_index >= 0)
check (overall_pack_years is null or overall_pack_years >= 0)
check ((pack_definition_magnitude is null and pack_definition_units is null) or (pack_definition_magnitude is not null and pack_definition_units is not null))
check (pack_definition_magnitude is null or (pack_definition_units = 'g' and pack_definition_magnitude >= 0) or (pack_definition_units = '[oz_av]' and pack_definition_magnitude >= 0))

Unique

• form_block_id

References

Referenced by

• tobacco_smoking_summary_per_type via tobacco_smoking_summary_id

Indexes

• tobacco_smoking_summary_form_id_idx on form_id

Child tables

2 tables hang off tobacco_smoking_summary, one row per repetition.

tobacco_smoking_summary_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 ((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 (pack_years is null or pack_years >= 0)

Unique

• tobacco_smoking_summary_id, position

References

Referenced by

• tobacco_smoking_summary_per_type_per_episode via tobacco_smoking_summary_per_type_id

tobacco_smoking_summary_per_type_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 ((typical_use_units_magnitude is null and typical_use_units_units is null) or (typical_use_units_magnitude is not null and typical_use_units_units is not null))
check (typical_use_units_magnitude is null or (typical_use_units_units = '1/d' and typical_use_units_magnitude >= 0) or (typical_use_units_units = '1/wk' and typical_use_units_magnitude >= 0))
check ((typical_use_mass_magnitude is null and typical_use_mass_units is null) or (typical_use_mass_magnitude is not null and typical_use_mass_units is not null))
check (typical_use_mass_magnitude is null or (typical_use_mass_units = 'g/d' and typical_use_mass_magnitude >= 0) or (typical_use_mass_units = 'g/wk' and typical_use_mass_magnitude >= 0) or (typical_use_mass_units = '[oz_av]/d' and typical_use_mass_magnitude >= 0) or (typical_use_mass_units = '[oz_av]/wk' and typical_use_mass_magnitude >= 0))
check (number_of_quit_attempts is null or number_of_quit_attempts >= 0)

Unique

• tobacco_smoking_summary_per_type_id, position

References

Value sets