Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
PK |
|||
| customer_id | BIGINT UNSIGNED | 20 | null |
|
|
顧客ID |
||||
| store_customer_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
店舗別顧客ID |
|||
| store_name | VARCHAR | 255 |
|
|
店舗名 |
|||||
| category | enum('inquiry', 'auto_reply', 'message_send', 'message_receive', 'task_create', 'task_auto_create', 'task_edit', 'task_complete', 'task_incomplete', 'task_delete', 'customer_create', 'customer_auto_create', 'customer_edit', 'customer_status_change', 'staff_change', 'store_customer', 'line_friend', 'inquiry_create', 'inquiry_edit', 'suggestion_create', 'suggestion_edit', 'suggestion_delete', 'questionnaire_create', 'identify_customer', 'identify_related', 'external', 'suggestion_auto_create', 'message_delete', 'customer_refresh_auth_code', 'inquiry_delete') | 26 | null |
|
|
顧客履歴のカテゴリ |
||||
| function_type | enum('inquiry', 'suggestion', 'message', 'identify', 'task', 'customer', 'external', 'application', 'contract') | 11 | null |
|
|
機能の種類 |
||||
| operator_type | enum('customer', 'staff', 'crm', 'media', 'kimaroom', 'kimaroom_sign', 'external_system') | 15 | null |
|
|
実行者の種別 |
||||
| business_phase | enum('inquiry', 'visit', 'viewing', 'application', 'contract', 'lost') | 11 | √ | null |
|
|
業務フェーズ |
|||
| customer_status_name | VARCHAR | 255 | √ | null |
|
|
顧客ステータス名 |
|||
| operator_attribute1 | VARCHAR | 255 | null |
|
|
実施者の属性1(店舗名、顧客名など) |
||||
| operator_attribute2 | VARCHAR | 255 | null |
|
|
実施者の属性2(スタッフ名、顧客識別子など) |
||||
| operator | VARCHAR | 255 | √ | null |
|
|
実施者 |
|||
| target_type | enum('customer', 'staff', 'crm') | 8 | null |
|
|
対象者の種別 |
||||
| target_attribute1 | VARCHAR | 255 | null |
|
|
対象者の属性1(店舗名、顧客名など) |
||||
| target_attribute2 | VARCHAR | 255 | null |
|
|
対象者の属性2(スタッフ名、顧客識別子など) |
||||
| target | VARCHAR | 255 | √ | null |
|
|
対象者 |
|||
| summary | TEXT | 65535 | null |
|
|
内容欄に表示する変更概要 |
||||
| description | JSON | 1073741824 | null |
|
|
詳細 |
||||
| inquiry_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
反響ID |
|||
| message_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
メッセージID |
|||
| staff_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
操作した担当者ID |
|||
| last_values | JSON | 1073741824 | √ | null |
|
|
実行前の状態 |
|||
| current_values | JSON | 1073741824 | √ | 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 |
| customer_interaction_histories_customer_id_foreign | Performance | Asc | customer_id |
| customer_interaction_histories_inquiry_id_foreign | Performance | Asc | inquiry_id |
| customer_interaction_histories_message_id_foreign | Performance | Asc | message_id |
| customer_interaction_histories_staff_id_foreign | Performance | Asc | staff_id |
| customer_interaction_histories_store_customer_id_foreign | Performance | Asc | store_customer_id |
Relationships
Close relationships within degrees of separation
