summaryrefslogtreecommitdiff
path: root/assignments/final/module-2.puml
diff options
context:
space:
mode:
Diffstat (limited to 'assignments/final/module-2.puml')
-rw-r--r--assignments/final/module-2.puml17
1 files changed, 12 insertions, 5 deletions
diff --git a/assignments/final/module-2.puml b/assignments/final/module-2.puml
index e987a31..da483e7 100644
--- a/assignments/final/module-2.puml
+++ b/assignments/final/module-2.puml
@@ -19,17 +19,17 @@ Table(accounts, "accounts") {
Table(beds, "beds") {
primary_key(id)
- foreign_key(care_centre_id)
- foreign_key(patient_id)
bed_number
room_number
+ foreign_key(care_centre_id)
+ foreign_key(patient_id)
created_at
updated_at
}
Table(care_centres, "care_centres") {
primary_key(id)
- foreign_key(employee_id)
+ foreign_key(nurse_id)
name
location
created_at
@@ -39,7 +39,6 @@ Table(care_centres, "care_centres") {
Table(consumptions, "consumptions") {
primary_key(id)
foreign_key(patient_id)
- foreign_key(employee_id)
foreign_key(item_id)
consumed_at
quantity
@@ -98,7 +97,6 @@ Table(staff, "staff") {
Table(treatments, "treatments") {
primary_key(id)
- foreign_key(physician_id)
foreign_key(patient_id)
name
number
@@ -117,6 +115,14 @@ Table(visits, "visits") {
updated_at
}
+Table(volunteers, "volunteers") {
+ primary_key(id)
+ foreign_key(account_id)
+ skill
+ created_at
+ updated_at
+}
+
beds --> care_centres : "belongs to"
beds --> patients : "belongs to"
@@ -126,6 +132,7 @@ consumptions --> staff : "belongs to"
patients --> accounts : "belongs to"
patients --> staff : "belongs to"
+volunteers --> accounts : "belongs to"
shifts --> care_centres : "belongs to"
shifts --> staff : "belongs to"