arch_Sample

10412 rows


Description

Is Sahul Archaeology (SahulArch) sample table. This table stores SahulArch 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
arch_c14_DataCore.SMPID <--SMPID_from_arch_Sample_fkey R
arch_osl_DataCore.SMPID <--SMPID_from_arch_Sample_fkey R
arch_tl_DataCore.SMPID <--SMPID_from_arch_Sample_fkey R
SITEID text 2147483647 null
global_SiteMaster.SITEID <--SITEID_from_global_SiteMaster_fkey R
FEATDATEID int2 5 √ null
arch_featdatedID.FEATDATEID <--FEATDATEID_from_arch_featdatedID_fkey R
SQUARE text 2147483647 √ null
XU text 2147483647 √ null
SMPDEPTH numeric 9,2 √ null
SMPX_WGS84 numeric 10,6 √ null
SMPY_WGS84 numeric 10,6 √ null
OCCUPATION varchar 3 √ null
CONTEXT varchar 10 √ 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)
arch_Sample_pkey Primary key Asc SMPID

Relationships

Close relationships within degrees of separation