read_messages

317 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
message_id BIGINT UNSIGNED 20 null
messages.id read_messages_message_id_foreignR

メッセージID
staff_id BIGINT UNSIGNED 20 null
staffs.id read_messages_staff_id_foreignR

担当者ID
read_at TIMESTAMP 26 null

既読日時

Indexes

Constraint Name Type Sort Column(s)
read_messages_message_id_staff_id_unique Must be unique Asc/Asc message_id + staff_id
read_messages_staff_id_foreign Performance Asc staff_id

Relationships

Close relationships within degrees of separation