global_UnitMaster

607 rows


Description

Is the global master table that stores collection-unit related information for all compilations. Collection units are defined in the cabah_unittypeID table. In OCTOPUS data model hierarchy global_UnitMaster is situated between the collection-specific sample tables (subordinate) and the global_SiteMaster table (superordinate); (= SITEID). global_UnitMaster table is exclusively used for collections with a corresponding demand, i.e., will be bypassed for any collection that does not deal with multiple samples / observations from one and the same location / site / unit (e.g. a core).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
UNITID serial 10 √ nextval('"global_UnitMaster_UNITID_seq"'::regclass)
cabah_AnalysisUnit.UNITID Implied Constraint R
char_Sample.UNITID <--UNITID_from_global_UnitMaster_fkey R
global_DataSetMaster.UNITID <--UNITID_from_global_UnitMaster_fkey R
ippd_baseline_pollen.UNITID Implied Constraint R
ippd_datasets.UNITID Implied Constraint R
neo_chronologies.NEO_UNITID Implied Constraint R
neo_chronologies.UNITID <--UNITID_from_global_UnitMaster_fkey R
sahulchar.UNITID Implied Constraint R
sahulchar_units.UNITID Implied Constraint R
sahulchar_units_points_EPSG3857.UNITID Implied Constraint R
SITEID text 2147483647 null
global_SiteMaster.SITEID <--SITEID_from_global_SiteMaster_fkey R

Is fkey. Refer to global_SiteMaster table
UNITNAME text 2147483647 √ null

Name of the site
UNITHANDLE varchar 10 √ null

Code name for the Collection Unit. This code may be up to 10 characters, but an effort is made to keep these to 8 characters or less. Neither special characters nor whitespace allowed
UNITTYPEID int2 5 null
cabah_unittypeID.UNITTYPEID <--UNITTYPEID_from_cabah_unittypeID_fkey R

Is fkey. For available values refer to cabah_unittypeID table
COLLECTID int2 5 null
cabah_col_mtdID.COL_MTDID <--COL_MTDID_from_cabah_col_mtdID_fkey R

Is fkey. For available values refer to cabah_col_mtdID table
DEPOSITID int2 5 null
cabah_depositID.DEPOSITID <--DEPOSITID_from_cabah_depositID_fkey R

Is fkey. For available values refer to cabah_depositID table
COLLDATE varchar 10 √ NULL::character varying

Is unit collection date, if reported, at the highest possible dd/mm/yyyy level.
WATERDEPTH numeric 0 √ null

Water depth in m. (-9999.99 = no data)
NEO_HANDLE varchar 10 √ null

Is neotoma unit handle (if available)
UNIT_COMMT text 2147483647 √ null

Free text site 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
COLL_SPEC text 2147483647 √ null

Stores collection process specifics (if applicable)
IS_CHAR bool 1 false

Is this collection unit part of the SahulChar collection?
IS_IPPD bool 1 false

Is this collection unit part of the IPPD collection?
IS_NEOTOMA bool 1 false

Is this collection unit part of Neotoma db?
UNIT_REF text 2147483647 null
global_RefCore.REFDBID <--REFDBID_from_global_RefCore_fkey R

Is fkey. Refer to global_RefCore table
NEO_UNITID int4 10 √ null
cabah_AnalysisUnit.NEO_UNITID <--NEO_UNITID_from_global_UnitMaster_fkey R

Indexes

Constraint Name Type Sort Column(s)
global_UnitMaster_pkey Primary key Asc UNITID
global_UnitMaster_NEO_HANDLE_key Must be unique Asc NEO_HANDLE
global_unitmaster_NEO_UNITID_ukey Must be unique Asc NEO_UNITID
global_UnitMaster_UNITHANDLE_key Must be unique Asc UNITHANDLE

Relationships

Close relationships within degrees of separation