global_datasettypeID

42 rows


Description

The global_datasettypeID table stores dataset types, e.g., pollen. To facilitate data migration where necessary, table structure, primary keys and content resemble Neotoma’s datasettypes table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
DSETTYPEID serial 10 nextval('"global_datasettypeID_DSETTYPEID_seq"'::regclass)
global_DataSetMaster.DSETTYPEID <--DSETTYPEID_from_global_datasettypeID_fkey R
DSETTYPE text 2147483647 null
DSTYPNOTE text 2147483647 null
CREATED_AT timestamptz 35,6 timezone('UTC'::text, now())

Is record timestamp with timezone based on UTC

UPDATED_AT timestamptz 35,6 timezone('UTC'::text, now())

Is timestamp of record update with timezone based on UTC

Indexes

Constraint Name Type Sort Column(s)
global_datasettypeID_pkey Primary key Asc DSETTYPEID

Relationships