| userid |
int(11)
|
|
|
|
| company |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| vat |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| phonenumber |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| country |
int(11)
|
|
|
|
| city |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| zip |
varchar(15)
|
utf8mb4_unicode_ci
|
|
|
| state |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| address |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| website |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| datecreated |
datetime
|
|
|
|
| active |
int(11)
|
|
|
|
| leadid |
int(11)
|
|
|
|
| billing_street |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| billing_city |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| billing_state |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| billing_zip |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| billing_country |
int(11)
|
|
|
|
| shipping_street |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| shipping_city |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| shipping_state |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| shipping_zip |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| shipping_country |
int(11)
|
|
|
|
| longitude |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| latitude |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| default_language |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| default_currency |
int(11)
|
|
|
|
| show_primary_contact |
int(11)
|
|
|
|
| stripe_id |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| registration_confirmed |
int(11)
|
|
|
|
| addedfrom |
int(11)
|
|
|
|
| woo_customer_id |
int(11)
|
|
|
|
| woo_channel_id |
int(11)
|
|
|
|
| client_type |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|