Company Users

[drewroberts]

There will be a many to many relationship with a pivot table for Company (#13) and User (TIPOFF/authorization#20) and it will be implemented similar to Teams in Laravel Spark. There should also be additional fields in the pivot table:

• timestamps
• creator
• updater
• primary_contact (boolean)

The primary contact should only have one relationship with a true value per Company.

There will be a unique key for company_id and user_id.

[wolfrednicolas]

@drewroberts

I created the pivot table with the values; however I don't understand what does it mean here

The primary contact should only have one relationship with a true value per Company.

here the migration

is this what its mean?

[drewroberts]

I think the best way to implement that is on the model's saving boot method, where we'll just update the table to mark the other Users for that Company to false for the primary_contact boolean field.