reports


Columns

Column Type Size Nulls Auto Default Children Parents Comments
report_id INT 10 √ null
dashboard_widget.report_id FKA2DF1E4F7D387CEC R
feed_export.report_id FK1BA73D757D387CEC R
report_run_history.report_id FK_report_history_report C
reports_chart_value.report_id FK7B91F7507D387CEC R
reports_column.report_id FK8DE3D9D67D387CEC R
reports_link_value.report_id FKA690076C7D387CEC R
reports_variable_default.report_id FK314AF9FE7D387CEC R
title VARCHAR 50 null
description VARCHAR 200 √ null
report_sql LONGTEXT 2147483647 null
publish_roles VARCHAR 500 √ null
active BIT 1 b'0'
summary_table LONGTEXT 2147483647 √ null
chart VARCHAR 50 √ null
link VARCHAR 100 √ null
cache_minutes INT 10 1
category_column VARCHAR 255 √ null
category_exclude LONGTEXT 2147483647 √ null
freeze_columns INT 10 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc report_id
title Must be unique Asc title

Relationships

Close relationships within degrees of separation