Table opm.s_all_lifs_periodic 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
objid bigint 19 0
name varchar 255  √  null
resourceKey varchar 512  √  null
role varchar 255  √  null
type varchar 255  √  null
numberOfHours smallint 5  √  null
latency float 12  √  null
ops float 12  √  null
throughput float 12  √  null
clusterId bigint 19  √  null
clusterName varchar 255  √  null
clusterResourceKey varchar 512  √  null
homeNodeId bigint 19  √  null
homeNodeName varchar 255  √  null
homeNodeResourceKey varchar 512  √  null
currentNodeId bigint 19  √  null
currentNodeName varchar 255  √  null
currentNodeResourceKey varchar 512  √  null
homePortId bigint 19  √  null
homePortName varchar 255  √  null
homePortResourceKey varchar 512  √  null
currentPortId bigint 19  √  null
currentPortName varchar 255  √  null
currentPortResourceKey varchar 512  √  null
homeLocation varchar 255  √  null
currentLocation varchar 255  √  null
svmId bigint 19  √  null
svmName varchar 255  √  null
svmResourceKey varchar 512  √  null
thresholdPolicyId varchar 512  √  null
thresholdPolicyName text 65535  √  null
eventSeverity smallint 5  √  null
clusterFqdn varchar 255  √  null

Table contained 49 rows at Tue Apr 23 04:58 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
objid Primary key Asc PRIMARY
clusterName Performance Asc cluster_name
currentLocation Performance Asc current_location
homeLocation Performance Asc home_location
name Performance Asc lif_name
type Performance Asc lif_type
svmName Performance Asc svm_name