report_run_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
run_time DATETIME 23 null
report_id INT 10 null
reports.report_id FK_report_history_report C
duration INT 10 null
returned_rows INT 10 √ null
total_rows INT 10 √ null
user_id INT 10 √ null
sys_users.user_id FK_report_history_user R
summarized BIT 1 b'0'
source VARCHAR 10 √ null
run_parameters TEXT 65535 √ null
list_query LONGTEXT 2147483647 √ null
error TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IX_report_history_report Performance Asc report_id
IX_report_history_user Performance Asc user_id

Relationships

Close relationships within degrees of separation