I saw your sample which demonstrates extending the aspnetusers table to establish a relationship to the opportunities table. I have a tenant table with tenantid as pk and that should be a foreign key in aspnetusers in order to establish a tenant (1) to aspnetusers (many) relationship. Would this scenario be possible? That means each time a new user will be created the corresponding tenantid has to be stored as well. The goal is that every user in our system must be clearly assigned to a tenant.
This tenantid is also a foreign key in all other tables so I would need a global variable to store the tenantid in order to make queries on tables.