| id | int(11) | NO | PRI | NULL | |
| email | varchar(70) | YES | | NULL | |
| active | int(1) | YES | | NULL | |
| accountmode | int(11) | YES | | NULL | |
| firstlogin | date | YES | | NULL | |
| newsletter | int(1) | YES | | NULL | |
| shop_id | int(11) | YES | | NULL | |
| default_billing_address_id | int(11) | YES | | NULL | |
| title | varchar(100) | YES | | NULL | |
| salutation | varchar(30) | YES | | NULL | |
| firstname | varchar(255) | YES | | NULL | |
| lastname | varchar(255) | YES | | NULL | |
| birthday | date | YES | | NULL | |
| customernumber | varchar(30) | YES | | NULL | |
| customer_group_id | int(11) | YES | | NULL | |
| customer_group_name | varchar(255) | YES | | NULL | |
| payment_id | int(11) | YES | | NULL | |
| company | varchar(255) | YES | | NULL | |
| department | varchar(255) | YES | | NULL | |
| street | varchar(255) | YES | | NULL | |
| zipcode | varchar(255) | YES | | NULL | |
| city | varchar(255) | YES | | NULL | |
| phone | varchar(255) | YES | | NULL | |
| additional_address_line1 | varchar(255) | YES | | NULL | |
| additional_address_line2 | varchar(255) | YES | | NULL | |
| country_id | int(11) | YES | | NULL | |
| country_name | varchar(255) | YES | | NULL | |
| state_id | int(11) | YES | | NULL | |
| age | int(11) | YES | | NULL | |
| count_orders | int(11) | YES | | NULL | |
| invoice_amount_sum | double | YES | | NULL | |
| invoice_amount_avg | double | YES | | NULL | |
| invoice_amount_min | double | YES | | NULL | |
| invoice_amount_max | double | YES | | NULL | |
| first_order_time | date | YES | | NULL | |
| last_order_time | date | YES | | NULL | |
| has_canceled_orders | int(1) | YES | | NULL | |
| product_avg | double | YES | | NULL | |
| ordered_at_weekdays | text | YES | | NULL | |
| ordered_in_shops | text | YES | | NULL | |
| ordered_on_devices | text | YES | | NULL | |
| ordered_with_deliveries | text | YES | | NULL | |
| ordered_with_payments | text | YES | | NULL | |
| ordered_products | longtext | YES | | NULL | |
| ordered_products_of_categories | longtext | YES | | NULL | |
| ordered_products_of_manufacturer | longtext | YES | | NULL | |
| index_time | datetime | NO | | NULL | |