Table SIEM.public.user_group_permissions
The permissions granted to a Sentinel group (aka role).

Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
user_group_id uuid 2147483647
user_groups.group_id user_group_permissions_user_group_id_fk C
Reference ID of the user_group table for which group these permissions are applicable
perm_name varchar 255
permissions.perm_name user_group_permissions_perm_name_fk C
Permission name coming from Permission table
perm_value text 2147483647 Indicate whether this permission is true (selected) or false (not selected)
date_created timestamptz 35,6 Date the entry was created
date_modified timestamptz 35,6 Date the entry was modified
created_by int4 10  √  null User who created object
modified_by int4 10  √  null User who last modified object

Table contained 0 rows at Mon Mar 26 23:24 EDT 2012

Indexes:
Column(s) Type Sort Constraint Name
user_group_id + perm_name Primary key Asc/Asc user_group_permissions_pk

Close relationships  within of separation: