revision

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id text 2147483647 null
group_extra_revision.revision_id group_extra_revision_revision_id_fkeyR
group_revision.revision_id group_revision_revision_id_fkeyR
member_revision.revision_id member_revision_revision_id_fkeyR
package_extra_revision.revision_id package_extra_revision_revision_id_fkeyR
package_relationship_revision.revision_id package_relationship_revision_revision_id_fkeyR
package_revision.revision_id package_revision_revision_id_fkeyR
package_tag_revision.revision_id package_tag_revision_revision_id_fkeyR
resource_revision.revision_id resource_revision_revision_id_fkeyR
system_info_revision.revision_id system_info_revision_revision_id_fkeyR
timestamp timestamp 29,6 √ null
author varchar 200 √ null
message text 2147483647 √ null
state text 2147483647 √ null
approved_timestamp timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
revision_pkey Primary key Asc id
idx_rev_state Performance Asc state
idx_revision_author Performance Asc author

Relationships

Close relationships within degrees of separation