operation


Columns

Column Type Size Nulls Auto Default Children Parents Comments
package_id varchar 2147483647 null
grouped_operation.package_id FK_operation C
published_version.package_id FK_published_version C
version varchar 2147483647 null
grouped_operation.version FK_operation C
published_version.version FK_published_version C
revision int4 10 null
grouped_operation.revision FK_operation C
published_version.revision FK_published_version C
operation_id varchar 2147483647 null
grouped_operation.operation_id FK_operation C
data_hash varchar 2147483647 null
operation_data.data_hash FK_operation_data C
deprecated bool 1 null
kind varchar 2147483647 √ null
title varchar 2147483647 √ null
metadata jsonb 2147483647 √ null
type varchar 2147483647 null
deprecated_info varchar 2147483647 √ null
deprecated_items jsonb 2147483647 √ null
previous_release_versions _varchar 2147483647 √ null
models jsonb 2147483647 √ null
custom_tags jsonb 2147483647 √ null
api_audience varchar 2147483647 √ 'external'::character varying

Indexes

Constraint Name Type Sort Column(s)
pk_operation Primary key Asc/Asc/Asc/Asc package_id + version + revision + operation_id
ix_operation_pvrt Performance Asc/Asc/Asc/Asc package_id + version + revision + type
operation_data_hash_idx Performance Asc data_hash

Relationships

Close relationships within degrees of separation