plan_role

Roles assigned to the plan sponsor, solution, or individual login for a plan.

Foreign Keys:

• login_id => login.login_id
• plan_id => plan.plan_id
• plan_sponsor_id => plan_sponsor.plan_sponsor_id
• role_id => role.role_id
• solution_id => solution.solution_id

Indexes:

• plan_role_login_id_idx - login_id
• plan_role_plan_id_plan_sponsor_id_solution_id_login_id_role_idx (Unique) - plan_id, plan_sponsor_id, solution_id, login_id, role_id
• plan_role_plan_sponsor_id_idx - plan_sponsor_id
• plan_role_role_id_idx - role_id
• plan_role_solution_id_idx - solution_id

Column	Data Type	Nullable	Indexed	Description
plan_id	bigint	No	Yes	Link to the plan record
plan_sponsor_id	bigint	Yes	Yes	Link to the plan sponsor record
solution_id	bigint	Yes	Yes	Link to the solution record.
login_id	bigint	Yes	Yes	Link to the login record.
role_id	bigint	No	Yes	Link to the role assigned to the plan sponsor, solution, or login.