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.
- Clinic + Pharmacy + Lab
- Data model
The tables behind Clinic + Pharmacy + Lab
Clinic + Pharmacy + Lab ships with 15 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
- 15
- Features
- 7, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Patient and team
Patients hold identity and assigned clinician; People connect clinic staff to Users; care team assignments record dated patient access.
Visit and evidence
Encounters connect patient and clinician to clinical notes, Observations, Specimens, pharmacy dispensations, and Charges.
Consent and authority
Consents belong to patients; clinical privileges belong to clinicians.
Follow-up and receipts
Care tasks belong to patients and assignees; Payments belong to patients.
Reference currency
Exchange rates stores effective currency rates independently of care records.
Every table, by feature
- Patients and care teams7
- Encounters and clinical evidence7
- Consent and clinical privileges6
- Follow-up care5
- Specimen processing4
- Pharmacy dispensations6
- Charges and payments4
- Shared and settings1
- Patients
Patient identity and consent status
Linked to People - People
Clinic staff and clinicians
Linked to Users - Users
Users
Linked to Users - Care team assignments
Care team access assignments
Linked to Patients, People - Encounters
Patient visits and care episodes
Linked to Patients, People - Consents
Purpose-specific patient consent
Linked to Patients - Payments
Patient payments received
Linked to Patients
- Encounters
Patient visits and care episodes
Linked to Patients, People - Patients
Patient identity and consent status
Linked to People - People
Clinic staff and clinicians
Linked to Users - Clinical notes
Attributed clinical documentation
Linked to Encounters, People - Observations
Measured clinical observations
Linked to Encounters, People - Specimens
Lab specimens and their processing state
Linked to Encounters - Pharmacy dispensations
Medication dispensations with lot and quantity
Linked to Encounters, People
- Consents
Purpose-specific patient consent
Linked to Patients - Patients
Patient identity and consent status
Linked to People - Clinical privileges
Verified clinician privileges
Linked to People - People
Clinic staff and clinicians
Linked to Users - Care team assignments
Care team access assignments
Linked to Patients, People - Encounters
Patient visits and care episodes
Linked to Patients, People
- Care tasks
Follow-up care tasks
Linked to Patients, People - Patients
Patient identity and consent status
Linked to People - People
Clinic staff and clinicians
Linked to Users - Users
Users
Linked to Users - Encounters
Patient visits and care episodes
Linked to Patients, People
- Specimens
Lab specimens and their processing state
Linked to Encounters - Encounters
Patient visits and care episodes
Linked to Patients, People - Patients
Patient identity and consent status
Linked to People - Care tasks
Follow-up care tasks
Linked to Patients, People
- Pharmacy dispensations
Medication dispensations with lot and quantity
Linked to Encounters, People - Encounters
Patient visits and care episodes
Linked to Patients, People - People
Clinic staff and clinicians
Linked to Users - Clinical privileges
Verified clinician privileges
Linked to People - Clinical notes
Attributed clinical documentation
Linked to Encounters, People - Observations
Measured clinical observations
Linked to Encounters, People
- Charges
Service charges for encounters
Linked to Encounters - Payments
Patient payments received
Linked to Patients - Encounters
Patient visits and care episodes
Linked to Patients, People - Patients
Patient identity and consent status
Linked to People
Keys and references
Patient references join encounters, consent, tasks, assignments, and payments to Patients. Encounter references join clinical evidence, specimens, dispensations, and charges to Encounters. People references identify clinicians, authors, recorders, task assignees, and dispensation authorizers. The People user link supports personal work views. Keep patient number, accession number, payment reference, and charge identity distinct: they identify different parts of the work.
Migration order
- Users and People. Confirm user links and staff identities.
- Patients. Bring in patient numbers, names, and assigned clinicians.
- Governance records. Load care-team assignments, consent, and clinician privileges with dates and evidence.
- Encounters. Link each care episode to its patient and clinician.
- Care evidence. Attach notes, observations, specimens, and dispensations to the right encounter.
- Follow-up and finance. Add patient tasks, encounter charges, and patient payments after checking their references.
Set up Clinic + Pharmacy + Lab your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.