Table opm.continuous_event_participant_stats 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  √ 
eventParticipantId bigint 19
continuous_event_participant.id continuous_eventParticipantId_fk_1 C
time bigint 19
statType smallint 5
stat_type_definition.id statTypeDefinition_ibfk_1 R
currentStatisticValue float 12  √  null
avgStatisticValue float 12  √  null
forecastStatisticValue float 12  √  null
dynamicRangeChange float 12  √  null
absChangeStatisticValue float 12  √  null
dynState smallint 5  √  null
dyn_state_definition.id dynStateDefinition_ibfk_1 R
upperThreshold float 12  √  null
lowerThreshold float 12  √  null
linearTrend float 12  √  null

Table contained 14,879 rows at Tue Apr 23 04:58 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
dynState Performance Asc dynStateDefinition
eventParticipantId + time + statType Must be unique Asc/Asc/Asc eventParticipantId_time_statType
statType Performance Asc statTypeDefinition_ibfk_1

Close relationships  within of separation: