eventchronology

262 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
eventchronologyid serial 10 nextval('ndb.seq_eventchronology_eventchronologyid'::regclass)
analysisunitid int4 10 null
analysisunits.analysisunitid evc_aluR
eventid int4 10 null
events.eventid evc_evtR
notes text 2147483647 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null
chroncontrolid int4 10 null
chroncontrols.chroncontrolid evc_ccidR

Indexes

Constraint Name Type Sort Column(s)
eventchronology_pkey Primary key Asc eventchronologyid
ix_analysisunitid_eventchronology Performance Asc analysisunitid
ix_eventid_eventchronology Performance Asc eventid
uniqueeventset Must be unique Asc/Asc/Asc analysisunitid + eventid + chroncontrolid

Relationships