datasetsubmissiontypes

9 rows


Description

Lookup table of Dataset Submission Types. Table is referenced by the DatasetSubmissions table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
submissiontypeid serial 10 nextval('ndb.seq_datasetsubmissiontypes_submissiontypeid'::regclass)
datasetsubmissions.submissiontypeid fk_datasetsubmissions_datasetsubmissiontypesC
submissiontype varchar 80 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
datasetsubmissiontypes_pkey Primary key Asc submissiontypeid

Relationships