View netapp_model_view.vserver_name_mapping 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.
uuid varchar 255 Globally unique ID of the VServer Name Mapping. Equal to {VserverUUID}.{direction}.{position} Not returned from ZAPI
resourceKey varchar 512 DERIVED. A structured key that may be used to uniquely identify this resource globally
clusterId bigint 19
vserverId bigint 19
position int 10 Position of an existing name mapping in the list of name mappings for this Vserver
direction enum 11  √  null The vserver name mapping direction
directionRaw varchar 255  √  null The vserver name mapping direction - ZAPI raw value
pattern varchar 255  √  null Pattern to use to match the name while searching for a name that can be used as a replacement
replacement varchar 255  √  null The name that is to be used as a replacement if the pattern associated with this entry matches
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`vserver_name_mapping`.`objid` AS `objid`,`netapp_model`.`vserver_name_mapping`.`uuid` AS `uuid`,`netapp_model`.`vserver_name_mapping`.`resourceKey` AS `resourceKey`,`netapp_model`.`vserver_name_mapping`.`clusterId` AS `clusterId`,`netapp_model`.`vserver_name_mapping`.`vserverId` AS `vserverId`,`netapp_model`.`vserver_name_mapping`.`position` AS `position`,`netapp_model`.`vserver_name_mapping`.`direction` AS `direction`,`netapp_model`.`vserver_name_mapping`.`directionRaw` AS `directionRaw`,`netapp_model`.`vserver_name_mapping`.`pattern` AS `pattern`,`netapp_model`.`vserver_name_mapping`.`replacement` AS `replacement`,`netapp_model`.`vserver_name_mapping`.`createtime` AS `createTime`,`netapp_model`.`vserver_name_mapping`.`updatetime` AS `updateTime` from `netapp_model`.`vserver_name_mapping` where (`netapp_model`.`vserver_name_mapping`.`objState` = 'LIVE')