audit_logs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
account_id INT UNSIGNED 10 null
accounts.id audit_logs_account_id_foreign C
author_id INT UNSIGNED 10 √ null
users.id audit_logs_author_id_foreign N
about_contact_id INT UNSIGNED 10 √ null
contacts.id audit_logs_about_contact_id_foreign N
author_name VARCHAR 255 null
action VARCHAR 255 null
objects TEXT 65535 null
audited_at DATETIME 19 null
should_appear_on_dashboard BIT 1 0
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
audit_logs_about_contact_id_foreign Performance Asc about_contact_id
audit_logs_account_id_foreign Performance Asc account_id
audit_logs_author_id_foreign Performance Asc author_id

Relationships

Close relationships within degrees of separation