cabah_methodID

103 rows


Description

Is lookup table for Sahul-related compilations, i.e., SahulArch, FosSahul, SahulSed. This table stores the type of method used in age determination (= METHOD, = FOS_MTD).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
METHODID smallserial 5 √ nextval('cabah_methodid_seq'::regclass)
arch_c14_DataCore.METHODID <--METHODID_from_cabah_methodID_fkey R
arch_osl_DataCore.METHODID <--METHODID_from_cabah_methodID_fkey R
arch_tl_DataCore.METHODID <--METHODID_from_cabah_methodID_fkey R
cabah_chroncontroltypeID.METHODID <--METHODID_from_cabah_methodID_fkey R
cabah_methodID.PARENTID cabah_methodid_fk R
char_DataCore.METHODID <--METHODID_from_cabah_methodID_fkey R
fos_DataCore.FOS_MTDID <--METHODID_from_CABAH_methodID_fkey R
sed-osl_DataCore.METHODID <--METHODID_from_cabah_methodID_fkey R
sed-tl_DataCore.METHODID <--METHODID_from_cabah_methodID_fkey R
METHOD text 2147483647 null
METHODABBR 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
cabah_methodID.METHODID cabah_methodid_fk R
METHODREF text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
cabah_methodID_pkey Primary key Asc METHODID
cabah_methodid_METHOD_ukey Must be unique Asc METHOD
cabah_methodID_METHODABBR_ukey Must be unique Asc METHODABBR

Relationships

Close relationships within degrees of separation