I'm creating a project management platform and need some help in terms of organising tables.
I have three different tables:
Users - containing private information
Project - containing projects we have
Project participants - containing a row for project name, user id, and custom fields (columns 1,2,3) which contains information about that user for the project only. For example project user id or if they are participating in the project currently.
I'm having some hard time as we use Softr for this development, and I would like to be able to allow a manager to add or remove participants to a project via the project participants table. That is at least the workflow I have now, but might be that it needs a full redesign.
Anyone who can help on suggestions and best practises?