cabah_basinsizeID

6 rows


Description

Is lookup table for charcoal-related compilations, i.e., SahulCHAR. This table, according to the Global Paleofire Database (https://www.paleofire.org/) template, stores arbitrary water body area classes (basin = water body itself).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
BASINSZEID serial 10 nextval('"cabah_basinsizeID_BASINSZEID_seq"'::regclass)
global_SiteMaster.BASINSZEID <--BASINSZEID_from_cabah_basinsizeID_fkey R
BASINSIZE varchar 3 null
BASINAREA 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_basinsizeID_pkey Primary key Asc BASINSZEID
cabah_basinsizeID_BASINSIZE_key Must be unique Asc BASINSIZE

Relationships