vendor_task_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 null
body LONGTEXT 2147483647 √ null
proxy_user_id INT 10 √ null
sys_users.user_id FK_orou2mp2xrrltwxqcce69klo3 R
source VARCHAR 255 null
subject VARCHAR 100 √ null
timestamp DATETIME 23 null
user_id INT 10 √ null
sys_users.user_id FK_4bgp7por47y9v8ea4ancyfchq R
vendor_task_id BIGINT 19 null
vendor_task.id FK_chf0w1cvdxmk4r7l9xhfinkhu R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_4bgp7por47y9v8ea4ancyfchq Performance Asc user_id
FK_chf0w1cvdxmk4r7l9xhfinkhu Performance Asc vendor_task_id
FK_orou2mp2xrrltwxqcce69klo3 Performance Asc proxy_user_id

Relationships

Close relationships within degrees of separation