submission_documents

0 rows


Description

Information about documents uploaded by users to satisfy deliverables. A deliverable can have multiple documents.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
submission_id int8 19 null
submissions.id submission_documents_submission_id_fkeyR
document_store_id int4 10 null
document_stores.id submission_documents_document_store_id_fkeyR
created_by int8 19 null
users.id submission_documents_created_by_fkeyR
created_time timestamptz 35,6 null
name text 2147483647 null

System-generated filename. The file is stored using this name in the document store. This includes several elements such as the date and description.
description text 2147483647 √ null
location text 2147483647 null

Location of file in the document store identified by document_store_id. This is used by the system to generate download links and includes whatever information is needed to generate a link for a given document store; if the document store supports permalinks then this may be a simple URL.
original_name text 2147483647 √ null

Original filename as supplied by the client when the document was uploaded. Not required to be unique since the user can upload revised versions of documents.
project_id int8 19 null
projects.id submission_documents_project_id_fkeyR

Indexes

Constraint Name Type Sort Column(s)
submission_documents_pkey Primary key Asc id
no_duplicate_names_for_project Must be unique Asc/Asc project_id + name
submission_documents_submission_id_idx Performance Asc submission_id

Relationships

Close relationships within degrees of separation