neo_elementtypes

939 rows


Description

Is a Neotoma lookup lookup table of Element types. This table is refrences by the neo_variableelements table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ELEMTYPEID int4 10 null
neo_variableelements.ELEMTYPEID <--ELEMTYPEID_from_neo_elementtypes_fkey R

Is the original Neotoma elementtypeid
ELEMENTYPE text 2147483647 null

Is the original Neotoma element type descriptor
DATASRCID int2 5 √ null
cabah_datasourceID.DATASRCID <--DATASRCID_from_cabah_datasourceID_fkey R

Is an fkey to the cabah_datasourceID table
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)
neo_elementtypes_pkey Primary key Asc ELEMTYPEID

Relationships

Close relationships within degrees of separation