Table testdb.public.act_ru_meter_log Generated by
SchemaSpy
Legend:
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_ varchar 64
name_ varchar 64
reporter_ varchar 255  √  null
value_ int8 19  √  null
timestamp_ timestamp 29,6  √  null
milliseconds_ int8 19  √  0

Table contained 12 rows at Tue Nov 19 14:56 UTC 2024

Indexes:
Column(s) Type Sort Constraint Name
id_ Primary key Asc act_ru_meter_log_pkey
name_ + timestamp_ Performance Asc/Asc act_idx_meter_log
milliseconds_ Performance Asc act_idx_meter_log_ms
name_ + milliseconds_ Performance Asc/Asc act_idx_meter_log_name_ms
name_ + reporter_ + milliseconds_ Performance Asc/Asc/Asc act_idx_meter_log_report
timestamp_ Performance Asc act_idx_meter_log_time