expage_Sample

15805 rows


Description

Is Expage sample table. This table stores Expage samples and is, therefore, situated between the expage_DataCore table (subordinate) and the global_SiteMaster table (superordinate).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SMPID text 2147483647 null
expage_DataCore.SMPID <--SMPID_from_expage_Sample_fkey R
SITEID text 2147483647 null
global_SiteMaster.SITEID <--SITEID_from_global_SiteMaster_fkey R
MATERIALID int2 5 √ null
global_GrainSize.GRNSIZEID <--GRNSIZEID_from_global_GrainSize_fkey R
THICKNESS numeric 7,4 √ null
DENSITY numeric 6,4 √ null
SHIELDING numeric 7,6 √ null
SMP_YR int2 5 √ 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)
expage_Sample_pkey Primary key Asc SMPID

Relationships

Close relationships within degrees of separation