chroncontroltypes

99 rows


Description

Lookup table of Chronology Control Types. This table is referenced by the ChronControls table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
chroncontroltypeid serial 10 nextval('ndb.seq_chroncontroltypes_chroncontroltypeid'::regclass)
chroncontrols.chroncontroltypeid fk_chroncontrols_chroncontroltypesC
chroncontroltypes.higherchroncontroltypeid fk_higherchroncontroltypeidR
eventtypes.chroncontroltypeid evt_cctR
chroncontroltype varchar 64 null
higherchroncontroltypeid int4 10 null
chroncontroltypes.chroncontroltypeid fk_higherchroncontroltypeidR
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
chroncontroltypes_pkey Primary key Asc chroncontroltypeid

Relationships