I’m wondering how to best setup some tables before getting into building out the rest of my doc. In our company we’ve got my department using Coda internally, for ourselves and no other teams right now. This means there are ~10 of us that will be users in Coda. We also often times need to include other teams in our projects but they won’t necessarily be using Coda or even getting a login due to us just needing the ability to track them on their involvement for our team but nothing past that. We hire contractors for a lot of these projects as well so again, they won’t need to be in Coda and will not receive logins but they will need to be tracked for us to aggregate a variety of data.
Additionally, we’ll have another table for projects where people can be assigned as the lead, support, and also contractors all as separate columns.
Our team (users) will almost always be the lead (with very few exceptions), but we will also often times be listed under support on the projects table. We also use Coda for other things, tasks, process automation, etc… so it’s important that we’re able to receive notifications.
But the catch for our team is that we can also be listed as Support on these projects with contractors and other employees that aren’t users in Coda.
Contractors can only be listed as contractors and other departments will only be listed as support.
The last piece of this is we’d like to be able to pull in some historical data whih would include some former employees which many were leads on these projects. So we can’t simply just make the “Leads” column a People/Users column as we’d have no way to reference the former employees.
Is the best way to approach this to have our department as it’s own table with each person as their own row? And a separate “people” table that would include contractors, former employees, and all other internal departments whom of which will not be coda users?
Thank you for any help!