systemcustominfo


Description

List custom pieces of information related to a system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null
system.mgm_id systemcustominfoR

The id of the SUSE Manager instance that contains this data

system_id numeric 131089 null
system.system_id systemcustominfoR

The id of the system

organization varchar 128 null

The organization that owns this data

key varchar 64 null

The name of the custom information

description varchar 4000 null

A brief description of this information

value varchar 4000 null

The actual value of the custom information

synced_date timestamptz 35,6 CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

Constraint Name Type Sort Column(s)
systemcustominfo_pk Primary key Asc/Asc/Asc/Asc mgm_id + organization + system_id + key

Check Constraints

Constraint Name Constraint
vn_systemcustominfo_organization (((organization)::text <> ''::text))
vn_systemcustominfo_description (((description)::text <> ''::text))
vn_systemcustominfo_key (((key)::text <> ''::text))
vn_systemcustominfo_value (((value)::text <> ''::text))

Relationships