diff options
Diffstat (limited to 'assignments/final/module-2.puml')
| -rw-r--r-- | assignments/final/module-2.puml | 17 |
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" |
