synctoken


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
account_id INT UNSIGNED 10 null
accounts.id synctoken_account_id_foreign C
user_id INT UNSIGNED 10 null
users.id synctoken_user_id_foreign C
name VARCHAR 255 contacts
timestamp TIMESTAMP 19 CURRENT_TIMESTAMP
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
synctoken_account_id_user_id_name_index Performance Asc/Asc/Asc account_id + user_id + name
synctoken_user_id_foreign Performance Asc user_id

Relationships

Close relationships within degrees of separation