Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
user_group_id | bigserial | 19 | √ | nextval('user_groups_user_group_id_seq'::regclass) |
|
|
||||||||||||||
context_id | int8 | 19 | null |
|
|
|||||||||||||||
role_id | int8 | 19 | null |
|
|
|||||||||||||||
is_default | int2 | 5 | '0'::smallint |
|
|
|||||||||||||||
show_title | int2 | 5 | '1'::smallint |
|
|
|||||||||||||||
permit_self_registration | int2 | 5 | '0'::smallint |
|
|
|||||||||||||||
permit_metadata_edit | int2 | 5 | '0'::smallint |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
user_groups_pkey | Primary key | Asc | user_group_id |
user_groups_context_id | Performance | Asc | context_id |
user_groups_role_id | Performance | Asc | role_id |
user_groups_user_group_id | Performance | Asc | user_group_id |