store_customers

158442 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
analysis_log_per_customers.store_customer_id analysis_log_per_customers_store_customer_id_foreignR
analysis_log_per_rentals.store_customer_id analysis_log_per_rentals_store_customer_id_foreignR
auto_suggestion_settings.store_customer_id auto_suggestion_settings_store_customer_id_foreignR
auto_suggestions.store_customer_id auto_suggestions_store_customer_id_foreignR
contact_rentals.store_customer_id contact_rentals_store_customer_id_foreignR
customer_interaction_histories.store_customer_id customer_interaction_histories_store_customer_id_foreignR
favorite_rentals.store_customer_id favorite_rentals_store_customer_id_foreignR
inquiries.store_customer_id inquiries_store_customer_id_foreignR
line_users.store_customer_id line_users_store_customer_id_foreignR
messages.store_customer_id messages_store_customer_id_foreignR
store_customer_event_dates.store_customer_id store_customer_event_dates_store_customer_id_foreignR
suggestions.store_customer_id suggestions_store_customer_id_foreignR
task_settings.store_customer_id task_settings_store_customer_id_foreignR
tasks.store_customer_id tasks_store_customer_id_foreignR
web_meetings.store_customer_id web_meetings_store_customer_id_foreignR
customer_id BIGINT UNSIGNED 20 null
customers.id store_customers_customer_id_foreignR

顧客ID
store_id BIGINT UNSIGNED 20 null
stores.id store_customers_store_id_foreignR

担当店舗ID
customer_status_id BIGINT UNSIGNED 20 null
customer_statuses.id store_customers_customer_status_id_foreignR

顧客ステータスID
latest_accessed_datetime DATETIME 26 √ null

最終アクセス日時
latest_sent_datetime DATETIME 26 √ null

最終送信日時
latest_received_datetime DATETIME 26 √ null

最終受信日時
rank enum('A', 'B', 'C', 'D') 1 null

ランク
main_staff_id BIGINT UNSIGNED 20 √ null
staffs.id store_customers_main_staff_id_foreignR

主担当
inquiry_staff_id BIGINT UNSIGNED 20 √ null
staffs.id store_customers_inquiry_staff_id_foreignR

反響担当
visit_staff_id BIGINT UNSIGNED 20 √ null
staffs.id store_customers_visit_staff_id_foreignR

来店担当
viewing_staff_id BIGINT UNSIGNED 20 √ null
staffs.id store_customers_viewing_staff_id_foreignR

案内担当
application_staff_id BIGINT UNSIGNED 20 √ null
staffs.id store_customers_application_staff_id_foreignR

申込担当
contract_staff_id BIGINT UNSIGNED 20 √ null
staffs.id store_customers_contract_staff_id_foreignR

契約担当
aggregation_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
store_customers_application_staff_id_foreign Performance Asc application_staff_id
store_customers_contract_staff_id_foreign Performance Asc contract_staff_id
store_customers_customer_id_store_id_unique Must be unique Asc/Asc customer_id + store_id
store_customers_customer_status_id_foreign Performance Asc customer_status_id
store_customers_deleted Performance Asc/Asc/Asc deleted_at + aggregation_at + store_id
store_customers_inquiry_staff_id_foreign Performance Asc inquiry_staff_id
store_customers_main_staff_id_foreign Performance Asc main_staff_id
store_customers_store_id_foreign Performance Asc store_id
store_customers_viewing_staff_id_foreign Performance Asc viewing_staff_id
store_customers_visit_staff_id_foreign Performance Asc visit_staff_id

Relationships

Close relationships within degrees of separation