global_rivID

219 rows


Description

Is parent table for global_SiteMaster table. The latter stores site related information for collection-dependent sample tables. global_rivID stores information about the Geofabric AHGF river region membership of a certain site (= AHGFL1, AHGFL2, RIVDIV).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
RIVID int2 5 null
global_SiteMaster.RIVID <--RIVID_from_global_rivID_fkey R
AHGFL1 varchar 3 null
AHGFL2 varchar 6 null
RIVNAME text 2147483647 null
RIVDIV 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_rivID_pkey Primary key Asc RIVID
global_rivid_AHGFL2_ukey Must be unique Asc AHGFL2

Relationships