1 files changed, 11 insertions, 3 deletions
diff --git a/rvh/db/schema.rb b/rvh/db/schema.rb
index 1adcdb5..319f057 100644
--- a/rvh/db/schema.rb
+++ b/rvh/db/schema.rb
@@ -23,6 +23,7 @@ ActiveRecord::Schema.define(version: 2020_03_15_204511) do
   end
 
   create_table "beds", force: :cascade do |t|
+    t.string "bed_number"
     t.string "room_number"
     t.integer "care_centre_id", null: false
     t.integer "patient_id"
@@ -85,10 +86,14 @@ ActiveRecord::Schema.define(version: 2020_03_15_204511) do
 
   create_table "patients", force: :cascade do |t|
     t.integer "account_id", null: false
+    t.integer "physician_id", null: false
+    t.integer "referring_physician_id", null: false
     t.datetime "contacted_at", null: false
     t.datetime "created_at", precision: 6, null: false
     t.datetime "updated_at", precision: 6, null: false
     t.index ["account_id"], name: "index_patients_on_account_id", unique: true
+    t.index ["physician_id"], name: "index_patients_on_physician_id"
+    t.index ["referring_physician_id"], name: "index_patients_on_referring_physician_id"
   end
 
   create_table "shifts", force: :cascade do |t|
@@ -103,15 +108,16 @@ ActiveRecord::Schema.define(version: 2020_03_15_204511) do
   end
 
   create_table "treatments", force: :cascade do |t|
-    t.integer "employee_id", null: false
+    t.integer "physician_id", null: false
     t.integer "patient_id", null: false
     t.string "name", null: false
+    t.string "number", null: false
     t.datetime "occurred_at", null: false
     t.text "results"
     t.datetime "created_at", precision: 6, null: false
     t.datetime "updated_at", precision: 6, null: false
-    t.index ["employee_id"], name: "index_treatments_on_employee_id"
     t.index ["patient_id"], name: "index_treatments_on_patient_id"
+    t.index ["physician_id"], name: "index_treatments_on_physician_id"
   end
 
   create_table "visits", force: :cascade do |t|
@@ -139,10 +145,12 @@ ActiveRecord::Schema.define(version: 2020_03_15_204511) do
   add_foreign_key "employees", "accounts"
   add_foreign_key "employees", "laboratories"
   add_foreign_key "patients", "accounts"
+  add_foreign_key "patients", "physicians"
+  add_foreign_key "patients", "referring_physicians"
   add_foreign_key "shifts", "care_centres"
   add_foreign_key "shifts", "employees"
-  add_foreign_key "treatments", "employees"
   add_foreign_key "treatments", "patients"
+  add_foreign_key "treatments", "physicians"
   add_foreign_key "visits", "patients"
   add_foreign_key "volunteers", "accounts"
 end