punch_list_item_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
activity VARCHAR 80 null
field VARCHAR 255 √ null
item_id BIGINT 19 null
punch_list_item.id FK_8d9o4xvhashai2g3tad53mwus R
new_value LONGTEXT 2147483647 √ null
old_value LONGTEXT 2147483647 √ null
proxy_user_id INT 10 √ null
sys_users.user_id FK_m8ls0xyo42a6wjfp8mvrko72p R
timestamp DATETIME 19 null
user_id INT 10 null
sys_users.user_id FK_41da01jis0i8wpyxlkwiwjpfp R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_41da01jis0i8wpyxlkwiwjpfp Performance Asc user_id
FK_8d9o4xvhashai2g3tad53mwus Performance Asc item_id
FK_m8ls0xyo42a6wjfp8mvrko72p Performance Asc proxy_user_id

Relationships

Close relationships within degrees of separation