global_MetaSite

12144 rows


Description

Is global master table that stores metasite-related information for all compilations. In OCTOPUS data model hierarchy global_MetaSite is superordinate to global_SiteMaster, <collection name>_Sample, and <sub-collection name>_DataCore tables (in this decreasing order). However, whilst the latter three levels can’t be ‘NULL’, “METASITE” is quasi nullable (= METASITE).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
METASITEID text 2147483647 null
expage.METASITEID Implied Constraint R
fossahul_webmercator_nrand_25000.METASITEID Implied Constraint R
global_SiteMaster.METASITEID <--METASITEID_from_global_MetaSite_fkey R
ippd_datasets.METASITEID Implied Constraint R
sahularch_c14.METASITEID Implied Constraint R
sahularch_osl.METASITEID Implied Constraint R
sahularch_tl.METASITEID Implied Constraint R
sahulchar.METASITEID Implied Constraint R
sahulchar_units.METASITEID Implied Constraint R
sahulsed_aeolian_osl.METASITEID Implied Constraint R
sahulsed_aeolian_tl.METASITEID Implied Constraint R
sahulsed_fluvial_osl.METASITEID Implied Constraint R
sahulsed_fluvial_tl.METASITEID Implied Constraint R
sahulsed_lacustrine_osl.METASITEID Implied Constraint R
sahulsed_lacustrine_tl.METASITEID Implied Constraint R
METANAME text 2147483647 null
META_WKT text 2147483647 null

Reserved for spatial extent of METASITE expressed as WKT polygon (well known text).
META_AREA numeric 0 null

Is METASITE AREA (in square kilometers, 2 digits precision)
META_COMMT text 2147483647 √ null

Freestyle text METASITE comment field
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
META_DESCR text 2147483647 √ null
FEATURESRC int2 5 √ null
cabah_datasourceID.DATASRCID <--DATASRCID_from_cabah_datasourceID_fkey R
FEATURETYP int2 5 √ null
global_SiteCode.SITECODEID <--SITECODEID_from_global_SiteCode_fkey R

Indexes

Constraint Name Type Sort Column(s)
GLOBAL_Metasite_pkey Primary key Asc METASITEID

Relationships

Close relationships within degrees of separation