9 rows


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


Column Type Size Nulls Auto Default Children Parents Comments
submissiontypeid serial 10 nextval('ndb.seq_datasetsubmissiontypes_submissiontypeid'::regclass)
datasetsubmissions.submissiontypeid fk_datasetsubmissions_datasetsubmissiontypesC

An arbitrary Submission Type identification number.

submissiontype varchar 80 null

Type of submission. The database has the following types:
Original submission from data contributor
Resubmission or revision from data contributor
Compilation into a flat file database
Compilation into a another relational database
Recompilation or revisions to a another relational database
Compilation into Neotoma from another database
Recompilation into Neotoma from another database
Compilation into Neotoma from primary source
Recompilation into or revisions to Neotoma

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null


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