Table mob_odm2.odm2.equipment 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
equipmentid serial 10  √  nextval('odm2.equipment_equipmentid_seq'::regclass)
calibrationreferenceequipment.equipmentid fk_calibrationreferenceequipment_equipment C
equipmentannotations.equipmentid fk_equipmentannotations_equipment C
equipmentused.equipmentid fk_equipmentactions_equipment C
relatedequipment.equipmentid fk_relatedequipment_equipment C
relatedequipment.relatedequipmentid fk_relatedequipment_equipment_arerelated C
equipmentcode varchar 50
equipmentname varchar 255
equipmenttypecv varchar 255
cv_equipmenttype.name fk_equipment_cv_equipmenttype C
equipmentmodelid int4 10
equipmentmodels.equipmentmodelid fk_equipment_equipmentmodels C
equipmentserialnumber varchar 50
equipmentownerid int4 10
people.personid fk_equipment_people C
equipmentvendorid int4 10
organizations.organizationid fk_equipment_organizations C
equipmentpurchasedate timestamp 29,6
equipmentpurchaseordernumber varchar 50  √  null
equipmentdescription varchar 5000  √  null
equipmentdocumentationlink varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
equipmentid Primary key Asc equipment_pkey
equipmentcode Must be unique Asc equipment_equipmentcode_key

Close relationships  within of separation: