submissions

0 rows


Description

Information about the current states of the information supplied by specific projects in response to deliverables.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
submission_documents.submission_id submission_documents_submission_id_fkeyR
submission_snapshots.submission_id submission_snapshots_submission_id_fkeyR
project_id int8 19 null
projects.id submissions_project_id_fkeyC
deliverable_id int8 19 null
deliverables.id submissions_deliverable_id_fkeyR
submission_status_id int4 10 null
submission_statuses.id submissions_submission_status_id_fkeyR
created_by int8 19 null
users.id submissions_created_by_fkeyR
created_time timestamptz 35,6 null
modified_by int8 19 null
users.id submissions_modified_by_fkeyR
modified_time timestamptz 35,6 null
internal_comment text 2147483647 √ null
feedback text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
submissions_pkey Primary key Asc id
submissions_deliverable_id_idx Performance Asc deliverable_id
submissions_project_id_deliverable_id_key Must be unique Asc/Asc project_id + deliverable_id
submissions_project_id_idx Performance Asc project_id

Relationships

Close relationships within degrees of separation