The participants schema is quite confusing to me. Could you explain what each of the 3 fields are supposed to be?
I assume what you're trying to do is have a table for meals, a table for people, and then a participants table. In which case I would advise the fields to be:
https://github.com/facn2/The-Munching-VASS/blob/master/src/database/db_build.sql#L18-L22
The participants schema is quite confusing to me. Could you explain what each of the 3 fields are supposed to be?
I assume what you're trying to do is have a table for
meals
, a table forpeople
, and then aparticipants
table. In which case I would advise the fields to be:person_id
meal_id
If this is confusing ask me please!