Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| mgm_id | numeric | 0 | null |
|
|
The id of the Uyuni instance that contains this data |
||||
| diff_id | int8 | 19 | null |
|
|
The id of the difference entry |
||||
| project_label | varchar | 24 | null |
|
|
The label of the Content Lifecycle Management project |
||||
| environment_label | varchar | 16 | null |
|
|
The label of the Content Lifecycle Management environment |
||||
| channel_id | numeric | 0 | null |
|
|
The id of the channel which belong to the Content Lifecycle Management environment |
||||
| diff_action | varchar | 8 | null |
|
|
The action which will be done with the next build or promote of the environment (“+” for adding to the environment, “-” for removing or “x” for excluded by a filter) |
||||
| entry_id | numeric | 0 | null |
|
|
The id of the entry of the specific type (for type “package” the package_id or errata_id for type “errata”) |
||||
| entry_type | varchar | 16 | null |
|
|
The type of the entry (either “package” or “errata”) |
||||
| entry_name | varchar | 256 | null |
|
|
The name of the entry |
||||
| entry_description | varchar | 2147483647 | null |
|
|
The description of the entry |
||||
| synced_date | timestamptz | 35,6 | √ | CURRENT_TIMESTAMP |
|
|
The timestamp of when this data was last refreshed. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| clmenvironmentdifference_pk | Primary key | Asc/Asc | mgm_id + diff_id |
| clmenvironmentdifference_eidt_idx | Performance | Asc/Asc | entry_id + entry_type |
| clmenvironmentdifference_ped_idx | Performance | Asc/Asc | project_label + environment_label |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| vn_clmenvironmentdifference_project_label | (((project_label)::text <> ''::text)) |
| vn_clmenvironmentdifference_entry_name | (((entry_name)::text <> ''::text)) |
| vn_clmenvironmentdifference_entry_type | (((entry_type)::text <> ''::text)) |
| vn_clmenvironmentdifference_entry_description | (((entry_description)::text <> ''::text)) |
| vn_clmenvironmentdifference_diff_action | (((diff_action)::text <> ''::text)) |
| vn_clmenvironmentdifference_environment_label | (((environment_label)::text <> ''::text)) |
Relationships
Close relationships within degrees of separation
