substance_use_summary

Summary or persistent information about typical use of a specific substance or class of substances that may harm an individual's health or social well-being.

Summary or persistent information about typical use of a specific substance or class of substances that may harm an individual's health or social well-being.

Purpose. To record summary or persistent information about the typical use of a specific substance or class of substances that may harm an individual's health or social well-being.

Source

Columns

Constraints

check ((substance_name_code is null and substance_name_system is null and substance_name_valueset_id is null) or (substance_name is not null and substance_name_code is not null and substance_name_system is not null and substance_name_valueset_id is not null))
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))

Unique

• form_block_id

References

Referenced by

• substance_use_summary_per_episode via substance_use_summary_id

Indexes

• substance_use_summary_form_id_idx on form_id

Child tables

1 table hang off substance_use_summary, one row per repetition.

substance_use_summary_per_episode

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

Constraints

check ((specific_substance_name_code is null and specific_substance_name_system is null and specific_substance_name_valueset_id is null) or (specific_substance_name is not null and specific_substance_name_code is not null and specific_substance_name_system is not null and specific_substance_name_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 ((pattern_coded_text_code is null and pattern_coded_text_system is null and pattern_coded_text_valueset_id is null) or (pattern_coded_text is not null and pattern_coded_text_code is not null and pattern_coded_text_system is not null and pattern_coded_text_valueset_id is not null))
check ((pattern_quantity_magnitude is null and pattern_quantity_units is null) or (pattern_quantity_magnitude is not null and pattern_quantity_units is not null))
check (pattern_quantity_magnitude is null or (pattern_quantity_units = '1/d' and pattern_quantity_magnitude >= 0) or (pattern_quantity_units = '1/wk' and pattern_quantity_magnitude >= 0) or (pattern_quantity_units = '1/mo' and pattern_quantity_magnitude >= 0) or (pattern_quantity_units = '1/a' and pattern_quantity_magnitude >= 0))
check (num_nonnulls(pattern_coded_text, pattern_quantity_magnitude) <= 1)
check ((typical_amount_magnitude is null and typical_amount_units is null) or (typical_amount_magnitude is not null and typical_amount_units is not null))
check (typical_amount_magnitude is null or (typical_amount_units = 'mg/d' and typical_amount_magnitude >= 0) or (typical_amount_units = 'g/d' and typical_amount_magnitude >= 0) or (typical_amount_units = 'mg/wk' and typical_amount_magnitude >= 0) or (typical_amount_units = 'g/wk' and typical_amount_magnitude >= 0) or (typical_amount_units = 'mg/mo' and typical_amount_magnitude >= 0) or (typical_amount_units = 'g/mo' and typical_amount_magnitude >= 0) or (typical_amount_units = 'ug/d' and typical_amount_magnitude >= 0) or (typical_amount_units = 'ug/wk' and typical_amount_magnitude >= 0) or (typical_amount_units = 'ug/mo' and typical_amount_magnitude >= 0))
check ((route_code is null and route_system is null and route_valueset_id is null) or (route is not null and route_code is not null and route_system is not null and route_valueset_id is not null))
check (number_of_quit_attempts is null or number_of_quit_attempts >= 0)

Unique

• substance_use_summary_id, position

References

Value sets