sed_geotypeID

16 rows


Description

Is across-Sahul Sedimentary Archives (SahulSed) lookup table for geomorphological type of feature sampled (= GEOTYPE)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
GEOTYPEID smallserial 5 nextval('sed_geotypeid_seq'::regclass)
sed_Sample.GEOTYPEID <--GEOTYPEID_from_sed_geotypeID_fkey R
GEOTYPE 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)
sed_geotypeID_pkey Primary key Asc GEOTYPEID
sed_geotypeid_GEOTYPE_ukey Must be unique Asc GEOTYPE

Relationships