stores

86 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
access_count_logs.store_id access_count_logs_store_id_foreignR
activity_logs.store_id activity_logs_store_id_foreignR
analysis_recounts.store_id analysis_recounts_store_id_foreignR
analysis_summaries.store_id analysis_summaries_store_id_foreignR
bulk_messages.store_id bulk_messages_store_id_foreignR
estimations.store_id estimations_store_id_foreignR
inquiry_forwarding_emails.store_id inquiry_forwarding_emails_store_id_foreignR
line_channels.store_id line_channels_store_id_foreignC
line_users.store_id line_users_store_id_foreignR
message_read_times.store_id message_read_times_store_id_foreignR
message_template_folders.store_id message_template_folders_store_id_foreignR
message_templates.store_id message_templates_store_id_foreignR
staffs.store_id staffs_store_id_foreignR
store_customers.store_id store_customers_store_id_foreignR
store_settings.store_id store_settings_store_id_foreignR
store_suggestion_settings.store_id store_suggestion_settings_store_id_foreignR
visit_reservation_settings.store_id visit_reservation_settings_store_id_foreignR
visit_reservations.store_id visit_reservations_store_id_foreignR

PK
company_id BIGINT UNSIGNED 20 null
companies.id stores_company_id_foreignR

会社ID
kimaroom_id BIGINT UNSIGNED 20 null

キマRoom!店舗ID
nested_group_id BIGINT UNSIGNED 20 √ null
nested_groups.id stores_nested_group_id_foreignR

グループID
name VARCHAR 255 null

店舗名
tel VARCHAR 20 null

店舗TEL
tel_end VARCHAR 20 null

エンド表示用tel
address_pref INT UNSIGNED 10 null

所在地:県(ID)
address_str VARCHAR 255 √ null

店舗住所文字列
code VARCHAR 10 null
sort_order TINYINT UNSIGNED 3 0

表示順
custom_name VARCHAR 40

顧客向け表示名
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
stores_code_unique Must be unique Asc code
stores_company_id_foreign Performance Asc company_id
stores_kimaroom_id_unique Must be unique Asc kimaroom_id
stores_nested_group_id_foreign Performance Asc nested_group_id

Relationships

Close relationships within degrees of separation