| customer_id |
int(11)
|
|
|
|
| customer_group_id |
int(11)
|
|
|
|
| store_id |
int(11)
|
|
|
|
| language_id |
int(11)
|
|
|
|
| firstname |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| lastname |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(96)
|
utf8mb4_unicode_ci
|
|
|
| telephone |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| fax |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| password |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| salt |
varchar(9)
|
utf8mb4_unicode_ci
|
|
|
| cart |
text
|
utf8mb4_unicode_ci
|
|
|
| wishlist |
text
|
utf8mb4_unicode_ci
|
|
|
| newsletter |
tinyint(1)
|
|
|
|
| address_id |
int(11)
|
|
|
|
| custom_field |
text
|
utf8mb4_unicode_ci
|
|
|
| ip |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| status |
tinyint(1)
|
|
|
|
| safe |
tinyint(1)
|
|
|
|
| token |
text
|
utf8mb4_unicode_ci
|
|
|
| code |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| date_added |
datetime
|
|
|
|