Shopware 5.7.1 s_customer_search_index
Pre-computed customer search index for fast backend customer lookup.
| Column | Type | Nullable | Additional |
| id | int(11) | NO | Primary Key |
| email | varchar(70) | YES | |
| active | int(1) | YES | |
| accountmode | int(11) | YES | |
| firstlogin | date | YES | |
| newsletter | int(1) | YES | |
| shop_id | int(11) | YES | |
| default_billing_address_id | int(11) | YES | |
| title | varchar(100) | YES | |
| salutation | varchar(30) | YES | |
| firstname | varchar(255) | YES | |
| lastname | varchar(255) | YES | |
| birthday | date | YES | |
| customernumber | varchar(30) | YES | |
| customer_group_id | int(11) | YES | |
| customer_group_name | varchar(255) | YES | |
| payment_id | int(11) | YES | |
| company | varchar(255) | YES | |
| department | varchar(255) | YES | |
| street | varchar(255) | YES | |
| zipcode | varchar(255) | YES | |
| city | varchar(255) | YES | |
| phone | varchar(255) | YES | |
| additional_address_line1 | varchar(255) | YES | |
| additional_address_line2 | varchar(255) | YES | |
| country_id | int(11) | YES | |
| country_name | varchar(255) | YES | |
| state_id | int(11) | YES | |
| age | int(11) | YES | |
| count_orders | int(11) | YES | |
| invoice_amount_sum | double | YES | |
| invoice_amount_avg | double | YES | |
| invoice_amount_min | double | YES | |
| invoice_amount_max | double | YES | |
| first_order_time | date | YES | |
| last_order_time | date | YES | |
| has_canceled_orders | int(1) | YES | |
| product_avg | double | YES | |
| ordered_at_weekdays | text | YES | |
| ordered_in_shops | text | YES | |
| ordered_on_devices | text | YES | |
| ordered_with_deliveries | text | YES | |
| ordered_with_payments | text | YES | |
| ordered_products | longtext | YES | |
| ordered_products_of_categories | longtext | YES | |
| ordered_products_of_manufacturer | longtext | YES | |
| index_time | datetime | NO | |
| Index Name | Columns | Unique |
| PRIMARY | id | Yes |
