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.
- Cosmetic Surgery Practice
- Data model
The tables behind Cosmetic Surgery Practice
Cosmetic Surgery Practice 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
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Patients and access
Patients links to Consents and care team assignments. Team members connects to Users and holds the clinician identity used across records.
Visits and evidence
Consultations links a Patient and Clinician, then anchors clinical notes, Observations, pathology specimens, Prescriptions and Charges.
Care and receipts
Care tasks belongs to a Patient and assigned to team member. Payments belongs to a Patient. Exchange rates is a separate read-only effective rate record.
Every table, by feature
- Patients and consents4
- Consultations and visits5
- Clinical documentation4
- Care team and privileges5
- Procedure support4
- Follow-up and finance6
- Shared and settings1
- Patients
Patient identity and consent status
Linked to Team members - Consents
Purpose-specific patient consent
Linked to Patients - Care team assignments
Care team access assignments
Linked to Patients, Team members - Team members
Practice team members with their platform identity, role title and active state.
Linked to Users
- Consultations
Cosmetic-surgery consultations and procedure visits, with scheduling and completion state.
Linked to Patients, Team members - Patients
Patient identity and consent status
Linked to Team members - Team members
Practice team members with their platform identity, role title and active state.
Linked to Users - Clinical notes
Attributed clinical documentation
Linked to Consultations, Team members - Observations
Measured clinical observations
Linked to Consultations, Team members
- Clinical notes
Attributed clinical documentation
Linked to Consultations, Team members - Observations
Measured clinical observations
Linked to Consultations, Team members - Consultations
Cosmetic-surgery consultations and procedure visits, with scheduling and completion state.
Linked to Patients, Team members - Team members
Practice team members with their platform identity, role title and active state.
Linked to Users
- Care team assignments
Care team access assignments
Linked to Patients, Team members - Clinical privileges
Verified clinician privileges
Linked to Team members - Team members
Practice team members with their platform identity, role title and active state.
Linked to Users - Users
Users
Linked to Users - Patients
Patient identity and consent status
Linked to Team members
- Pathology specimens
Pathology specimens collected during procedures and their processing state.
Linked to Consultations - Prescriptions
Prescribed and dispensed medication recorded against a consultation.
Linked to Consultations, Team members - Consultations
Cosmetic-surgery consultations and procedure visits, with scheduling and completion state.
Linked to Patients, Team members - Team members
Practice team members with their platform identity, role title and active state.
Linked to Users
- Care tasks
Follow-up care tasks
Linked to Patients, Team members - Charges
Service charges for encounters
Linked to Consultations - Payments
Patient payments received
Linked to Patients - Consultations
Cosmetic-surgery consultations and procedure visits, with scheduling and completion state.
Linked to Patients, Team members - Patients
Patient identity and consent status
Linked to Team members - Team members
Practice team members with their platform identity, role title and active state.
Linked to Users
Keys and references
The Id fields identify most records. Patients.patient number is a separate patient-facing identifier. Consultation child records use Encounter references. Clinical notes.Author, Observations.recorded by and Prescriptions.authorized by point to team members. Team members.User points to Users. Check these references when importing records, especially where a patient has several consultations.
Migration order
- Import Users and team members so people can be referenced.
- Import Patients, clinical privileges and care team assignments with their clinician links.
- Import Consents and Consultations for the matched patients.
- Import clinical notes, Observations, pathology specimens, Prescriptions and Charges against the correct consultations.
- Import care tasks and Payments against the correct patients, then reconcile dates, amounts and statuses.
Set up Cosmetic Surgery Practice your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.