projectlist_run_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
duration INT 10 null
project_list_id INT 10 null
projectlist_custom.id FK484595D8D9B40676 R
returned_rows INT 10 √ null
run_parameters TEXT 65535 √ null
run_time DATETIME 23 null
summarized BIT 1 null
total_rows INT 10 √ null
user_id INT 10 √ null
sys_users.user_id FK484595D828C762A3 R
list_query LONGTEXT 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK484595D828C762A3 Performance Asc user_id
FK484595D8D9B40676 Performance Asc project_list_id
ix_projectlist_run_history_stats Performance Asc/Asc summarized + duration

Relationships

Close relationships within degrees of separation