datasetsubmissions

50304 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)

An arbitrary submission identification number.

datasetid int4 10 null
datasets.datasetid fk_datasetsubmissions_datasetsC

Dataset identification number. Field links to the Datasets table. Datasets may occur multiple times in this table (e.g. once for the original compilation into a different database and a second time for the recompilation into Neotoma).

databaseid int4 10 null
constituentdatabases.databaseid fk_datasetsubmissions_constituentdatabasesC
contactid int4 10 null
contacts.contactid fk_datasetsubmissions_contactsR

Contact identification number. Field links to the Contacts table. The Contact is the person who submitted, resubmitted, compiled, or recompiled the data. This person is not necessarily the Dataset PI; it is the person who submitted the data or compiled the data from the literature.

submissiontypeid int4 10 null
datasetsubmissiontypes.submissiontypeid fk_datasetsubmissions_datasetsubmissiontypesC

Submission Type identification number. Field links to the DatasetSubmissionsType table.

submissiondate date 13 null

Date of the submission, resubmission, compilation, or recompilation.

notes text 2147483647 null

Free form notes or comments about the submission.

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