Users relate to customer table through customer_user
Users that are customers have role of customer
Sales Reps relate to users of role customer through user_user
CSReps relate to their direct customers through users of role customer in user_user
CSReps relate to their SalesReps' customers through user_user first to users of role SalesRep then through those SalesReps to the SalesReps' customers
user_user has user1_roles and user2_roles which must be refreshed whenever users or roles are added or changed.
Users relate to customer table through customer_user Users that are customers have role of customer
Sales Reps relate to users of role customer through user_user CSReps relate to their direct customers through users of role customer in user_user CSReps relate to their SalesReps' customers through user_user first to users of role SalesRep then through those SalesReps to the SalesReps' customers
user_user has user1_roles and user2_roles which must be refreshed whenever users or roles are added or changed.