medication_detail

Details about a medication or component of a medication, including strength, form and details of any specific constituents.

Details about a medication or component of a medication, including strength, form and details of any specific constituents.

Purpose. To record details about a medication or component of a medication, including strength, form and details of any specific constituents.

Source

Columns

Constraints

check ((name_code is null and name_system is null and name_valueset_id is null) or (name is not null and name_code is not null and name_system is not null and name_valueset_id is not null))
check ((form_code is null and form_system is null and form_valueset_id is null) or (form is not null and form_code is not null and form_system is not null and form_valueset_id is not null))
check ((category_code is null and category_system is null and category_valueset_id is null) or (category is not null and category_code is not null and category_system is not null and category_valueset_id is not null))
check ((strength_presentation_strength_numerator_magnitude is null and strength_presentation_strength_numerator_units is null) or (strength_presentation_strength_numerator_magnitude is not null and strength_presentation_strength_numerator_units is not null))
check ((strength_presentation_strength_denominator_magnitude is null and strength_presentation_strength_denominator_units is null) or (strength_presentation_strength_denominator_magnitude is not null and strength_presentation_strength_denominator_units is not null))
check ((strength_concentration_magnitude is null and strength_concentration_units is null) or (strength_concentration_magnitude is not null and strength_concentration_units is not null))
check (batch_id_system is null or batch_id_value is not null)
check ((amount_magnitude is null and amount_units is null) or (amount_magnitude is not null and amount_units is not null))
check ((alternate_amount_magnitude is null and alternate_amount_units is null) or (alternate_amount_magnitude is not null and alternate_amount_units is not null))
check ((role_code is null and role_system is null and role_valueset_id is null) or (role is not null and role_code is not null and role_system is not null and role_valueset_id is not null))

References

Referenced by

• adverse_reaction_monitoring_substance_details via medication_detail_id
• medication via medication_details
• medication_detail_constituent via medication_detail_id
• medication_detail_constituent via constituent_id
• medication_order_medication_details via medication_detail_id
• medication_summary_episode_additional_details via medication_detail_id

Child tables

1 table hang off medication_detail, one row per repetition.

medication_detail_constituent

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

Unique

• medication_detail_id, position
• medication_detail_id, constituent_id

References

Indexes

• medication_detail_constituent_constituent_id_idx on constituent_id

Value sets