smokeless_tobacco_summary

Summary or persistent information about smokeless tobacco use by an individual.

Summary or persistent information about smokeless tobacco use by an individual.

Purpose. To record summary or persistent information about smokeless tobacco use by an individual.

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_pack_years is null or overall_pack_years >= 0)
check ((overall_years_of_use_magnitude is null and overall_years_of_use_units is null) or (overall_years_of_use_magnitude is not null and overall_years_of_use_units is not null))
check (overall_years_of_use_magnitude is null or (overall_years_of_use_units = 'a' and overall_years_of_use_magnitude >= 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))

Unique

• form_block_id

References

Referenced by

• smokeless_tobacco_summary_per_type via smokeless_tobacco_summary_id

Indexes

• smokeless_tobacco_summary_form_id_idx on form_id

Child tables

2 tables hang off smokeless_tobacco_summary, one row per repetition.

smokeless_tobacco_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

• smokeless_tobacco_summary_id, position

References

Referenced by

• smokeless_tobacco_summary_per_type_per_episode via smokeless_tobacco_summary_per_type_id

smokeless_tobacco_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_magnitude is null and typical_use_units is null) or (typical_use_magnitude is not null and typical_use_units is not null))
check (typical_use_magnitude is null or (typical_use_units = 'g/d' and typical_use_magnitude >= 0) or (typical_use_units = 'g/wk' and typical_use_magnitude >= 0) or (typical_use_units = '[oz_av]/d') or (typical_use_units = '[oz_av]/wk'))
check ((typical_frequency_magnitude is null and typical_frequency_units is null) or (typical_frequency_magnitude is not null and typical_frequency_units is not null))
check (typical_frequency_magnitude is null or (typical_frequency_units = '1/d' and typical_frequency_magnitude >= 0) or (typical_frequency_units = '1/wk' and typical_frequency_magnitude >= 0))
check (number_of_quit_attempts is null or number_of_quit_attempts >= 0)

Unique

• smokeless_tobacco_summary_per_type_id, position

References

Value sets