message_threads

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
messages.thread_id messages_thread_id_fkey R
user_id INT 10 null
users.id message_threads_user_id_fkey R
shop_id INT 10 null
shops.id message_threads_shop_id_fkey R
last_message_id INT 10 √ null
messages.id message_threads_last_message_id_fkey N
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_message_threads_last_message Performance Asc last_message_id
message_threads_last_message_id_key Must be unique Asc last_message_id
message_threads_shop_id_fkey Performance Asc shop_id
uniq_user_shop_thread Must be unique Asc/Asc user_id + shop_id

Relationships

Close relationships within degrees of separation