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
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
Column | Data Type | Nullable | Indexed | Description |
---|---|---|---|---|
plan_id | bigint | No | Yes | - |
plan_sponsor_id | bigint | Yes | Yes | - |
solution_id | bigint | Yes | Yes | - |
login_id | bigint | Yes | Yes | - |
role_id | bigint | No | Yes | - |