1. Blood Bank Management
  2. Data model
Reference

The tables behind Blood Bank Management

Blood Bank Management 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

Donor registration

Donors stores patient number, donor name and assigned screener. Donations references Donors through Donor and team members through Screener, with scheduled at, started at and ended at for the visit.

Consent and care access

Donor consents and donor care assignments reference Donors. Professional credentials references team members through Professional. Team members links to Users through User.

Donation screening

Screening notes and laboratory tests reference Donations. Author and recorded by reference team members so the contributor remains identifiable.

Blood unit processing

Blood units references Donations and carries component type, accession number, collected at and Status.

Unit issues and follow-up

Unit issues references Donations and team members through authorized by. Donor follow ups references Donors and team members through assigned to.

Processing charges and payments

Processing charges references Donations. Payments references Donors. Exchange rates contains effective rate records for the app and remains read-only.

Every table, by feature

Donor registration

3 tablesAbout this feature
  • Donors

    Patient identity and consent status

    Linked to Team members
  • Donations

    Patient visits and care episodes

    Linked to Donors, Team members
  • Team members

    Clinic staff and clinicians

    Linked to Users

Donation screening

4 tablesAbout this feature
  • Screening notes

    Attributed clinical documentation

    Linked to Donations, Team members
  • Laboratory tests

    Measured clinical observations

    Linked to Donations, Team members
  • Donations

    Patient visits and care episodes

    Linked to Donors, Team members
  • Team members

    Clinic staff and clinicians

    Linked to Users

Blood unit processing

3 tablesAbout this feature
  • Blood units

    Lab specimens and their processing state

    Linked to Donations
  • Donations

    Patient visits and care episodes

    Linked to Donors, Team members
  • Laboratory tests

    Measured clinical observations

    Linked to Donations, Team members

Unit issues and follow-up

5 tablesAbout this feature
  • Unit issues

    Medication dispensations with lot and quantity

    Linked to Donations, Team members
  • Donor follow ups

    Follow-up care tasks

    Linked to Donors, Team members
  • Donations

    Patient visits and care episodes

    Linked to Donors, Team members
  • Donors

    Patient identity and consent status

    Linked to Team members
  • Team members

    Clinic staff and clinicians

    Linked to Users

Processing charges and payments

4 tablesAbout this feature
  • Processing charges

    Service charges for encounters

    Linked to Donations
  • Payments

    Patient payments received

    Linked to Donors
  • Donations

    Patient visits and care episodes

    Linked to Donors, Team members
  • Donors

    Patient identity and consent status

    Linked to Team members

Shared and settings

2 tables
  • Exchange rates

    Read-only effective exchange rates for this app.

  • Users

    Users

    Linked to Users

Keys and references

Most records carry Id; exchange rates uses ID. Donors.patient number, blood units.accession number and unit issues.lot number are operational identifiers to review during matching. Use the platform’s record references to retain the intended parent rather than assuming that a matching display name identifies the same donor or donation.

Users includes a self-reference through User. Inspect the account mapping before importing team members so Screener, Author, recorded by and assigned to identify the intended people. My Donor Follow-ups and My Unit Issues use that mapping to locate the signed-in team member’s records. Laboratory tests belongs to Donations; the reporting connection follows that reference.

Migration order

  1. Prepare Users and team members mappings, including the account references needed by the clinical team.
  2. Load Donors with the intended assigned screener references, then review identity matching.
  3. Load professional credentials, donor care assignments and donor consents with their effective dates and evidence attachments.
  4. Load Donations, then screening notes, laboratory tests, blood units, unit issues and processing charges against the resolved donation references.
  5. Load donor follow ups and Payments against Donors. Reconcile ownership, statuses and monetary amounts before opening the operating cycle.
  6. Review exchange rates as effective app data; agree any financial connection separately from donor and donation imports.

Set up Blood Bank Management your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started