project_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
project_id INT 10 √ null
project.id FKC7FFE91EFE2B983 R
user_id INT 10 null
sys_users.user_id FKC7FFE91E28C762A3 R
timestamp DATETIME 19 null
subject VARCHAR 80 √ null
body VARCHAR 1000 √ null
version BIGINT 19 √ 1
target_id INT 10 √ null
site_id INT 10 √ null
site.id FKC7FFE91E92D2B99F R
proxy_user_id INT 10 √ null
sys_users.user_id FKC7FFE91EA1B485D2 R
source VARCHAR 255 null
action_id INT 10 √ null
action_type VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FKC7FFE91E28C762A3 Performance Asc user_id
FKC7FFE91E92D2B99F Performance Asc site_id
FKC7FFE91EA1B485D2 Performance Asc proxy_user_id
FKC7FFE91EFE2B983 Performance Asc project_id
idx_project_log_field_query Performance Asc/Asc/Asc/Asc project_id + subject + target_id + id
idx_project_log_target_id Performance Asc target_id
idx_project_log_timestamp Performance Asc/Asc timestamp + subject

Relationships

Close relationships within degrees of separation