fos_Sample

2235 rows


Description

Is FosSahul sample table. This table stores FosSahul samples and is, therefore, situated between fos_DataCore table (subordinate) and global_SiteMaster table (superordinate).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SMPID text 2147483647 null
fos_DataCore.SMPID <--SMPID_from_fos_Sample_fkey R
SITEID text 2147483647 null
global_SiteMaster.SITEID <--SITEID_from_global_SiteMaster_fkey R
STRAT_TAPH text 2147483647 √ null
SPEC_ABUND text 2147483647 √ null
SQUARE_XU text 2147483647 √ null
SMP_COMMT 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)
fos_Sample_pkey Primary key Asc SMPID

Relationships

Close relationships within degrees of separation