cabah_depositID

119 rows


Description

Is lookup table for Sahul-related compilations. The cabah_depositID table stores the type of deposit sampled.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
DEPOSITID serial 10 √ nextval('"cabah_depositID_DEPOSITID_seq"'::regclass)
cabah_AnalysisUnit.FACIESID <--DEPOSITID_from_cabah_depositID_fkey R
cabah_depositID.PARENTID <--DEPOSITID_from_cabah_depositID_fkey R
global_UnitMaster.DEPOSITID <--DEPOSITID_from_cabah_depositID_fkey R
DEPOSIT text 2147483647 null
PARENTID int2 5 null
cabah_depositID.DEPOSITID <--DEPOSITID_from_cabah_depositID_fkey R
DEPOSITDSC 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)
cabah_depositID_pkey Primary key Asc DEPOSITID
cabah_depositID_DEPOSIT_key Must be unique Asc DEPOSIT

Relationships

Close relationships within degrees of separation