sed_Sample

3181 rows


Description

Is Sahul Sedimentary Archives (SahulSed) sample table. This table stores SahulSed 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
sed-osl_DataCore.SMPID <--SMPID_from_sed_Sample_fkey R
sed-tl_DataCore.SMPID <--SMPID_from_sed_Sample_fkey R
SITEID text 2147483647 null
global_SiteMaster.SITEID <--SITEID_from_global_SiteMaster_fkey R
SEDTYPE varchar 3 √ null
GEOTYPEID int2 5 √ null
sed_geotypeID.GEOTYPEID <--GEOTYPEID_from_sed_geotypeID_fkey R
DEPCONID int2 5 √ null
sed_depconID.DEPCONID <--DEPCONID_from_sed_depconID_fkey R
DUNEFIELD text 2147483647 √ null
GEOMMODID int2 5 √ null
sed_geommodID.GEOMMODID <--GEOMMODID_from_sed_geommodID_fkey R
MORPHID int2 5 √ null
sed_morphID.MORPHID <--MORPHID_from_sed_morpID_fkey R
DUNTRND int2 5 √ null
SITETYPEID int2 5 √ null
sed_sitetypeID.SITETYPEID <--SITETYPEID_from_sed_sitetypeID_fkey R
DEPTHICK text 2147483647 √ null
SMPDEPTH numeric 9,2 √ null
SED_MATID int2 5 √ null
global_GrainSize.GRNSIZEID <--GRAINSIZEID_from_global_GrainSize_fkey R
FACIESID int2 5 √ null
sed_faciesID.FACIESID <--FACIESID_from_sed_faciesID_fkey R
LAKETYPEID int2 5 √ null
sed_laketypeID.LAKETYPEID <--LAKETYPEID_from_sed_laketypeID_fkey R
BEACHEI text 2147483647 √ null
BEACHAHD 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)
sed_Sample_pkey Primary key Asc SMPID

Relationships

Close relationships within degrees of separation