Metadata for all users of a Jetstream team (incl. owner)
Hello. I'm currently building something with Jetstream, with Teams enabled.
I want to store additional data about team members, like a work_anniversary date. The team_user pivot table seems to be a good place to store such data but with the way Jetstream manages team, the team owner is not in this table.
It feels weird to have a work_anniversary column in the team_user table and a work_anniversary column in the teams table (the one for the team owner identified by user_id in this table).
How would you handle this? Just add the same column in the 2 different tables? Create another pivot table including the team owner? I don't think modifying the Jetstream architecture and trying to add the team owner in the team_user is a good idea since a lot of methods rely on the fact that the team owner is not present in this table.
Thank you for your input on this matter!
Please or to participate in this conversation.