Table ocum.snapmirrortransfer 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
objVersion int 10
snapMirrorRelationshipId bigint 19  √  null
snapmirrorrelationship.id SnapMirrorTransfer_snapMirrorRelationshipId_FK C
dataCollectionTimestamp timestamp 19 CURRENT_TIMESTAMP
lastTransferEndTimestamp timestamp 19  √  null
state enum 12  √  null
isMissingData bit 1  √  null
lagDuration bigint 19  √  null
bytesTransferred bigint 19  √  null
transferDuration bigint 19  √  null
transferError varchar 1024  √  null
lagErrorThreshold bigint 19  √  null
lagWarningThreshold bigint 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
dataCollectionTimestamp Performance Asc SnapMirrorTransfer_dataCollectionTimestamp_IX
snapMirrorRelationshipId Performance Asc SnapMirrorTransfer_snapMirrorRelationship_IX

Close relationships  within of separation: