document_saved_versions

-1 rows


Description

Saved versions of document variable values. A saved version is conceptually just a reference to a particular point in the edit history of the document; to restore that version, we ignore any later edits.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
document_id int8 19 null
documents.id document_saved_versions_document_id_fkey C
variable_manifest_id int8 19 null
variable_manifests.id document_saved_versions_variable_manifest_id_fkey R
max_variable_value_id int8 19 null
created_by int8 19 '-1'::integer
users.id document_saved_versions_created_by_fkey
created_time timestamptz 35,6 null
name text 2147483647 √ null
is_submitted bool 1 false
is_accepted bool 1 false

Indexes

Constraint Name Type Sort Column(s)
document_saved_versions_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation