datasetsubmissions

50138 rows


Description

Submissions to the database are of Datasets. Submissions may be original submissions, resubmissions, compilations from other databases, or recompilations. See the description of the DatasetSubmissionTypes table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
submissionid serial 10 nextval('ndb.seq_datasetsubmissions_submissionid'::regclass)
datasetid int4 10 null
datasets.datasetid fk_datasetsubmissions_datasetsC
databaseid int4 10 null
constituentdatabases.databaseid fk_datasetsubmissions_constituentdatabasesC
contactid int4 10 null
contacts.contactid fk_datasetsubmissions_contactsR
submissiontypeid int4 10 null
datasetsubmissiontypes.submissiontypeid fk_datasetsubmissions_datasetsubmissiontypesC
submissiondate date 13 null
notes text 2147483647 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
datasetsubmissions_pkey Primary key Asc submissionid
ix_datasetid_datasetsubmissions Performance Asc datasetid
ix_projectid_datasetsubmissions Performance Asc databaseid

Relationships