Table opm.capacity_tier_analysis 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
id bigint 19  √ 
timestamp bigint 19 0
objectId bigint 19
objectName varchar 225
resourceKey varchar 512
resourceType smallint 5
element_type_definition.id capacityTierAnalysis_ResourceType_fk R
cloudRecommendation enum 46 LEARNING
recommendationData json 0  √  null
coldData bigint 19  √  null This is the inactive data in bytes - null if not detected yet
coldDataPercent bigint 19  √  null This is the inactive data as a percentage of used data - null if not detected yet

Table contained 344 rows at Tue Apr 23 04:58 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
objectId + timestamp Performance Asc/Asc capacityTierAnalysis_objectId_timestamp_index
resourceType Performance Asc capacityTierAnalysis_ResourceType_fk

Close relationships  within of separation: