global_SiteMaster

26209 rows


Description

Is the global master table that stores site-related information for all compilations. In OCTOPUS data model hierarchy global_SiteMaster is situated between the collection-specific sample tables (subordinate) and the global_MetaSite table (superordinate); (= SITEID).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SITEID text 2147483647 null
arch_Sample.SITEID <--SITEID_from_global_SiteMaster_fkey R
crn_Sample.SITEID <--SITEID_from_global_SiteMaster_fkey R
expage.SITEID Implied Constraint R
expage_Sample.SITEID <--SITEID_from_global_SiteMaster_fkey R
fos_Sample.SITEID <--SITEID_from_global_SiteMaster_fkey R
fossahul_webmercator_nrand_25000.SITEID Implied Constraint R
global_UnitMaster.SITEID <--SITEID_from_global_SiteMaster_fkey R
ippd_baseline_pollen.SITEID Implied Constraint R
ippd_datasets.SITEID Implied Constraint R
sahularch_c14.SITEID Implied Constraint R
sahularch_osl.SITEID Implied Constraint R
sahularch_tl.SITEID Implied Constraint R
sahulchar.SITEID Implied Constraint R
sahulchar_units.SITEID Implied Constraint R
sahulsed_aeolian_osl.SITEID Implied Constraint R
sahulsed_aeolian_tl.SITEID Implied Constraint R
sahulsed_coastal_osl.SITEID Implied Constraint R
sahulsed_coastal_tl.SITEID Implied Constraint R
sahulsed_fluvial_osl.SITEID Implied Constraint R
sahulsed_fluvial_tl.SITEID Implied Constraint R
sahulsed_lacustrine_osl.SITEID Implied Constraint R
sahulsed_lacustrine_tl.SITEID Implied Constraint R
sed_Sample.SITEID <--SITEID_from_global_SiteMaster_fkey R
METASITEID text 2147483647 √ null
global_MetaSite.METASITEID <--METASITEID_from_global_MetaSite_fkey R
CNTRY varchar 2147483647 null
REGION_INT text 2147483647 √ null
REGION_REG varchar 2147483647 √ null
DIV_ADMIN varchar 2147483647 √ null
DIV_OTHER text 2147483647 √ null
ISL_NAME text 2147483647 √ null
LAKE text 2147483647 √ null
BASIN text 2147483647 √ null
RIVID int2 5 √ null
global_rivID.RIVID <--RIVID_from_global_rivID_fkey R
IBRAID int2 5 √ null
global_ibraID.IBRAID <--IBRAID_from_global_ibraID_fkey R
X_WGS84 numeric 10,6 √ null
Y_WGS84 numeric 10,6 √ null
CORDS_ELEV varchar 2147483647 null
ELEVATION numeric 6,2 √ null
SITENAME text 2147483647 √ null
SITE_SPEC text 2147483647 √ null
ALTNAME1 text 2147483647 √ null
ALTNAME2 text 2147483647 √ null
ALTNAME3 text 2147483647 √ null
SITECODEID int2 5 √ null
global_SiteCode.SITECODEID <--SITECODEID_from_global_SiteCode_fkey R
OPENCLOSED varchar 2147483647 √ null
SITE_COMMT 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
BIOMEID int4 10 √ null
global_biomeID.BIOMEID <--BIOMEID_from_global_biomeID_fkey R
CATCHSZEID int2 5 √ null
cabah_catchmentsizeID.CATCHSZEID <--CATCHSZEID_from_cabah_catchmentsizeID_fkey R
BASINSZEID int2 5 √ null
cabah_basinsizeID.BASINSZEID <--BASINSZEID_from_cabah_basinsizeID_fkey R
FLOWTYPEID int2 5 √ null
cabah_flowtypeID.FLOWTYPEID <--FLOWTYPEID_from_cabah_flowtypeID_fkey R
NEO_SITEID int4 10 √ null

Is the corresponding neotoma/IPPD site ID, if applicable
SITEDESCR text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
global_SiteMaster_pkey Primary key Asc SITEID

Relationships

Close relationships within degrees of separation