View netapp_model_view.namespace_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. ZAPIs: nvme-namespace-get-iter.nvme-namespace-info
uuid varchar 255 Globally unique ID of the Namespace
resourceKey varchar 512
qtreeId bigint 19  √  null
volumeId bigint 19
vserverId bigint 19
clusterId bigint 19
qosPolicyGroupId bigint 19  √  null
path varchar 255  √  null Path of the Namespace
subsystem varchar 255  √  null Subsystem of the Namespace
isReadOnly bit 0  √  null Is Namespace marked as Read Only?
restoreInaccessible bit 0  √  null mjk Is Namespace marked as Restore Inaccessible?
size bigint 19  √  null Size of the Namespace in bytes
sizeUsed bigint 19  √  null Used bytes in the Namespace
blockSize bigint 19  √  null Block size of the Namespace in bytes
state enum 11  √  null Accessible state of the Namespace
stateRaw varchar 255  √  null Accessible state of the Namespace - ZAPI raw value
osType enum 11  √  null OS type of the Namespace
osTypeRaw varchar 255  √  null OS type of the Namespace - ZAPI raw value
comment varchar 255  √  null User defined comments on Namespace
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`.`namespace`.`objid` AS `objid`,`netapp_model`.`namespace`.`uuid` AS `uuid`,`netapp_model`.`namespace`.`resourceKey` AS `resourceKey`,`netapp_model`.`namespace`.`qtreeId` AS `qtreeId`,`netapp_model`.`namespace`.`volumeId` AS `volumeId`,`netapp_model`.`namespace`.`vserverId` AS `vserverId`,`netapp_model`.`namespace`.`clusterId` AS `clusterId`,`netapp_model`.`namespace`.`qosPolicyGroupId` AS `qosPolicyGroupId`,`netapp_model`.`namespace`.`path` AS `path`,`netapp_model`.`namespace`.`subsystem` AS `subsystem`,`netapp_model`.`namespace`.`isReadOnly` AS `isReadOnly`,`netapp_model`.`namespace`.`restoreInaccessible` AS `restoreInaccessible`,`netapp_model`.`namespace`.`size` AS `size`,`netapp_model`.`namespace`.`sizeUsed` AS `sizeUsed`,`netapp_model`.`namespace`.`blockSize` AS `blockSize`,`netapp_model`.`namespace`.`state` AS `state`,`netapp_model`.`namespace`.`stateRaw` AS `stateRaw`,`netapp_model`.`namespace`.`osType` AS `osType`,`netapp_model`.`namespace`.`osTypeRaw` AS `osTypeRaw`,`netapp_model`.`namespace`.`comment` AS `comment`,`netapp_model`.`namespace`.`createtime` AS `createtime`,`netapp_model`.`namespace`.`updatetime` AS `updatetime`,`netapp_model`.`namespace`.`objState` AS `objState` from `netapp_model`.`namespace`