These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Pharmacy Management System
- Data model
The tables behind Pharmacy Management System
Pharmacy Management System ships with 16 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 16
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Care coordination
Care requests connects the organization, owner and provider party to clinical evidence, record attachments, review decisions and operation receipts.
Prescriptions
Prescriptions holds headers; prescription lines connects each prescribed medication and its authorized units.
Dispensing
Dispense reviews links a request, prescription and lot. Dispensing lines links actual quantity to prescription lines and medication lots.
Stock
Medications identifies the drug; medication lots stores received stock; medication stock events stores signed movements.
People and parties
Organizations, team members, Users and provider organizations establish membership and counterparties.
Every table, by feature
- Care requests4
- Prescriptions3
- Dispense reviews4
- Dispensing4
- Medication stock3
- Review evidence5
- Shared and settings1
- Care requests
Patient care and dispensing request records
Linked to Organizations, Team members, Provider organizations - Provider organizations
Prescriber clinics and provider parties
Linked to Organizations - Organizations
Pharmacy organization master record
- Team members
Staff membership linking platform users to an organization role
Linked to Organizations, Users
- Prescriptions
Authoritative prescription headers
- Prescription lines
Prescribed medication lines
Linked to Prescriptions, Medications - Medications
Drug catalogue
- Dispense reviews
Pharmacist dispense review records
Linked to Care requests, Organizations, Prescriptions, Medication lots - Prescriptions
Authoritative prescription headers
- Medication lots
Received stock lots per medication
Linked to Medications - Care requests
Patient care and dispensing request records
Linked to Organizations, Team members, Provider organizations
- Dispensing lines
Dispensed quantities per prescription line and lot
Linked to Prescription lines, Medication lots - Prescription lines
Prescribed medication lines
Linked to Prescriptions, Medications - Medication lots
Received stock lots per medication
Linked to Medications - Dispense reviews
Pharmacist dispense review records
Linked to Care requests, Organizations, Prescriptions, Medication lots
- Medications
Drug catalogue
- Medication lots
Received stock lots per medication
Linked to Medications - Medication stock events
Signed stock ledger entries per lot
Linked to Medication lots
- Clinical evidence
Clinical evidence lines attached to a care request
Linked to Care requests - Record attachments
Files attached to a care request
Linked to Care requests, Team members - Review decisions
Independent reviewer decisions
Linked to Care requests, Team members - Operation receipts
Idempotent operation receipts for guarded actions
Linked to Care requests - Care requests
Patient care and dispensing request records
Linked to Organizations, Team members, Provider organizations
Keys and references
Use the prescription number and patient reference to match a source prescription. Keep the request record number and revision with every review. A dispensing line’s operation key, prescription line and lot identify the actual event. Stock events carry a lot and source identity. Review decisions retain the request revision and reviewer; operation receipts retain the expected revision and result.
Migration order
- Load Organizations, Users and team members, then provider organizations.
- Load Medications, Prescriptions and prescription lines.
- Load medication lots and receipt medication stock events.
- Load care requests, clinical evidence and record attachments.
- Load review decisions, dispense reviews, dispensing lines and operation receipts with their source links.
Set up Pharmacy Management System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.