tbl_submissions

0 rows


Description

Stores submission metadata and links each submission to its data provider.

Columns

Column Type Size Nulls Auto Children Parents Comments
submission_id int4 10 √
tbl_datasets.submission_id tbl_datasets_submission_id_fkey R
tbl_submission_tasks.submission_id tbl_submission_tasks_submission_id_fkey R

Primary key (automatically incremented).
submission_state_id int4 10 √
tbl_submission_states.submission_state_id tbl_submissions_submission_state_id_fkey R

Identifies the lifecycle state assigned to the submission.
biblio_id int4 10 √
tbl_biblio.biblio_id tbl_submissions_biblio_id_fkey R

Identifies a publication or reference associated with the submission.
upload_date date 13 √

Date on which files for the submission were uploaded.
submission_date date 13 √

Date on which the submission was made to SEAD.
submission_identifier text 2147483647 √

Identifier assigned to the submission by the data provider or source system, when available.
issue_identifier text 2147483647 √

Identifier of the issue or ticket used to track work on this submission, when available.
author text 2147483647 √

Name of the person or organization credited as author of the submitted data.
notes text 2147483647 √

Additional information about the submission.
data_provider_id int4 10
tbl_data_providers.data_provider_id tbl_submissions_data_provider_id_fkey R

Identifies the provider that supplied the data.
submission_name text 2147483647

Name or title used to identify the submission.
source_name text 2147483647 √

Name of the source from which the submitted data originated.
data_types text 2147483647 √

Types of data included in the submission.
submission_uuid uuid 2147483647

Unique UUID generated for the submission.

Indexes

Constraint Name Type Sort Column(s)
tbl_submissions_pkey Primary key Asc submission_id
idx_submissions_biblio_id Performance Asc biblio_id
idx_submissions_data_provider_id Performance Asc data_provider_id
idx_submissions_submission_state_id Performance Asc submission_state_id
tbl_submissions_submission_uuid_key Must be unique Asc submission_uuid

Relationships

Close relationships within degrees of separation