medication

Any activity related to the planning, scheduling, prescription management, dispensing, administration, cessation and other use of a medication, vaccine, nutritional product or oth…

Any activity related to the planning, scheduling, prescription management, dispensing, administration, cessation and other use of a medication, vaccine, nutritional product or other therapeutic item.

Purpose. For recording details about any activity related to the planning, scheduling, prescription management, dispensing, administration, cessation and other use of a medication, vaccine, nutritional product or other therapeutic item.

Source

Columns

Constraints

check ((medication_item_code is null and medication_item_system is null and medication_item_valueset_id is null) or (medication_item is not null and medication_item_code is not null and medication_item_system is not null and medication_item_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 ((substitution_code is null and substitution_system is null and substitution_valueset_id is null and substitution is null) or (substitution is not null and substitution_code is not null and substitution_system is not null and substitution_valueset_id is not null))
check ((substitution_reason_code is null and substitution_reason_system is null and substitution_reason_valueset_id is null) or (substitution_reason is not null and substitution_reason_code is not null and substitution_reason_system is not null and substitution_reason_valueset_id is not null))
check ((administration_details_route_code is null and administration_details_route_system is null and administration_details_route_valueset_id is null) or (administration_details_route is not null and administration_details_route_code is not null and administration_details_route_system is not null and administration_details_route_valueset_id is not null))
check ((administration_details_body_site_code is null and administration_details_body_site_system is null and administration_details_body_site_valueset_id is null) or (administration_details_body_site is not null and administration_details_body_site_code is not null and administration_details_body_site_system is not null and administration_details_body_site_valueset_id is not null))
check (num_nonnulls(administration_details_structured_body_site_anatomical_location, administration_details_structured_body_site_anatomical_l_afc7f9, administration_details_structured_body_site_anatomical_l_009789) <= 1)
check ((administration_details_administration_method_code is null and administration_details_administration_method_system is null and administration_details_administration_method_valueset_id is null) or (administration_details_administration_method is not null and administration_details_administration_method_code is not null and administration_details_administration_method_system is not null and administration_details_administration_method_valueset_id is not null))
check ((patient_guidance_code is null and patient_guidance_system is null and patient_guidance_valueset_id is null) or (patient_guidance is not null and patient_guidance_code is not null and patient_guidance_system is not null and patient_guidance_valueset_id is not null))
check (order_id_system is null or order_id_value is not null)

Unique

• form_block_id

References

Referenced by

• medication_administration_details_administration_device via medication_id

Indexes

• medication_form_id_idx on form_id
• medication_medication_details_idx on medication_details
• medication_amount_idx on amount
• medication_administration_details_structured_body_site_a_ded596 on administration_details_structured_body_site_anatomical_location
• medication_administration_details_structured_body_site_a_deabec on administration_details_structured_body_site_anatomical_l_afc7f9
• medication_administration_details_structured_body_site_a_561f00 on administration_details_structured_body_site_anatomical_l_009789

Child tables

1 table hang off medication, one row per repetition.

medication_administration_details_administration_device

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

Unique

• medication_id, position
• medication_id, device_id

References

Indexes

• medication_administration_details_administration_device__f8a3a2 on device_id

Value sets