Inpatient medication administration database
This medication administration ER diagram models the core records needed for an inpatient electronic medication administration record. A patient can have an admission, and an admission can receive many medication orders. Each order identifies a formulary medication, dose, route, and status. Individual administration records capture the time, administering nurse, and result.
Open it in the AI editor with a prompt pre-filled — keep what works, change what doesn't.
Scenario
An inpatient pharmacy workflow needs separate records for the patient stay, prescribed medication, order, and each administered dose.
Key decisions
- Admissions link patients to a unit and admission time.
- Medication NDC is unique in the formulary table.
- MedicationOrder carries dose, route, and status.
- Administration records each dose time and nurse identifier.
- One order can have many administrations.
When to reuse this
This model supports a basic eMAR design. Production medication systems need clinician identity, verification, allergy, interaction, and audit controls.
Frequently asked questions
Why record each administration separately?
What is an NDC?
Can a patient have several admissions?
Tweak it with chat, export PNG/SVG, or fork it for your own use case.