intake_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 null
message VARCHAR 1000 √ null
intake_id BIGINT 19 null
intake.id FK_intakelogticket R
proxy_user_id INT 10 √ null
sys_users.user_id FK_intakelogproxy R
subject VARCHAR 50 √ null
timestamp DATETIME 23 null
user_id INT 10 √ null
sys_users.user_id FK_intakeloguser R
old_value VARCHAR 2000 √ null
new_value VARCHAR 2000 √ null
field VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_intakelogproxy Performance Asc proxy_user_id
FK_intakelogticket Performance Asc intake_id
FK_intakeloguser Performance Asc user_id

Relationships

Close relationships within degrees of separation