search

hhm970 / mental-health-monitor-project

0 stars 0 forks source link

Create ERD #5

Closed hhm970 closed 2 weeks ago

hhm970 commented 3 weeks ago

Description

We want to create a database, but have no idea where to start! We need an ERD

Required Files

N/A

User Story

As an engineer, I need to create an ERD, so I can ensure that all tables in my database are appropriately related.

hhm970 commented 3 weeks ago

Each user will have a trigger table, to place their triggers in (ie. eating disorder)

For a given user and a given date, I've applied three main criteria:

User wellbeing will focus on physical health:

User mental health will focus on mental health:

User emotions will focus on emotional health:

hhm970 commented 1 week ago

To simplify the storage process, the triggers aspect will be removed, and it will implemented as an extension at the end of the project if there is time. It is a niche feature, and one that I don't think ultimately adds to the product that much overall.

The majority of the questions on the form will be made optional instead as an alternative.

hhm970 commented 1 week ago

ERD diagram included in the project repository.