global_GrainSize

29 rows


Description

Is global parent table for sample tables of compilations dealing with sedimentary grain sizes (sed_Sample, expage_Sample, crn_Sample). global_GrainSize stores the type of material sampled (= MATERIAL (CRN denudation, ExpAge), = SED_MAT (SahulSed)).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
GRNSIZEID int2 5 null
crn_Sample.MATERIAL <--GRNSIZEID_from_global_GrainSize_fkey R
expage_Sample.MATERIALID <--GRNSIZEID_from_global_GrainSize_fkey R
sed_Sample.SED_MATID <--GRAINSIZEID_from_global_GrainSize_fkey R
GRNSIZE text 2147483647 null
GRNSIZEABB varchar 6 null
GRNSIZEMIN numeric 7,4 √ null
GRNSIZEMAX numeric 7,4 √ 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_GrainSize_pkey Primary key Asc GRNSIZEID
global_grainsize_GRNSIZE_ukey Must be unique Asc GRNSIZE
global_grainsize_GRNSIZEABB_ukey Must be unique Asc GRNSIZEABB

Relationships

Close relationships within degrees of separation