search

Gigih3-0-FS-SDG-3-B / carepal

0 stars 0 forks source link

Database ERD Draft Design #1

Open FelixIG15 opened 1 year ago

FelixIG15 commented 1 year ago

https://dbdiagram.io

Afterwards we will discuss and probably choose one or get best of both worlds.

Dewasurya16 commented 1 year ago

Image

For ERD I made 4 tables, namely tables for elderly, employees, services and orders along with the links [https://drawsql.app/teams/goto/diagrams/lansia]

FelixIG15 commented 12 months ago

Image

This is mine, we haven't set the kind of services that we have, the ERD assumes that we have various services, and one order could include multiple services. Each services needs to be dynamically priced, therefore it needs a table of service_rates.

Each order have a journey which is like the stages.

  1. Processing
  2. Waiting for confirmation from the caregiver/admin
  3. Scheduled/Confirmed
  4. Caregiver on the way
  5. Ongoing
  6. Finished

https://dbdiagram.io/d/651317a0ffbf5169f08b5729

FelixIG15 commented 12 months ago

Image