Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int4 |
|
|
|
| profile_id | int4 |
|
|
|
| company_id | int8 |
|
|
|
| admin_roles | _varchar |
|
|
|
| staffer_role_id | int8 |
|
|
|
| workato_id | varchar |
|
|
|
| access_reach | varchar |
|
|
|
| can_access_automations | bool |
|
|
Whether the staffer can access Lookout Automations. @example: true |
| analytics_user_type | varchar |
|
|
The type of Analytics user. “read_only” users can only view collections, dashboards and questions. “super” users can curate collections, dashboards and questions. @example: nil, read_only, super. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_staffers_pkey | Primary key | Asc | id |
| idx_edge_staffers_company_id | Performance | Asc | company_id |
| idx_edge_staffers_profile_id | Performance | Asc | profile_id |
| idx_edge_staffers_staffer_role_id | Performance | Asc | staffer_role_id |
| idx_edge_staffers_workato_id | Performance | Asc | workato_id |