cabah_chroncontroltypeID

99 rows


Description

Is Neotoma-derived table for compilations dealing with chronologies, e.g. IPPD. This table, according to Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_chron.html#chroncontroltypes), stores chronology control types.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
CCONTRLID int4 10 null
cabah_chroncontroltypeID.PARENTID <--CCONTRLID_from_cabah_chroncontroltypeID_fkey R

Is original Neotoma chroncontroltypeid
CCONTRLTYP text 2147483647 null

Is type of chronology control
PARENTID int4 10 √ null
cabah_chroncontroltypeID.CCONTRLID <--CCONTRLID_from_cabah_chroncontroltypeID_fkey R

Is self reference to primary key, i.e., CCONTRLID
METHODID int4 10 √ null
cabah_methodID.METHODID <--METHODID_from_cabah_methodID_fkey R

Is cabah_methodID table fkey
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)
cabah_chroncontroltypeID_pkey Primary key Asc CCONTRLID

Relationships

Close relationships within degrees of separation