summaryrefslogtreecommitdiff
path: root/assignments
diff options
context:
space:
mode:
authormo khan <mo.khan@gmail.com>2020-04-04 12:53:13 -0600
committermo khan <mo.khan@gmail.com>2020-04-04 12:53:13 -0600
commit1730da9bc12453bab4db6e04eb933b3e7c196da3 (patch)
treeefc4151267848525b96b9e07649d58c741fd1132 /assignments
parent224ac5fb4072c5a6ff0e7e997955c71d98c3bc96 (diff)
Titlecase table names 🤷
Diffstat (limited to 'assignments')
-rw-r--r--assignments/final/module-1.pngbin147762 -> 147708 bytes
-rw-r--r--assignments/final/module-1.puml2
-rw-r--r--assignments/final/module-2.pngbin61673 -> 45240 bytes
-rw-r--r--assignments/final/module-2.puml62
4 files changed, 28 insertions, 36 deletions
diff --git a/assignments/final/module-1.png b/assignments/final/module-1.png
index fa50980..901b0bc 100644
--- a/assignments/final/module-1.png
+++ b/assignments/final/module-1.png
Binary files differ
diff --git a/assignments/final/module-1.puml b/assignments/final/module-1.puml
index 2f82702..2958d94 100644
--- a/assignments/final/module-1.puml
+++ b/assignments/final/module-1.puml
@@ -123,7 +123,7 @@ consumptions }o--|| items
consumptions }o--|| patients
laboratories ||--|{ staff
patients }o--|| physicians
-qualifications ||--|{ staff
+qualifications }|--|| staff
staff ||--o{ hours_worked
treatments }o--|| patients
treatments }o--|| physicians
diff --git a/assignments/final/module-2.png b/assignments/final/module-2.png
index 3c49f23..3587402 100644
--- a/assignments/final/module-2.png
+++ b/assignments/final/module-2.png
Binary files differ
diff --git a/assignments/final/module-2.puml b/assignments/final/module-2.puml
index c1a0d93..ebb1125 100644
--- a/assignments/final/module-2.puml
+++ b/assignments/final/module-2.puml
@@ -6,7 +6,7 @@ hide methods
hide stereotypes
' entities
-Table(accounts, "accounts") {
+Table(accounts, "Account") {
primary_key(id)
name
address
@@ -15,7 +15,7 @@ Table(accounts, "accounts") {
pager_number
}
-Table(beds, "beds") {
+Table(beds, "Bed") {
primary_key(id)
foreign_key(care_centre_id)
foreign_key(patient_id)
@@ -23,14 +23,14 @@ Table(beds, "beds") {
room_number
}
-Table(care_centres, "care_centres") {
+Table(care_centres, "CareCentre") {
primary_key(id)
foreign_key(nurse_id)
name
location
}
-Table(consumptions, "consumptions") {
+Table(consumptions, "Consumption") {
primary_key(id)
foreign_key(patient_id)
foreign_key(item_id)
@@ -39,20 +39,20 @@ Table(consumptions, "consumptions") {
total_cost
}
-Table(items, "items") {
+Table(items, "Item") {
primary_key(id)
sku
description
unit_cost
}
-Table(laboratories, "laboratories") {
+Table(laboratories, "Laboratory") {
primary_key(id)
name
location
}
-Table(patients, "patients") {
+Table(patients, "Patient") {
primary_key(id)
foreign_key(account_id)
foreign_key(physician_id)
@@ -61,7 +61,7 @@ Table(patients, "patients") {
contacted_at
}
-Table(shifts, "shifts") {
+Table(hours_worked, "HoursWorked") {
primary_key(id)
foreign_key(care_centre_id)
foreign_key(employee_id)
@@ -69,7 +69,7 @@ Table(shifts, "shifts") {
ended_at
}
-Table(staff, "staff") {
+Table(staff, "Staff") {
primary_key(id)
foreign_key(account_id)
foreign_key(laboratory_id)
@@ -77,7 +77,7 @@ Table(staff, "staff") {
hired_at
}
-Table(treatments, "treatments") {
+Table(treatments, "Treatment") {
primary_key(id)
foreign_key(patient_id)
foreign_key(physician_id)
@@ -87,40 +87,32 @@ Table(treatments, "treatments") {
results
}
-Table(qualifications, "qualifications") {
+Table(qualifications, "Qualification") {
primary_key(id)
foreign_key(staff_id)
name
}
-Table(visits, "visits") {
+Table(visits, "Visit") {
primary_key(id)
foreign_key(patient_id)
scheduled_at
comments
}
-beds --> care_centres : "belongs to"
-beds --> patients : "belongs to"
-
-consumptions --> patients : "belongs to"
-consumptions --> items : "belongs to"
-consumptions --> staff : "belongs to"
-
-patients --> accounts : "belongs to"
-patients --> staff : "belongs to"
-
-qualifications --> staff : "belongs to"
-
-shifts --> care_centres : "belongs to"
-shifts --> staff : "belongs to"
-
-staff --> accounts : "belongs to"
-staff --> laboratories : "belongs to"
-
-treatments --> staff : "belongs to"
-treatments --> patients : "belongs to"
-
-visits --> patients : "belongs to"
-
+beds --> care_centres
+beds --> patients
+consumptions --> items
+consumptions --> patients
+consumptions --> staff
+hours_worked --> care_centres
+hours_worked --> staff
+patients --> accounts
+patients --> staff
+qualifications --> staff
+staff --> accounts
+staff --> laboratories
+treatments --> patients
+treatments --> staff
+visits --> patients
@enduml