tbl_submission_tasks

0 rows


Description

Records submission tasks and the contacts responsible for them.

Columns

Column Type Size Nulls Auto Children Parents Comments
submission_task_id int4 10 √

Primary key (automatically incremented).
submission_task_type_id int4 10
tbl_submission_task_types.submission_task_type_id tbl_submission_tasks_submission_task_type_id_fkey R

Identifies the type of task performed.
contact_id int4 10
tbl_contacts.contact_id tbl_submission_tasks_contact_id_fkey R

Identifies the contact responsible for the task.
submission_id int4 10
tbl_submissions.submission_id tbl_submission_tasks_submission_id_fkey R

Identifies the submission to which the task belongs.
biblio_id int4 10 √
tbl_biblio.biblio_id tbl_submission_tasks_biblio_id_fkey R

Identifies the dataset bibliography associated with a migrated legacy task, when available.
event_date date 13 √

Records when the submission task occurred.
notes text 2147483647 √

Additional information about the submission task.

Indexes

Constraint Name Type Sort Column(s)
tbl_submission_tasks_pkey Primary key Asc submission_task_id
idx_submission_tasks_biblio_id Performance Asc biblio_id
idx_submission_tasks_contact_id Performance Asc contact_id
idx_submission_tasks_submission_id Performance Asc submission_id
idx_submission_tasks_submission_task_type_id Performance Asc submission_task_type_id

Relationships

Close relationships within degrees of separation