systemgroup


Description

The list of system groups managed by a SUSE Manager instance

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 0 null
systemgroupmember.mgm_id systemgroupmember_group_fkeyR
systemgrouppermission.mgm_id systemgrouppermission_group_fkeyR

The id of the SUSE Manager instance that contains this data
system_group_id numeric 0 null
systemgroupmember.system_group_id systemgroupmember_group_fkeyR
systemgrouppermission.system_group_id systemgrouppermission_group_fkeyR

The id of this system group
name varchar 64 √ null

The unique name of this system group
description varchar 1024 √ null

A brief description of this system group
current_members numeric 0 √ null

The current number of members of this system group
organization varchar 128 √ null

The organization that owns this data
synced_date timestamptz 35,6 √ CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

Constraint Name Type Sort Column(s)
systemgroup_pk Primary key Asc/Asc mgm_id + system_group_id

Check Constraints

Constraint Name Constraint
vn_systemgroup_description (((description)::text <> ''::text))
vn_systemgroup_name (((name)::text <> ''::text))
vn_systemgroup_organization (((organization)::text <> ''::text))

Relationships

Close relationships within degrees of separation