documents

-1 rows


Description

Top-level information about documents.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
document_saved_versions.document_id document_saved_versions_document_id_fkey C
document_template_id int8 19 null
document_templates.id documents_document_template_id_fkey R
variable_manifest_id int8 19 null
variable_manifests.id documents_variable_manifest_id_fkey R
project_id int8 19 null
projects.id documents_project_id_fkey R
name text 2147483647 null
status_id int4 10 null
document_statuses.id documents_status_id_fkey R
owned_by int8 19 '-1'::integer
users.id documents_owned_by_fkey
created_by int8 19 '-1'::integer
users.id documents_created_by_fkey
created_time timestamptz 35,6 null
modified_by int8 19 '-1'::integer
users.id documents_modified_by_fkey
modified_time timestamptz 35,6 null
internal_comment text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
documents_pkey Primary key Asc id
documents_name_key Must be unique Asc name
documents_project_id_idx Performance Asc project_id

Relationships

Close relationships within degrees of separation