activity_log

4693235 rows


Description

Keeps Activity data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
log_name VARCHAR 125 √ null
description MEDIUMTEXT 16777215 null
subject_type VARCHAR 125 √ null
subject_id VARCHAR 125 √ null
event VARCHAR 125 √ null
causer_type VARCHAR 125 √ null

user table

causer_id VARCHAR 125 √ null

user id

properties LONGTEXT 2147483647 √ null
batch_uuid CHAR 36 √ null
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
activity_log_log_name_index Performance Asc log_name
activity_log_subject_id_IDX Performance Asc subject_id
causer_id Performance Asc causer_id

Relationships