medication_summary

Summary or persistent information about the use of a single medication or group of medications, especially where the pattern of use or cumulative dosage needs to be monitored.

Summary or persistent information about the use of a single medication or group of medications, especially where the pattern of use or cumulative dosage needs to be monitored.

Purpose. To record summary or persistent information about the use of a single medication or group or class of medications, especially where the pattern of use or cumulative dosage needs to be monitored.

Source

Columns

Constraints

check ((medication_name_code is null and medication_name_system is null and medication_name_valueset_id is null) or (medication_name is not null and medication_name_code is not null and medication_name_system is not null and medication_name_valueset_id is not null))
check ((clinical_indication_code is null and clinical_indication_system is null and clinical_indication_valueset_id is null) or (clinical_indication is not null and clinical_indication_code is not null and clinical_indication_system is not null and clinical_indication_valueset_id is not null))
check ((cumulative_dose_magnitude is null and cumulative_dose_units is null) or (cumulative_dose_magnitude is not null and cumulative_dose_units is not null))
check ((reason_for_cessation_code is null and reason_for_cessation_system is null and reason_for_cessation_valueset_id is null) or (reason_for_cessation is not null and reason_for_cessation_code is not null and reason_for_cessation_system is not null and reason_for_cessation_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• medication_summary_episode via medication_summary_id

Indexes

• medication_summary_form_id_idx on form_id

Child tables

2 tables hang off medication_summary, one row per repetition.

medication_summary_episode

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

Constraints

check ((episode_indication_code is null and episode_indication_system is null and episode_indication_valueset_id is null) or (episode_indication is not null and episode_indication_code is not null and episode_indication_system is not null and episode_indication_valueset_id is not null))
check ((therapeutic_intent_code is null and therapeutic_intent_system is null and therapeutic_intent_valueset_id is null) or (therapeutic_intent is not null and therapeutic_intent_code is not null and therapeutic_intent_system is not null and therapeutic_intent_valueset_id is not null))
check ((episode_amount_magnitude is null and episode_amount_units is null) or (episode_amount_magnitude is not null and episode_amount_units is not null))
check ((episode_reason_for_cessation_code is null and episode_reason_for_cessation_system is null and episode_reason_for_cessation_valueset_id is null) or (episode_reason_for_cessation is not null and episode_reason_for_cessation_code is not null and episode_reason_for_cessation_system is not null and episode_reason_for_cessation_valueset_id is not null))
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 ((therapeutic_response_code is null and therapeutic_response_system is null and therapeutic_response_valueset_id is null) or (therapeutic_response is not null and therapeutic_response_code is not null and therapeutic_response_system is not null and therapeutic_response_valueset_id is not null))

Unique

• medication_summary_id, position

References

Referenced by

• medication_summary_episode_additional_details via medication_summary_episode_id

medication_summary_episode_additional_details

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

Constraints

check (num_nonnulls(dosage_id, medication_detail_id, therapeutic_direction_id) = 1)

Unique

• medication_summary_episode_id, position

References

Indexes

• medication_summary_episode_additional_details_dosage_id_idx on dosage_id
• medication_summary_episode_additional_details_medication_dd8ed0 on medication_detail_id
• medication_summary_episode_additional_details_therapeuti_4e4551 on therapeutic_direction_id