Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| mgm_id | numeric | 131089 | √ | null |
|
|
The id of the SUSE Manager instance that contains this data |
|
| organization | varchar | 128 | √ | null |
|
|
The organization that owns this data |
|
| account_id | numeric | 131089 | √ | null |
|
|
The id of the user account |
|
| username | varchar | 64 | √ | null |
|
|
The username used to login |
|
| last_name | varchar | 128 | √ | null |
|
|
The person last name(s) |
|
| first_name | varchar | 128 | √ | null |
|
|
The person first name(s) |
|
| position | varchar | 128 | √ | null |
|
|
The descriptive role of this user within the organization |
|
| varchar | 128 | √ | null |
|
|
The email address associated with this account |
||
| roles | text | 2147483647 | √ | null |
|
|
List of roles assigned to the user, separated by ; |
|
| creation_time | timestamptz | 35,6 | √ | null |
|
|
When this user account was created |
|
| last_login_time | timestamptz | 35,6 | √ | null |
|
|
When this user account logged in for the last time |
|
| status | varchar | 32 | √ | null |
|
|
Current status of the user. Possible values: enabled, disabled |
|
| md5_encryption | bool | 1 | √ | null |
|
|
True if md5 encryption is used to encode the user password. |
|
| synced_date | timestamptz | 35,6 | √ | null |
|
|
The timestamp of when this data was last refreshed. |
Relationships
Close relationships within degrees of separation
