View netapp_model_view.application_record 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 ApplicationRecord. Not from ZAPI
resourceKey varchar 512 DERIVED. A structured key that may be used to uniquely identify this resource globally
clusterId bigint 19
recordName varchar 255  √  null The name of the record key to set the value.
recordValue varchar 512  √  null The value for the record key.
modifiedFrom varchar 255  √  null Location from where the value was last modified.
lastModifiedTimestamp timestamp 19  √  null Last time the value was modified.
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`application_record`.`objid` AS `objid`,`netapp_model`.`application_record`.`uuid` AS `uuid`,`netapp_model`.`application_record`.`resourceKey` AS `resourceKey`,`netapp_model`.`application_record`.`clusterId` AS `clusterId`,`netapp_model`.`application_record`.`recordName` AS `recordName`,`netapp_model`.`application_record`.`recordValue` AS `recordValue`,`netapp_model`.`application_record`.`modifiedFrom` AS `modifiedFrom`,`netapp_model`.`application_record`.`lastModifiedTimestamp` AS `lastModifiedTimestamp`,`netapp_model`.`application_record`.`createtime` AS `createTime`,`netapp_model`.`application_record`.`updatetime` AS `updateTime` from `netapp_model`.`application_record` where (`netapp_model`.`application_record`.`objState` = 'LIVE')