Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| store_id | BIGINT UNSIGNED | 20 | null |
|
|
|||||
| enable_inquiry_reply_message | BIT | 1 | null |
|
|
反響応答メッセージ_有効フラグ |
||||
| inquiry_reply_message_subject | VARCHAR | 255 |
|
|
カスタム反響応答メッセージ件名 |
|||||
| inquiry_reply_message_body | TEXT | 65535 | null |
|
|
カスタム反響応答メッセージ |
||||
| initial_customer_rank | enum('A', 'B', 'C', 'D') | 1 | null |
|
|
ランク |
||||
| enable_rental_search | BIT | 1 | 0 |
|
|
|||||
| rental_search_form | JSON | 1073741824 | √ | null |
|
|
借主が検索する際の基礎絞り込み条件 |
|||
| enable_bulk_message | BIT | 1 | 0 |
|
|
一括送信機能の使用可否 |
||||
| enable_auto_suggestion | BIT | 1 | 0 |
|
|
自動物件提案の使用可否 |
||||
| enable_direct_reply | BIT | 1 | 0 |
|
|
メール直接返信の使用可否 |
||||
| enable_notification_task_setting | BIT | 1 | 0 |
|
|
通知タスク設定の使用可否 |
||||
| sendable_bulk_message_to_other_stores_customer | BIT | 1 | 0 |
|
|
他店舗顧客への一括送信可否 |
||||
| 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 |
| store_settings_store_id_unique | Must be unique | Asc | store_id |
Relationships
Close relationships within degrees of separation
