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.
- Veterinary Practice Mgmt
- Data model
The tables behind Veterinary Practice Mgmt
Veterinary Practice Mgmt ships with 14 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
- 14
- Features
- 7
- Change it
- Add fields and tables in Proto
How the model is organised
Animal Records
Animal patients captures the animal and owner details with operational record linked to Encounters.
Vaccinations
Animal vaccinations references the animal and veterinarian, retaining the vaccine lot and administration-to-due dates.
Encounters
Encounters references Patients and People, with appointment and care dates plus a visit lifecycle.
Clinical Documentation
Clinical notes and Observations reference their encounter and responsible People record.
Consent and Clinical Access
Consents references Patients; clinical privileges references People; care team assignments links patient and clinician within an effective interval.
Follow-up Care
Care tasks references Patients and its assigned People record, with due and completion dates.
Billing and Reporting
Charges references Encounters; Payments references Patients. Saved screens for charges awaiting invoice, confirmed payments, consents requiring action, encounters awaiting review, open care tasks and verified clinical privileges are filtered lists of these tables.
Every table, by feature
- Animal Records6
- Vaccinations6
- Encounters8
- Clinical Documentation6
- Consent and Clinical Access6
- Follow-up Care5
- Billing and Reporting4
- Animal patients
Animal patient register captured against an operational encounter.
Linked to Encounters - Encounters
Scheduled and completed visits for a patient with the responsible clinician.
Linked to Patients, People - Patients
Patient and client records with consent status and assigned clinician.
Linked to People - People
Practice staff and clinicians referenced by care operations records.
Linked to Users - Clinical privileges
Verified professional privileges held by a clinician.
Linked to People - Care team assignments
Care-team access assignments linking a clinician to a patient.
Linked to Patients, People
- Animal vaccinations
Vaccination events administered to an animal patient.
Linked to Animal patients, People - Animal patients
Animal patient register captured against an operational encounter.
Linked to Encounters - Encounters
Scheduled and completed visits for a patient with the responsible clinician.
Linked to Patients, People - People
Practice staff and clinicians referenced by care operations records.
Linked to Users - Clinical privileges
Verified professional privileges held by a clinician.
Linked to People - Care team assignments
Care-team access assignments linking a clinician to a patient.
Linked to Patients, People
- Encounters
Scheduled and completed visits for a patient with the responsible clinician.
Linked to Patients, People - Patients
Patient and client records with consent status and assigned clinician.
Linked to People - People
Practice staff and clinicians referenced by care operations records.
Linked to Users - Consents
Purpose-specific patient consent records with version and validity window.
Linked to Patients - Care team assignments
Care-team access assignments linking a clinician to a patient.
Linked to Patients, People - Clinical privileges
Verified professional privileges held by a clinician.
Linked to People - Clinical notes
Attributed clinical documentation for an encounter, draft through signed.
Linked to Encounters, People - Animal patients
Animal patient register captured against an operational encounter.
Linked to Encounters
- Clinical notes
Attributed clinical documentation for an encounter, draft through signed.
Linked to Encounters, People - Observations
Measured values captured during an encounter with unit, time and author.
Linked to Encounters, People - Encounters
Scheduled and completed visits for a patient with the responsible clinician.
Linked to Patients, People - People
Practice staff and clinicians referenced by care operations records.
Linked to Users - Clinical privileges
Verified professional privileges held by a clinician.
Linked to People - Care team assignments
Care-team access assignments linking a clinician to a patient.
Linked to Patients, People
- Consents
Purpose-specific patient consent records with version and validity window.
Linked to Patients - Clinical privileges
Verified professional privileges held by a clinician.
Linked to People - Care team assignments
Care-team access assignments linking a clinician to a patient.
Linked to Patients, People - Patients
Patient and client records with consent status and assigned clinician.
Linked to People - People
Practice staff and clinicians referenced by care operations records.
Linked to Users - Users
Users
Linked to Users
- Care tasks
Follow-up work assigned to a clinician for a patient.
Linked to Patients, People - Patients
Patient and client records with consent status and assigned clinician.
Linked to People - People
Practice staff and clinicians referenced by care operations records.
Linked to Users - Encounters
Scheduled and completed visits for a patient with the responsible clinician.
Linked to Patients, People - Care team assignments
Care-team access assignments linking a clinician to a patient.
Linked to Patients, People
- Charges
Service charges raised against an encounter for billing.
Linked to Encounters - Payments
Confirmed payments received against a patient account.
Linked to Patients - Encounters
Scheduled and completed visits for a patient with the responsible clinician.
Linked to Patients, People - Patients
Patient and client records with consent status and assigned clinician.
Linked to People
Keys and references
The model contains 14 tables. Its record tables generally include Id; Users includes its own User reference and Email. People.User links staff identity to Users. Validate those references before invoking workflows or resolving personal queues.
Animal patients captures animal identity, while Patients holds the patient/client context. Operational record reaches that context through Encounters.Patient. Animal vaccinations reaches the encounter through its Animal and that animal’s operational record. Preserve these reference paths during migration.
Payments references Patient. Follow Charges.Encounter to Encounters.Patient for patient-scope reconciliation. Check the underlying service charges, receipt records and date boundaries before investigating a difference.
Migration order
- Staff identity. Resolve Users and People, including People.User.
- Patient context. Prepare Patients and assigned clinician references.
- Access evidence. Load clinical privileges, care team assignments and purpose-specific Consents with their validity information.
- Encounter context. Prepare Encounters against the correct Patient and Clinician.
- Animal and clinical records. Resolve animal patients.operational record before animal vaccinations; then prepare clinical notes and Observations under their encounter context.
- Follow-up and money. Prepare care tasks, Charges and Payments after their patient, clinician and encounter references are established. Check report-source projections separately.
Set up Veterinary Practice Mgmt your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.