package_relationship_revision

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id text 2147483647 null
subject_package_id text 2147483647 √ null
package.id package_relationship_revision_subject_package_id_fkeyR
object_package_id text 2147483647 √ null
package.id package_relationship_revision_object_package_id_fkeyR
type text 2147483647 √ null
comment text 2147483647 √ null
revision_id text 2147483647 null
revision.id package_relationship_revision_revision_id_fkeyR
continuity_id text 2147483647 √ null
package_relationship.id package_relationship_revision_continuity_id_fkeyR
state text 2147483647 √ null
expired_id text 2147483647 √ null
revision_timestamp timestamp 29,6 √ null
expired_timestamp timestamp 29,6 √ null
current bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
package_relationship_revision_pkey Primary key Asc/Asc id + revision_id
idx_package_relationship_current Performance Asc current
idx_period_package_relationship Performance Asc/Asc/Asc/Asc revision_timestamp + expired_timestamp + object_package_id + subject_package_id

Relationships

Close relationships within degrees of separation