Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| staff_id | BIGINT UNSIGNED | 20 | null |
|
|
|||||
| store_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
ユーザー直近利用店舗選択の場合はnull |
|||
| first_channel_type | enum('line', 'sms', 'email', 'none') | 5 | null |
|
|
第一優先送信方法 |
||||
| second_channel_type | enum('line', 'sms', 'email', 'none') | 5 | null |
|
|
第二優先送信方法 |
||||
| third_channel_type | enum('line', 'sms', 'email', 'none') | 5 | null |
|
|
第三優先送信方法 |
||||
| is_send_all_channels | BIT | 1 | 0 |
|
|
全ての送信方法に送信するかどうか |
||||
| subject | VARCHAR | 255 | √ | null |
|
|
件名 |
|||
| body | LONGTEXT | 2147483647 | √ | null |
|
|
本文 |
|||
| submitted_at | TIMESTAMP | 26 | √ | null |
|
|
送信開始日時:下書きの場合はnull |
|||
| created_at | TIMESTAMP | 26 | √ | null |
|
|
||||
| updated_at | TIMESTAMP | 26 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| bulk_messages_staff_id_foreign | Performance | Asc | staff_id |
| bulk_messages_store_id_foreign | Performance | Asc | store_id |
Relationships
Close relationships within degrees of separation
