Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('roleassignment_id_seq'::regclass) |
|
|
||||
| assigneeidentifier | varchar | 255 | null |
|
|
|||||
| privateurlanonymizedaccess | bool | 1 | √ | null |
|
|
||||
| privateurltoken | varchar | 255 | √ | null |
|
|
||||
| definitionpoint_id | int8 | 19 | null |
|
|
|||||
| role_id | int8 | 19 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| roleassignment_pkey | Primary key | Asc | id |
| index_roleassignment_assigneeidentifier | Performance | Asc | assigneeidentifier |
| index_roleassignment_definitionpoint_id | Performance | Asc | definitionpoint_id |
| index_roleassignment_role_id | Performance | Asc | role_id |
| unq_roleassignment_0 | Must be unique | Asc/Asc/Asc | assigneeidentifier + role_id + definitionpoint_id |
Relationships
Close relationships within degrees of separation
