Rename employee to more specific role

4 files changed, 16 insertions, 4 deletions

diff --git a/rvh/db/migrate/20200315180103_create_patients.rb b/rvh/db/migrate/20200315180103_create_patients.rb
index f20b23f..b08df6f 100644
--- a/rvh/db/migrate/20200315180103_create_patients.rb
+++ b/rvh/db/migrate/20200315180103_create_patients.rb
@@ -2,6 +2,8 @@ class CreatePatients < ActiveRecord::Migration[6.0]
   def change
     create_table :patients do |t|
       t.references :account, null: false, foreign_key: true, index: { unique: true }
+      t.references :physician, null: false, foreign_key: true
+      t.references :referring_physician, null: false, foreign_key: true
       t.datetime :contacted_at, null: false
 
       t.timestamps
diff --git a/rvh/db/migrate/20200315182108_create_beds.rb b/rvh/db/migrate/20200315182108_create_beds.rb
index 50607da..7e7e69e 100644
--- a/rvh/db/migrate/20200315182108_create_beds.rb
+++ b/rvh/db/migrate/20200315182108_create_beds.rb
@@ -1,6 +1,7 @@
 class CreateBeds < ActiveRecord::Migration[6.0]
   def change
     create_table :beds do |t|
+      t.string :bed_number
       t.string :room_number
       t.references :care_centre, null: false, foreign_key: true
       t.references :patient, null: true, foreign_key: true
diff --git a/rvh/db/migrate/20200315183345_create_treatments.rb b/rvh/db/migrate/20200315183345_create_treatments.rb
index 860f0d3..c6f1016 100644
--- a/rvh/db/migrate/20200315183345_create_treatments.rb
+++ b/rvh/db/migrate/20200315183345_create_treatments.rb
@@ -1,9 +1,10 @@
 class CreateTreatments < ActiveRecord::Migration[6.0]
   def change
     create_table :treatments do |t|
-      t.references :employee, null: false, foreign_key: true
+      t.references :physician, null: false, foreign_key: true
       t.references :patient, null: false, foreign_key: true
       t.string :name, null: false
+      t.string :number, null: false
       t.datetime :occurred_at, null: false
       t.text :results
 
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