tbl_dataset_submission_types

0 rows


Description

This table serves as a lookup for different types of dataset submissions, such as original submissions or data ingested from external databases.

Columns

Column Type Size Nulls Auto Children Parents Comments
submission_type_id int4 10 √
tbl_dataset_submissions.submission_type_id fk_dataset_submission_submission_type_id R

Primary key (automatically incremented).
submission_type varchar(60) 60

A concise name showing the type of dataset submission (e.g., ‘Original Submission’, ‘Ingestion from External Database’).
description text 2147483647 √

A detailed explanation of the dataset submission type, describing the method of data ingestion.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_dataset_submission_types_pkey Primary key Asc submission_type_id

Relationships

Close relationships within degrees of separation