sys_activity_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
log_id INT 10 √ null
timestamp DATETIME 19 null
ip_addr VARCHAR 100 √ null
user VARCHAR 60 √ null
subject VARCHAR 100 √ null
body VARCHAR 5000 √ null
user_agent VARCHAR 512 √ null
version BIGINT 19 √ 1
context VARCHAR 255 √ null
proxy_user_id INT 10 √ null
sys_users.user_id FK27978646A1B485D2 R
source VARCHAR 255 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc log_id
FK27978646A1B485D2 Performance Asc proxy_user_id
sys_activity_log_subject Performance Asc subject
sys_activity_log_timestamp Performance Asc timestamp
sys_activity_log_user Performance Asc user

Relationships

Close relationships within degrees of separation