Table mob_odm2.odm2.equipmentmodels 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
equipmentmodelid serial 10  √  nextval('odm2.equipmentmodels_equipmentmodelid_seq'::regclass)
equipment.equipmentmodelid fk_equipment_equipmentmodels C
instrumentoutputvariables.modelid fk_instrumentoutputvariables_equipmentmodels C
modelmanufacturerid int4 10
organizations.organizationid fk_equipmentmodels_organizations C
modelpartnumber varchar 50  √  null
modelname varchar 255
modeldescription varchar 5000  √  null
isinstrument bool 1
modelspecificationsfilelink varchar 255  √  null
modellink varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
equipmentmodelid Primary key Asc equipmentmodels_pkey

Close relationships  within of separation: