cabah_AnalysisUnit

15022 rows


Description

Is Neotoma-derived table for compilations dealing with analysis units, e.g. IPPD. This table, according to Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_samples.html#analysisunits), stores analysis units, i.e., depth increments / bins that are considered analytical entities. Prior to db intake, this table has been filtered so it stores OCTOPUS relevant analysis units only. IMPORTANT NOTE: The primary key values have been migrated unaltered from Neotoma. Therefore, database relations will only work (and be updatable from the Neotoma source) if these ID stays untouched.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ANLYSUNTID int4 10 null
ippd_Sample.ANLYSUNTID <--ANLYSUNTID_from_cabah_AnalysisUnit_fkey R

Is original Neotoma analysisunitid
NEO_UNITID int4 10 null
global_UnitMaster.NEO_UNITID <--NEO_UNITID_from_global_UnitMaster_fkey R
AUIT_NAME text 2147483647 √ null
AUIT_DEPTH numeric 0 √ null
AUIT_THICK numeric 0 √ null
FACIESID int2 5 √ null
cabah_depositID.DEPOSITID <--DEPOSITID_from_cabah_depositID_fkey R
AUIT_MIXED bool 1 √ null
AUIT_ISGN text 2147483647 √ null
AUIT_NOTES 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
UNITID int4 10 √ null
global_UnitMaster.UNITID Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
cabah_analysisunitID_pkey Primary key Asc ANLYSUNTID

Relationships

Close relationships within degrees of separation