submissions

-1 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_fkey R
submission_snapshots.submission_id submission_snapshots_submission_id_fkey R
project_id int8 19 null
projects.id submissions_project_id_fkey C
deliverable_id int8 19 null
deliverables.id submissions_deliverable_id_fkey R
submission_status_id int4 10 null
submission_statuses.id submissions_submission_status_id_fkey R
created_by int8 19 null
users.id submissions_created_by_fkey R
created_time timestamptz 35,6 null
modified_by int8 19 null
users.id submissions_modified_by_fkey R
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