Table JiveCore900.public.jivemetering 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
plaindate int8 19
encrypteddate varchar 64
component varchar 255
resourcetype varchar 255
encryptedusageamt varchar 255
lastupdatets int8 19  √  null
isadjustment int2 5

Table contained 1,164 rows at Fri Jan 13 13:20 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
plaindate + component + resourcetype + isadjustment Performance Asc/Asc/Asc/Asc jvmtr_uk_idx