accountgroup


Description

The list of groups a user is a member of

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null
account.mgm_id accountgroup_account_fkeyR

The id of the SUSE Manager instance that contains this data

account_id numeric 131089 null
account.account_id accountgroup_account_fkeyR

The id of the user account

account_group_id numeric 131089 null

The id of the user group this account belongs to

username varchar 64 null

The username used to login

account_group_name varchar 64 null

The name of this user group

account_group_type_id numeric 131089 null

The identifier of the group type

account_group_type_name varchar 64 null

The descriptive name of the group type

account_group_type_label varchar 64 null

The unique label of the group type

synced_date timestamptz 35,6 CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

Constraint Name Type Sort Column(s)
accountgroup_pk Primary key Asc/Asc/Asc mgm_id + account_id + account_group_id

Check Constraints

Constraint Name Constraint
vn_accountgroup_account_group_type_label (((account_group_type_label)::text <> ''::text))
vn_accountgroup_account_group_name (((account_group_name)::text <> ''::text))
vn_accountgroup_account_group_type_name (((account_group_type_name)::text <> ''::text))
vn_accountgroup_username (((username)::text <> ''::text))

Relationships