View netapp_model_view.snaplock_full 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 Locally unique object identifier.
originid bigint 19
uuid varchar 255 Globally unique ID of the SnapLock table
resourceKey varchar 255
clusterId bigint 19
volumeId bigint 19
type enum 12  √  null SnapLock Type for volume and its vserver
typeRaw varchar 64  √  null
minimumRetentionPeriod varchar 64  √  null Specifies the allowed minimum retention period for files to be committed to WORM state on the volume.
defaultRetentionPeriod varchar 64  √  null Specifies the default retention period that will be applied to files when committed to WORM state if files has no explicit retention retention time set.
maximumRetentionPeriod varchar 64  √  null Specifies the allowed maxmium retention period for files to be committed to WORM state on the volume.
autoCommitPeriod varchar 64  √  null Specifies the autocommit period for the SnapLock volume. All files which are not modified for a period greater than the autocommit period of the volume are committed to WORM state
volumeExpiryTime varchar 64  √  null Specifies the expiry time of the volume.
privilegedDeleteState varchar 64  √  null Specifies the prvileged delete state on Snaplock Volume.
volumeComplianceClock bigint 19  √  null Specifies the volume ComplianceClock of the volume.
objState enum 5  √  null

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`snaplock`.`objid` AS `objid`,`netapp_model`.`snaplock`.`originid` AS `originid`,`netapp_model`.`snaplock`.`uuid` AS `uuid`,`netapp_model`.`snaplock`.`resourceKey` AS `resourceKey`,`netapp_model`.`snaplock`.`clusterId` AS `clusterId`,`netapp_model`.`snaplock`.`volumeId` AS `volumeId`,`netapp_model`.`snaplock`.`type` AS `type`,`netapp_model`.`snaplock`.`typeRaw` AS `typeRaw`,`netapp_model`.`snaplock`.`minimumRetentionPeriod` AS `minimumRetentionPeriod`,`netapp_model`.`snaplock`.`defaultRetentionPeriod` AS `defaultRetentionPeriod`,`netapp_model`.`snaplock`.`maximumRetentionPeriod` AS `maximumRetentionPeriod`,`netapp_model`.`snaplock`.`autoCommitPeriod` AS `autoCommitPeriod`,`netapp_model`.`snaplock`.`volumeExpiryTime` AS `volumeExpiryTime`,`netapp_model`.`snaplock`.`privilegedDeleteState` AS `privilegedDeleteState`,`netapp_model`.`snaplock`.`volumeComplianceClock` AS `volumeComplianceClock`,`netapp_model`.`snaplock`.`objState` AS `objState` from `netapp_model`.`snaplock`