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 Uyuni 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_key (((key)::text <> ''::text))
vn_systemcustominfo_value (((value)::text <> ''::text))
vn_systemcustominfo_description (((description)::text <> ''::text))

Relationships

Close relationships within degrees of separation