comparison_internal_document


Columns

Column Type Size Nulls Auto Default Children Parents Comments
package_id varchar 2147483647 null
version_comparison.package_id comparison_internal_document_version_comparison_fk C
version varchar 2147483647 null
version_comparison.version comparison_internal_document_version_comparison_fk C
revision int4 10 null
version_comparison.revision comparison_internal_document_version_comparison_fk C
previous_package_id varchar 2147483647 null
version_comparison.previous_package_id comparison_internal_document_version_comparison_fk C
previous_version varchar 2147483647 null
version_comparison.previous_version comparison_internal_document_version_comparison_fk C
previous_revision int4 10 null
version_comparison.previous_revision comparison_internal_document_version_comparison_fk C
document_id varchar 2147483647 null
filename varchar 2147483647 √ null
hash varchar 2147483647 √ null
comparison_internal_document_data.hash comparison_internal_document_data_fk R

Indexes

Constraint Name Type Sort Column(s)
comparison_internal_document_pkey Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc package_id + version + revision + previous_package_id + previous_version + previous_revision + document_id
comparison_internal_document_hash_idx Performance Asc hash

Relationships

Close relationships within degrees of separation