tbl_dataset_submissions

140638 rows


Description

Deprecated by tbl_submissions and tbl_submission_tasks. Retained temporarily for audit and compatibility. Contains records of various submission events related to a dataset, such as initial recording, database entries, and integrations with SEAD.

Columns

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

Primary key (automatically incremented).
dataset_id int4 10
tbl_datasets.dataset_id fk_dataset_submissions_dataset_id R

Specifies the dataset related to the submission.
submission_type_id int4 10
tbl_dataset_submission_types.submission_type_id fk_dataset_submission_submission_type_id R

Specifies the type or category of the submission event.
contact_id int4 10
tbl_contacts.contact_id fk_dataset_submissions_contact_id R

Identifies the contact person or organization responsible for the dataset submission.
date_submitted text 2147483647 √

The timestamp indicating when the submission was completed.
notes text 2147483647 √

Contains supplementary information regarding the submission, such as its origin if not documented elsewhere (e.g., BugsCEP).
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_dataset_submissions_pkey Primary key Asc dataset_submission_id

Relationships

Close relationships within degrees of separation