Fields (46)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | binary(16) | NO | PRI | NULL | |
| auto_increment | bigint unsigned | NO | UNI | NULL | auto_increment |
| customer_group_id | binary(16) | NO | MUL | NULL | |
| requested_customer_group_id | binary(16) | YES | MUL | NULL | |
| default_payment_method_id | binary(16) | NO | MUL | NULL | |
| sales_channel_id | binary(16) | NO | MUL | NULL | |
| language_id | binary(16) | NO | NULL | ||
| last_payment_method_id | binary(16) | YES | MUL | NULL | |
| default_billing_address_id | binary(16) | NO | MUL | NULL | |
| default_shipping_address_id | binary(16) | NO | MUL | NULL | |
| customer_number | varchar(255) | NO | NULL | ||
| salutation_id | binary(16) | YES | MUL | NULL | |
| first_name | varchar(255) | NO | NULL | ||
| last_name | varchar(255) | NO | NULL | ||
| company | varchar(255) | YES | NULL | ||
| password | varchar(1024) | YES | NULL | ||
| legacy_password | varchar(255) | YES | NULL | ||
| legacy_encoder | varchar(255) | YES | NULL | ||
| varchar(254) | NO | MUL | NULL | ||
| title | varchar(100) | YES | NULL | ||
| vat_ids | json | YES | NULL | ||
| active | tinyint(1) | NO | 1 | ||
| double_opt_in_registration | tinyint(1) | NO | 0 | ||
| double_opt_in_email_sent_date | datetime(3) | YES | NULL | ||
| double_opt_in_confirm_date | datetime(3) | YES | NULL | ||
| hash | varchar(255) | YES | UNI | NULL | |
| guest | tinyint(1) | NO | 0 | ||
| first_login | datetime(3) | YES | MUL | NULL | |
| last_login | datetime(3) | YES | MUL | NULL | |
| newsletter_sales_channel_ids | json | YES | NULL | ||
| birthday | date | YES | NULL | ||
| last_order_date | datetime(3) | YES | NULL | ||
| order_count | int | NO | 0 | ||
| order_total_amount | double | YES | 0 | ||
| custom_fields | json | YES | NULL | ||
| affiliate_code | varchar(255) | YES | NULL | ||
| campaign_code | varchar(255) | YES | NULL | ||
| created_at | datetime(3) | NO | NULL | ||
| updated_at | datetime(3) | YES | NULL | ||
| remote_address | varchar(255) | YES | NULL | ||
| tag_ids | json | YES | NULL | ||
| bound_sales_channel_id | binary(16) | YES | MUL | NULL | |
| created_by_id | binary(16) | YES | MUL | NULL | |
| updated_by_id | binary(16) | YES | MUL | NULL | |
| account_type | varchar(255) | NO | private | ||
| review_count | int | NO | 0 |
Indexes (17)
| Name | Columns | Unique |
|---|---|---|
| fk.customer.bound_sales_channel_id | bound_sales_channel_id | No |
| fk.customer.created_by_id | created_by_id | No |
| fk.customer.customer_group_id | customer_group_id | No |
| fk.customer.default_payment_method_id | default_payment_method_id | No |
| fk.customer.last_payment_method_id | last_payment_method_id | No |
| fk.customer.requested_customer_group_id | requested_customer_group_id | No |
| fk.customer.sales_channel_id | sales_channel_id | No |
| fk.customer.salutation_id | salutation_id | No |
| fk.customer.updated_by_id | updated_by_id | No |
| hash | hash | Yes |
| idx.customer.default_billing_address_id | default_billing_address_id | No |
| idx.customer.default_shipping_address_id | default_shipping_address_id | No |
| idx.email | No | |
| idx.firstlogin | first_login | No |
| idx.lastlogin | last_login | No |
| PRIMARY | id | Yes |
| uniq.auto_increment | auto_increment | Yes |