crn_Sample

6039 rows


Description

Is CRN denudation sample table. This table stores CRN denudation samples and is, therefore, situated between the collection-specific DataCore tables (subordinate) and the global_SiteMaster table (superordinate).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SMPID text 2147483647 null
crn_al_DataCore.SMPID <--SMPID_from_crn_Sample_fkey R
crn_be_DataCore.SMPID <--SMPID_from_crn_Sample_fkey R
SITEID text 2147483647 null
global_SiteMaster.SITEID <--SITEID_from_global_SiteMaster_fkey R
STUDYID varchar 13 null
MATERIAL int2 5 √ null
global_GrainSize.GRNSIZEID <--GRNSIZEID_from_global_GrainSize_fkey R
SIZEMIN int4 10 √ null
SIZEMAX int4 10 √ null
PROJEPSGID int2 5 √ null
crn_projepsgID.PROJEPSGID <--PROJEPSGID_from_crn_projepsgID_fkey R
AREA numeric 12,2 √ null
ELEV_AVE numeric 6,2 √ null
ELEV_STD numeric 6,2 √ null
SLP_AVE numeric 6,2 √ null
SLP_STD numeric 6,2 √ null
SMP_DAY int2 5 √ null
SMP_MONTH int2 5 √ null
SMP_YEAR 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)
crn_Sample_pkey Primary key Asc SMPID

Relationships

Close relationships within degrees of separation