View netapp_model_view.network_subnet 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 net subnet. Derived: {ipspace UUID}.subnet-name
resourceKey varchar 512
subnetName varchar 255 subnet name
subnet varchar 255  √  null subnet IP value
clusterId bigint 19 Cluseter objid hosting this subnet
broadcastDomainId bigint 19  √  null Layer 2 broadcast domain name that the subnet belongs to
ipSpaceId bigint 19 IPspace Name that the subnet belongs to
availableCount bigint 19  √  null Number of available pre-allocated addresses for the subnet
forceUpdateLifAssociations bit 0  √  null Setting this value to true will associate any manually addressed interfaces with the subnet.
gateway varchar 255  √  null The gateway for the default route of the subnet
ipranges text 65535  √  null The list of IP address ranges associated with the subnet
totalCount bigint 19  √  null Number of addresses pre-allocated for the subnet
usedCount bigint 19  √  null Number of addresses used from pre-allocated addresses for the subnet
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`network_subnet`.`objid` AS `objid`,`netapp_model`.`network_subnet`.`uuid` AS `uuid`,`netapp_model`.`network_subnet`.`resourceKey` AS `resourceKey`,`netapp_model`.`network_subnet`.`subnetName` AS `subnetName`,`netapp_model`.`network_subnet`.`subnet` AS `subnet`,`netapp_model`.`network_subnet`.`clusterId` AS `clusterId`,`netapp_model`.`network_subnet`.`broadcastDomainId` AS `broadcastDomainId`,`netapp_model`.`network_subnet`.`ipspaceId` AS `ipSpaceId`,`netapp_model`.`network_subnet`.`availableCount` AS `availableCount`,`netapp_model`.`network_subnet`.`forceUpdateLifAssociations` AS `forceUpdateLifAssociations`,`netapp_model`.`network_subnet`.`gateway` AS `gateway`,`netapp_model`.`network_subnet`.`ipranges` AS `ipranges`,`netapp_model`.`network_subnet`.`totalCount` AS `totalCount`,`netapp_model`.`network_subnet`.`usedCount` AS `usedCount`,`netapp_model`.`network_subnet`.`createtime` AS `createTime`,`netapp_model`.`network_subnet`.`updatetime` AS `updateTime` from `netapp_model`.`network_subnet` where (`netapp_model`.`network_subnet`.`objState` = 'LIVE')