version_comparison


Columns

Column Type Size Nulls Auto Default Children Parents Comments
package_id varchar 2147483647 null
comparison_internal_document.package_id comparison_internal_document_version_comparison_fk C
version varchar 2147483647 null
comparison_internal_document.version comparison_internal_document_version_comparison_fk C
revision int4 10 null
comparison_internal_document.revision comparison_internal_document_version_comparison_fk C
previous_package_id varchar 2147483647 null
comparison_internal_document.previous_package_id comparison_internal_document_version_comparison_fk C
previous_version varchar 2147483647 null
comparison_internal_document.previous_version comparison_internal_document_version_comparison_fk C
previous_revision int4 10 null
comparison_internal_document.previous_revision comparison_internal_document_version_comparison_fk C
comparison_id varchar 2147483647 null
ddl_comparison.comparison_id ddl_comparison_version_comparison_comparison_id_fk C
operation_comparison.comparison_id FK_version_comparison C
version_comparison_notification.comparison_id version_comparison_notification_comparison_id_fk C
operation_types jsonb 2147483647 √ null
refs _varchar 2147483647 √ null
open_count int8 19 null
last_active timestamp 29,6 null
no_content bool 1 null
builder_version varchar 2147483647 √ null
metadata jsonb 2147483647 √ null
contract_types jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
version_comparison_pkey Primary key Asc/Asc/Asc/Asc/Asc/Asc package_id + version + revision + previous_package_id + previous_version + previous_revision
version_comparison_comparison_id_key Must be unique Asc comparison_id

Relationships

Close relationships within degrees of separation