Table mob_odm2.odm2.actions Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
actionid serial 10  √  nextval('odm2.actions_actionid_seq'::regclass)
actionannotations.actionid fk_actionannotations_actions C
actionby.actionid fk_actionpeople_actions C
actiondirectives.actionid fk_actiondirectives_actions C
actionextensionpropertyvalues.actionid fk_actionextensionpropertyvalues_actions C
calibrationactions.actionid fk_calibrationactions_actions C
equipmentused.actionid fk_equipmentactions_actions C
featureactions.actionid fk_featureactions_actions C
maintenanceactions.actionid fk_maintenanceactions_actions C
relatedactions.actionid fk_relatedactions_actions C
relatedactions.relatedactionid fk_relatedactions_actions_arerelated C
simulations.actionid fk_simulations_actions C
actiontypecv varchar 255
cv_actiontype.name fk_actions_cv_actiontype C
methodid int4 10
methods.methodid fk_actions_methods C
begindatetime timestamp 29,6
begindatetimeutcoffset int4 10
enddatetime timestamp 29,6  √  null
enddatetimeutcoffset int4 10  √  null
actiondescription varchar 5000  √  null
actionfilelink varchar 255  √  null

Table contained 0 rows at Fri Mar 08 15:58 PST 2019

Indexes:
Column(s) Type Sort Constraint Name
actionid Primary key Asc actions_pkey

Close relationships  within of separation: