Table ocum.volume 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
infinitevolhistorymonth.volumeId InfiniteVolHistoryMonth_volumeId_FK C
infinitevolhistoryweek.volumeId InfiniteVolHistoryWeek_volumeId_FK C
infinitevolhistoryyear.volumeId InfiniteVolHistoryYear_volumeId_FK C
storageservicenodemember.volume_id StorageServiceNodeMember_volume_id_FK N
volume.namespaceConstituent_id Volume_namespaceConstituent_id_FK N
volume.unAvailableParentVolumeId Volume_unAvailableParentVolumeId_FK N
volumegrowthrateinfo.volume_id VolumeGrowthRateInfo_volume_id_FK C
volumehistorymonth.volumeId VolumeHistoryMonth_volumeId_FK C
volumehistoryweek.volumeId VolumeHistoryWeek_volumeId_FK C
volumehistoryyear.volumeId VolumeHistoryYear_volumeId_FK C
volumejunctionpathhistory.volume_id VolumeJunctionPathHistory_volume_id_FK C
volumeregressioninfo.volume_id VolumeRegressionInfo_volume_id_FK C
vserver.metadataVolumeId Vserver_metadataVolumeId_FK C
cluster_id bigint 19  √  null
lastSync bigint 19
systemStorageClass_id bigint 19  √  null
storageclass.id Volume_systemStorageClass_id_FK N
namespaceConstituent_id bigint 19  √  null
volume.id Volume_namespaceConstituent_id_FK N
healthStatus int 10
isSnapMirrorDestination bit 1  √  b'0'
dfSnapshotBytesUsed double 22  √  null
dfSnapshotBytesAvail double 22  √  null
unAvailableParentVolumeId bigint 19  √  null
volume.id Volume_unAvailableParentVolumeId_FK N
aggregateCount int 10  √  1
nodeCount int 10  √  1

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
cluster_id Performance Asc Volume_cluster_IX
namespaceConstituent_id Performance Asc Volume_namespaceConstituent_id_FK
systemStorageClass_id Performance Asc Volume_systemStorageClass_id_FK
unAvailableParentVolumeId Performance Asc Volume_unAvailableParentVolumeId_FK

Close relationships  within of separation: