Table ocum.switch 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
id bigint 19
interswitchconnection.firstSwitch_id InterSwitchConnection_firstSwitch_id_FK R
interswitchconnection.secondSwitch_id InterSwitchConnection_secondSwitch_id_FK R
nodeswitchconnection.switch_id NodeSwitchConnection_switch_id_FK R
switchbridgeconnection.switch_id SwitchBridgeConnection_switch_id_FK R
switchinterswitchrelationship.switch_id SwitchInterSwitchRelationship_switch_id_FK C
objVersion int 10
objectName varchar 255
resourceKey varchar 512
healthStatus int 10
cluster_id bigint 19
wwn varchar 255
status varchar 255  √  null
domainId int 10  √  null
role varchar 20  √  null
fabricName varchar 255  √  null
vendor varchar 20  √  null
model varchar 255  √  null
firmwareVersion varchar 255  √  null
ipAddress varchar 255  √  null
totalTemperatureSensorCount int 10  √  null
totalpowerSupplyCount int 10  √  null
totalFanCount int 10  √  null

Table contained 0 rows at Tue Apr 23 05:29 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
wwn + cluster_id Must be unique Asc/Asc Switch_wwn_UQ

Close relationships  within of separation: