If Doctors Were a Database Model

Ideal models for efficiency calculation of medical treatments. Please comment any changes you would make. This model allows most good calculations to be done for certain budgets.

Illness

Contains illnesses and related fields not elsewhere.

  • name
  • description

Symptom

Contains symptoms and descriptions and related fields not elsewhere.

  • name
  • description
  • mortality_rating

IllnessSymptomRelation

Symptoms for an illness and the probability of indication.

  • Illness
  • Symptom
  • probability_of_illness_causing

TreatmentGroup

Like the drug name etc.

  • name
  • description

Treatment

Contains treatments and related fields not found elsewhere will (different dosages and different durations for example are different treatments).

  • TreatmentGroup
  • name
  • description
  • cost

TreatmentSolution

Is a list of treatment(s) that are suggested for a specific illness, different combinations work for multiple illnesses for example. Include related fields such as probability of cure.

  • Treatments
  • Illnesses
  • probability_of_success

DiagnosableElement

Tests and their costs and related elements

  • name
  • description
  • cost

DiagnosableElementSolution

Combinations of element(s) that indicate a specific illness with a probability (you will have a different probability for a list with one test not done for example)

  • Illness
  • DiagnosableElements
  • probability_of_indication
  • description

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top