customers

144980 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
access_count_logs.customer_id access_count_logs_customer_id_foreignR
access_count_urls.customer_id access_count_urls_customer_id_foreignR
aggregation_candidates.customer_id1 aggregation_candidates_customer_id1_foreignR
aggregation_candidates.customer_id2 aggregation_candidates_customer_id2_foreignR
aggregation_releases.customer_id aggregation_releases_customer_id_foreignR
aggregation_releases.released_customer_id aggregation_releases_released_customer_id_foreignR
aggregations.customer_id aggregations_customer_id_foreignR
aggregations.delete_customer_id aggregations_delete_customer_id_foreignR
appointments.customer_id appointments_customer_id_foreignR
bulk_operation_customer_lists.customer_id bulk_operation_customer_lists_customer_id_foreignR
bulk_operation_history_customer.customer_id bulk_operation_history_customer_customer_id_foreignR
customer_addition_item_values.customer_id customer_addition_item_values_customer_id_foreignC
customer_interaction_histories.customer_id customer_interaction_histories_customer_id_foreignR
estimations.contractor_id estimations_contractor_id_foreignR
line_users.customer_id line_users_customer_id_foreignR
message_read_times.customer_id message_read_times_customer_id_foreignR
relationship_candidates.customer_id1 relationship_candidates_customer_id1_foreignR
relationship_candidates.customer_id2 relationship_candidates_customer_id2_foreignR
relationships.customer_id relationships_customer_id_foreignR
relationships.related_customer_id relationships_related_customer_id_foreignR
store_customers.customer_id store_customers_customer_id_foreignR
visit_reservations.customer_id visit_reservations_customer_id_foreignR

PK
uuid VARCHAR 36 null

UUID
company_id BIGINT UNSIGNED 20 null
companies.id customers_company_id_foreignR

会社ID
full_name VARCHAR 255 √ null

顧客名
full_name_text VARCHAR 255 √ null

顧客名(全スペース除去)
first_name VARCHAR 255

顧客名（名）
last_name VARCHAR 255

顧客名（姓）
full_name_kana VARCHAR 255 √ null

顧客名カナ
full_name_kana_text VARCHAR 255 √ null

顧客名カナ(全スペース除去)
first_name_kana VARCHAR 255

顧客名カナ（名）
last_name_kana VARCHAR 255

顧客名カナ（姓）
email VARCHAR 255

メールアドレス
tel VARCHAR 255

電話番号
gender enum('male', 'female', 'unknown') 7 unknown

性別
is_suspicious_person BIT 1 0

要注意人物フラグ
customer_type JSON 1073741824 null

顧客属性
birthday DATE 10 √ null

生年月日
address_zip_code VARCHAR 7

現住所・郵便番号
address_pref VARCHAR 255

現住所・都道府県
address_city VARCHAR 255

現住所・市町村
address_town VARCHAR 255

現住所・住所3
address_chome VARCHAR 255

現住所・住所4
address_ban VARCHAR 255

現住所・住所5
address_gou VARCHAR 255

現住所・住所6
address_building VARCHAR 255

現住所・建物名
address_number VARCHAR 255

現住所・号室
email_json JSON 1073741824 null

メールアドレス情報
tel_json JSON 1073741824 null

電話番号情報
mobile_json JSON 1073741824 null

携帯電話番号情報
condition_area_json JSON 1073741824 null

希望エリア
time_to_station VARCHAR 3

駅徒歩(分)
virtual_bank_account_code VARCHAR 4 √ null

バーチャル口座：口座コード
virtual_bank_account_number VARCHAR 7 √ null

バーチャル口座：口座番号
memo TEXT 65535 null

メモ
search_item_1 VARCHAR 255

検索項目１
search_item_2 VARCHAR 255

検索項目２
search_item_3 VARCHAR 255

検索項目３
denied_aggregation BIT 1 0

名寄せポップアップを表示しない
denied_relative BIT 1 0

関係者ポップアップを表示しない
aggregation_created_at DATETIME 26 √ null

名寄せして作られた日時
external_system_type VARCHAR 20 √ null

外部(基幹)システムの識別子
external_system_customer_code VARCHAR 36 √ null

外部(基幹)システム上の顧客コード
questionnaire_status enum('unrequested', 'requested', 'answered') 11 unrequested

アンケートステータス
questionnaire_at TIMESTAMP 26 √ null

アンケート回答日時
text_for_search MEDIUMTEXT 16777215 √ 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
customers_company_id_foreign Performance Asc company_id
customers_uuid_unique Must be unique Asc uuid

Relationships

Close relationships within degrees of separation