From 1730da9bc12453bab4db6e04eb933b3e7c196da3 Mon Sep 17 00:00:00 2001 From: mo khan Date: Sat, 4 Apr 2020 12:53:13 -0600 Subject: Titlecase table names 🤷 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- assignments/final/module-1.png | Bin 147762 -> 147708 bytes assignments/final/module-1.puml | 2 +- assignments/final/module-2.png | Bin 61673 -> 45240 bytes assignments/final/module-2.puml | 62 +++++++++++++++++----------------------- 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 Binary files a/assignments/final/module-1.png and b/assignments/final/module-1.png 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 Binary files a/assignments/final/module-2.png and b/assignments/final/module-2.png 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 -- cgit v1.2.3