deliverables

0 rows


Description

Information about expected deliverables. This describes what we request from users; the data we get back from users in response is recorded in project_deliverables and its child tables.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
deliverable_cohort_due_dates.deliverable_id deliverable_cohort_due_dates_deliverable_id_fkeyC
deliverable_documents.deliverable_id deliverable_documents_deliverable_id_fkeyR
deliverable_project_due_dates.deliverable_id deliverable_project_due_dates_deliverable_id_fkeyC
deliverable_variables.deliverable_id deliverable_variables_deliverable_id_fkeyC
submissions.deliverable_id submissions_deliverable_id_fkeyR
deliverable_category_id int4 10 null
deliverable_categories.id deliverables_deliverable_category_id_fkeyR
deliverable_type_id int4 10 null
deliverable_documents.deliverable_type_id deliverable_documents_deliverable_id_deliverable_type_id_fkeyR
deliverable_types.id deliverables_deliverable_type_id_fkeyR
module_id int8 19 null
modules.id deliverables_module_id_fkeyR
position int4 10 null

Which position this deliverable appears in the module’s list of deliverables, starting with 1.
created_by int8 19 null
users.id deliverables_created_by_fkeyR
created_time timestamptz 35,6 null
modified_by int8 19 null
users.id deliverables_modified_by_fkeyR
modified_time timestamptz 35,6 null
name text 2147483647 null
description_html text 2147483647 √ null
is_sensitive bool 1 null

If true, the data users provide in response to this deliverable will be visible to a smaller subset of accelerator admins. Secure documents are saved to a different document store than non-secure ones.
is_required bool 1 null

Indexes

Constraint Name Type Sort Column(s)
deliverables_pkey Primary key Asc id
deliverables_id_deliverable_type_id_key Must be unique Asc/Asc id + deliverable_type_id
deliverables_module_id_position_key Must be unique Asc/Asc module_id + position

Relationships

Close relationships within degrees of separation