crn_projepsgID

121 rows


Description

Is CRN denudation lookup table. This table stores study-specific projection information (EPSG and human readable), i.e., the particular UTM projected coordinate system used for calculations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PROJEPSGID int2 5 null
crn_aus_basins.PROJEPSGID Implied Constraint R
crn_inprep_basins.PROJEPSGID Implied Constraint R
crn_int_basins.PROJEPSGID Implied Constraint R
crn_Sample.PROJEPSGID <--PROJEPSGID_from_crn_projepsgID_fkey R
crn_xxl_basins.PROJEPSGID Implied Constraint R
PROJECTION varchar 13 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)
crn_projepsgID_pkey Primary key Asc PROJEPSGID

Relationships