messages

1415 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
customer_interaction_histories.message_id customer_interaction_histories_message_id_foreignR
message_destinations.message_id message_destinations_message_id_foreignR
read_messages.message_id read_messages_message_id_foreignR
reserve_messages.message_id reserve_messages_message_id_foreignR
suggestions.message_id suggestions_message_id_foreignR

PK
store_customer_id BIGINT UNSIGNED 20 null
store_customers.id messages_store_customer_id_foreignR

店舗別顧客ID
staff_id BIGINT UNSIGNED 20 √ null
staffs.id messages_staff_id_foreignR

送信者の従業員ID
bulk_message_id BIGINT UNSIGNED 20 √ null
bulk_messages.id messages_bulk_message_id_foreignN
sender_type enum('customer', 'staff', 'system') 8 null

送り主種別
channel_type enum('line', 'sms', 'email', 'web') 5 null

メッセージ種別
subject VARCHAR 255

件名
body LONGTEXT 2147483647 null

本文
is_notify_failed BIT 1 0

通知送信(Mail/SMS/Lineなど)に失敗
submitted_at TIMESTAMP 26 √ null
mail_opened_at TIMESTAMP 26 √ null

メール開封日時
read_at TIMESTAMP 26 √ null

既読日時
replied_at TIMESTAMP 26 √ null

返信日時
created_at TIMESTAMP 26 √ null
updated_at TIMESTAMP 26 √ null
deleted_at TIMESTAMP 26 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
messages_bulk_message_id_foreign Performance Asc bulk_message_id
messages_staff_id_foreign Performance Asc staff_id
messages_store_customer_id_foreign Performance Asc store_customer_id

Relationships

Close relationships within degrees of separation