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