systemgroupmember


Description

The list of system group a system is member of

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null
system.mgm_id systemgroupmember_system_fkeyR
systemgroup.mgm_id systemgroupmember_group_fkeyR

The id of the SUSE Manager instance that contains this data
system_id numeric 131089 null
system.system_id systemgroupmember_system_fkeyR

The id of the system
system_group_id numeric 131089 null
systemgroup.system_group_id systemgroupmember_group_fkeyR

The id of the system group
group_name varchar 64 √ null

The unique name of the system group
system_name varchar 128 √ null

The unique descriptive name of the system
synced_date timestamptz 35,6 √ CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

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

Check Constraints

Constraint Name Constraint
vn_systemgroupmember_system_name (((system_name)::text <> ''::text))
vn_systemgroupmember_group_name (((group_name)::text <> ''::text))

Relationships

Close relationships within degrees of separation