permissions_group


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
connection_impersonations.group_id fk_conn_impersonation_group_id C
data_permissions.group_id fk_data_permissions_ref_permissions_group C
notification_recipient.permissions_group_id fk_notification_recipient_permissions_group_id C
permissions.group_id fk_permissions_group_id C
permissions_group_membership.group_id fk_permissions_group_group_id C
sandboxes.group_id fk_gtap_group_id C

{“what”:“Unique numeric identifier for the group.”,“why”:“Needed to reference groups from other tables; without it rows cannot be uniquely addressed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:14.533201073+00:00”}
name varchar 255 null

{“what”:“Human-readable group name, e.g. ‘Admins’.”,“why”:“Used for display and lookup; without it groups are indistinguishable in UI.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:14.549046431+00:00”}
entity_id bpchar 21 √ null

{“what”:“Identifier of the entity this group applies to, if scoped.”,“why”:“Distinguishes global groups from entity-specific ones; without it scope is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:14.572963514+00:00”}
magic_group_type varchar 254 √ null

{“what”:“Type of predefined group, e.g. ‘owner’ or ‘member’.”,“why”:“Identifies built-in groups that cannot be edited; without it special handling is unclear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:14.587860238+00:00”}
is_tenant_group bool 1 false

{“what”:“Flag indicating if group is scoped to a tenant.”,“why”:“Separates tenant-level groups from global ones; without it multi-tenant isolation breaks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:14.600331839+00:00”}

Indexes

Constraint Name Type Sort Column(s)
permissions_group_pkey Primary key Asc id
idx_permissions_group_name Performance Asc name
permissions_group_entity_id_key Must be unique Asc entity_id
permissions_group_magic_group_type_key Must be unique Asc magic_group_type
unique_permissions_group_name Must be unique Asc name

Check Constraints

Constraint Name Constraint
permissions_group_id_not_null1 id IS NOT NULL

Relationships

Close relationships within degrees of separation