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.
- Hospital Canteen Management
- Data model
The tables behind Hospital Canteen Management
Hospital Canteen Management ships with 12 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
- 12
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Service
Patients and Wards anchor meal orders. Meal plans hold dated ward-type rates.
Execution
Diet meal requests and kitchen tasks link back to meal orders; tasks also reference Wards and team members.
Finance
Meal lines, diet meal charges and payment evidence each reference meal orders.
Access
Team members links to Users; exchange rates provides effective rates.
Every table, by feature
- Meal orders3
- Patients and wards3
- Meal plans3
- Kitchen tasks4
- Diet meal requests3
- Charges and payments4
- Shared and settings2
- Meal orders
Patient-linked meal orders with a ward, service interval, meal count, rate and service status.
Linked to Patients, Wards - Patients
Patient names and optional contact information used on meal orders.
- Wards
Wards with a number, type, capacity and availability status.
- Patients
Patient names and optional contact information used on meal orders.
- Wards
Wards with a number, type, capacity and availability status.
- Meal orders
Patient-linked meal orders with a ward, service interval, meal count, rate and service status.
Linked to Patients, Wards
- Meal plans
Dated meal rates by ward type with a minimum meal count.
- Meal orders
Patient-linked meal orders with a ward, service interval, meal count, rate and service status.
Linked to Patients, Wards - Wards
Wards with a number, type, capacity and availability status.
- Kitchen tasks
Cleaning, maintenance and meal service tasks assigned to a team member for a ward and meal order.
Linked to Wards, Team members, Meal orders - Team members
Team members assigned to ward and meal service tasks.
Linked to Users - Wards
Wards with a number, type, capacity and availability status.
- Meal orders
Patient-linked meal orders with a ward, service interval, meal count, rate and service status.
Linked to Patients, Wards
- Diet meal requests
Service requests linked to a meal order, with a Standard or Special Diet label, date and meal count.
Linked to Meal orders - Meal orders
Patient-linked meal orders with a ward, service interval, meal count, rate and service status.
Linked to Patients, Wards - Patients
Patient names and optional contact information used on meal orders.
- Meal lines
Menu-item meal lines linked to an order, with draft, posted and voided states.
Linked to Meal orders - Diet meal charges
Charges linked to a meal order, with a ward label, charged date, amount and status.
Linked to Meal orders - Payment evidence
Payment evidence linked to a meal order, pending through confirmed or refunded.
Linked to Meal orders - Meal orders
Patient-linked meal orders with a ward, service interval, meal count, rate and service status.
Linked to Patients, Wards
Keys and references
The order’s reservation number is its human-readable identifier. Patient and Ward are required references on meal orders. The meal order reference joins every service request, meal line, linked charge, task and receipt to that order. Kitchen tasks also requires Ward and assigned to. These relationships let staff inspect the operational and financial history for one case.
Migration order
- Load Users and team members for staff assignment.
- Load Patients, Wards and meal plans for order intake.
- Load meal orders with their patient and ward references.
- Load diet meal requests and kitchen tasks against the accepted order set.
- Load meal lines, diet meal charges and payment evidence with their linked orders.
- Review exchange rates independently where rates are used.
Set up Hospital Canteen Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.