Table SIEM.public.user_groups
Sentinel groups (aka roles).

 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
group_id uuid 2147483647
console_slms.user_group_id console_slms_user_group_id_fk N
user_group_mappings.user_group_id user_group_mappings_user_group_id_fk C
user_group_permissions.user_group_id user_group_permissions_user_group_id_fk C
user_group_tags.user_group_id user_group_tags_user_group_id_fk C
Unique Identifier for Group of Users
group_name varchar 255 Name of the group (Role on GUI)
group_desc varchar 1024  √  null Description of the group
filter varchar 4096  √  null To see all the data or selected data as a filter
allow_all_events bool 1  √  null Indicator for allowing all the events
is_admin bool 1  √  null True indicates that this group belongs to Admin
read_only bool 1  √  null True indicates that the user is end user so no write privileges are granted
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
group_id Primary key Asc user_groups_pk
group_name Must be unique Asc user_groups_group_name_key

Close relationships  within of separation: