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.
- Skincare Clinic Management
- Data model
The tables behind Skincare Clinic Management
Skincare Clinic Management 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
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Patient access and consent
Patients.assigned clinician references People. Consents identifies Patient, Purpose, Version, signed at, expires at and Status. Care team assignments connects Patient and Clinician with access purpose and an effective period.
Professional authority
Clinical privileges references the Clinician and records privilege type, license number, issuing authority, verification evidence, effective from, effective to and Status. People.User connects the staff identity to Users.
Encounter coordination
Encounters references Patient and Clinician, retaining scheduled at, started at, ended at, visit type and Status.
Clinical documentation
Clinical notes references Encounter and Author; its Status and signed at identify the note lifecycle. Observations references Encounter and recorded by and retains Metric, Value, Unit and observed at.
Skin assessments and photos
Skin assessments references Encounter and Clinician, with Concern, assessment notes and photo consent. Treatment photos references Encounter and retains taken at, Image, image type and restricted access group.
Care follow-up
Care tasks references Patient and assigned to, with Task, due at, completed at and Status.
Service billing
Charges references Encounter, with service description, Amount and Status. Payments references Patient, with received at, Amount, Reference and Status.
Every table, by feature
- Patient access and consent6
- Encounter coordination6
- Clinical documentation7
- Skin assessments and photos8
- Care follow-up5
- Service billing4
- Patients
Patient identity and consent status for the clinic.
Linked to People - Consents
Purpose-specific patient consent records.
Linked to Patients - Care team assignments
Purpose-scoped patient access grants for clinicians.
Linked to Patients, People - Clinical privileges
Verified professional privileges and licence evidence per clinician.
Linked to People - People
Clinic staff, clinicians and administrators linked to platform users.
Linked to Users - Users
Users
Linked to Users
- Encounters
Scheduled and completed patient visits.
Linked to Patients, People - Patients
Patient identity and consent status for the clinic.
Linked to People - People
Clinic staff, clinicians and administrators linked to platform users.
Linked to Users - Consents
Purpose-specific patient consent records.
Linked to Patients - Clinical privileges
Verified professional privileges and licence evidence per clinician.
Linked to People - Care team assignments
Purpose-scoped patient access grants for clinicians.
Linked to Patients, People
- Clinical notes
Attributed clinical documentation for an encounter.
Linked to Encounters, People - Observations
Measured clinical values captured during an encounter.
Linked to Encounters, People - Encounters
Scheduled and completed patient visits.
Linked to Patients, People - People
Clinic staff, clinicians and administrators linked to platform users.
Linked to Users - Clinical privileges
Verified professional privileges and licence evidence per clinician.
Linked to People - Care team assignments
Purpose-scoped patient access grants for clinicians.
Linked to Patients, People - Consents
Purpose-specific patient consent records.
Linked to Patients
- Skin assessments
Specialty skin assessment captured against an encounter.
Linked to Encounters, People - Treatment photos
Before, after and follow-up clinical photographs.
Linked to Encounters - Encounters
Scheduled and completed patient visits.
Linked to Patients, People - Patients
Patient identity and consent status for the clinic.
Linked to People - People
Clinic staff, clinicians and administrators linked to platform users.
Linked to Users - Consents
Purpose-specific patient consent records.
Linked to Patients - Clinical privileges
Verified professional privileges and licence evidence per clinician.
Linked to People - Care team assignments
Purpose-scoped patient access grants for clinicians.
Linked to Patients, People
- Care tasks
Follow-up work assigned to a care team member.
Linked to Patients, People - Patients
Patient identity and consent status for the clinic.
Linked to People - People
Clinic staff, clinicians and administrators linked to platform users.
Linked to Users - Care team assignments
Purpose-scoped patient access grants for clinicians.
Linked to Patients, People - Clinical privileges
Verified professional privileges and licence evidence per clinician.
Linked to People
- Charges
Billable service charges raised from an encounter.
Linked to Encounters - Payments
Confirmed patient payments reconciled against billed charges.
Linked to Patients - Encounters
Scheduled and completed patient visits.
Linked to Patients, People - Patients
Patient identity and consent status for the clinic.
Linked to People
Keys and references
Preserve Id values and resolve every reference during import. Patients.patient number provides a readable patient identifier. Users.User is a self-reference requiring deliberate identity mapping; resolve the authenticated user through People.User for clinical attribution and assigned-task filters.
Patients.consent status summarizes consent; each action uses the relevant purpose-specific Consents record. Skin assessments.photo consent and treatment photos.restricted access group store text that must align with the authorized consent and access rules. People.Active stores text; agree its value conventions during setup.
Reconcile Charges through Encounters.Patient with Payments.Patient at patient level. Agree any more specific allocation with the connected billing process. Verify professional, consent and payment evidence through their authorized processes before using imported records in operational actions.
Migration order
- Establish Users and People, preserving identity references and separating technical access from clinical authority.
- Load Patients with assigned clinician references, then Consents, clinical privileges and care team assignments with their evidence and effective dates.
- Load Encounters with the correct patient and clinician references and original event dates.
- Load clinical notes, Observations, skin assessments and treatment photos, preserving attribution and restricted file access.
- Load care tasks, Charges and Payments, retaining original state and evidence and preserving patient-level financial scope.
Set up Skincare Clinic Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.