c14_materia2ID

60 rows


Description

Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for sub-type of sample material used for 14C dating (= MATERIAL2)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
MATERIA2ID int2 5 null
arch_c14_DataCore.MATERIA2ID <--MATERIA2ID_from_C14_materia2ID_fkey R
c14_materia2ID.PARENTID c14_materia2id_fk R
char_DataCore.MATERIA2ID <--MATERIA2ID_from_c14_materia2ID_fkey R
MATERIAL2 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
PARENTID int2 5 √ null
c14_materia2ID.MATERIA2ID c14_materia2id_fk R
MAT2_DESCR text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
c14_materia2ID_pkey Primary key Asc MATERIA2ID
c14_materia2id_MATERIAL2_ukey Must be unique Asc MATERIAL2

Relationships

Close relationships within degrees of separation