published_version


Columns

Column Type Size Nulls Auto Default Children Parents Comments
package_id varchar 2147483647 null
operation.package_id FK_published_version C
operation_group.package_id FK_published_version C
published_sources.package_id FK_published_sources_version_revision C
published_version_notification.package_id fk_published_version_notification C
published_version_reference.package_id FK_published_version C
published_version_revision_content.package_id FK_published_version_revision C
published_version_validation.package_id FK_published_version_validation C
version_internal_document.package_id version_internal_document_published_version_fk C
package_group.id FK_package_group C
version varchar 2147483647 null
operation.version FK_published_version C
operation_group.version FK_published_version C
published_sources.version FK_published_sources_version_revision C
published_version_notification.version fk_published_version_notification C
published_version_reference.version FK_published_version C
published_version_revision_content.version FK_published_version_revision C
published_version_validation.version FK_published_version_validation C
version_internal_document.version version_internal_document_published_version_fk C
revision int4 10 null
operation.revision FK_published_version C
operation_group.revision FK_published_version C
published_sources.revision FK_published_sources_version_revision C
published_version_notification.revision fk_published_version_notification C
published_version_reference.revision FK_published_version C
published_version_revision_content.revision FK_published_version_revision C
published_version_validation.revision FK_published_version_validation C
version_internal_document.revision version_internal_document_published_version_fk C
status varchar 2147483647 null

DRAFT / APPROVED / RELEASED / ARCHIVE
published_at timestamp 29,6 null
deleted_at timestamp 29,6 √ null
metadata jsonb 2147483647 √ null
previous_version varchar 2147483647 √ null
previous_version_package_id varchar 2147483647 √ null
labels _varchar 2147483647 √ null
created_by varchar 2147483647 √ null
deleted_by varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_published_version Primary key Asc/Asc/Asc package_id + version + revision

Relationships

Close relationships within degrees of separation