notification_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 null
new_value LONGTEXT 2147483647 √ null
old_value LONGTEXT 2147483647 √ null
subject VARCHAR 50 null
table_name VARCHAR 50
target_id BIGINT 19 0
timestamp DATETIME 19 null
user_id INT 10 null
sys_users.user_id FK6012EDF028C762A3 R
proxy_user_id INT 10 √ null
sys_users.user_id FK6012EDF0A1B485D2 R
action_id INT 10 √ null
action_type VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK6012EDF028C762A3 Performance Asc user_id
FK6012EDF0A1B485D2 Performance Asc proxy_user_id
IX_notificationLog_timestamp Performance Asc timestamp

Relationships

Close relationships within degrees of separation