I am building an app for therapists to collect session data on clients
I have a the following relevant tables:
-Goals assigned to Client
I would like to make a form for Session Reports
All Tools are available for all Clients and with any session the therapists may use any number of the tools (i.e. of the 10 types of tools a therapist might only use 3 in one session and 5 the next). Displayed as an Enum?
As for Goals, specific goals are assigned to each client and the therapist might only work on some of the assigned goals and capture session specific information about that goal like number of tries and notes(i.e. of the 100 possible goals, only 20 are assigned to the client and in one session only 5 of those 20 are worked on. With those 5 the therapist records XX number of successes and enters notes for each of those five. Each day the therapist can work on any of the assigned goals. Over time the goals assigned can change)
Currently All I can think of is having to change my table layout (Columns) as goals are changed. I would like to avoid that.
I would like to run queries/reports/graphs against this data in the future.
I can’t help but think that this is a common need and that there is some common methodology name for it that I can google and educate myself.
Can anyone help point me in the right direction?
Thanks in advance