View netapp_model_view.plex_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 Object ID within the platform server. ZAPIs: aggr-get-iter.aggr-attributes.plex-info
uuid varchar 255 Globally unique ID of the plex. Not available in ZAPI. Uses {AggregateUUID}.{PlexName}
resourceKey varchar 512
name varchar 255 Textual name
aggregateId bigint 19
clusterId bigint 19
nodeId bigint 19
isOnline bit 0  √  null if plex is online
status enum 19  √  null The plex status.
statusRaw varchar 45  √  null The plex status. Raw value from ZAPI
resyncPercent int 10  √  null PLEX resyncing percentage
createTime bigint 19
updateTime bigint 19
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`plex`.`objid` AS `objid`,`netapp_model`.`plex`.`uuid` AS `uuid`,`netapp_model`.`plex`.`resourceKey` AS `resourceKey`,`netapp_model`.`plex`.`name` AS `name`,`netapp_model`.`plex`.`aggregateId` AS `aggregateId`,`netapp_model`.`plex`.`clusterId` AS `clusterId`,`netapp_model`.`plex`.`nodeId` AS `nodeId`,`netapp_model`.`plex`.`isOnline` AS `isOnline`,`netapp_model`.`plex`.`status` AS `status`,`netapp_model`.`plex`.`statusRaw` AS `statusRaw`,`netapp_model`.`plex`.`resyncPercent` AS `resyncPercent`,`netapp_model`.`plex`.`createtime` AS `createTime`,`netapp_model`.`plex`.`updatetime` AS `updateTime`,`netapp_model`.`plex`.`objState` AS `objState` from `netapp_model`.`plex`