| order_id |
int(11)
|
|
|
|
| invoice_no |
int(11)
|
|
|
|
| invoice_prefix |
varchar(26)
|
utf8mb4_unicode_ci
|
|
|
| store_id |
int(11)
|
|
|
|
| store_name |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| store_url |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| customer_id |
int(11)
|
|
|
|
| customer_group_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
|
|
|
| custom_field |
text
|
utf8mb4_unicode_ci
|
|
|
| payment_firstname |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| payment_lastname |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| payment_company |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| payment_address_1 |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| payment_address_2 |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| payment_city |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| payment_postcode |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| payment_country |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| payment_country_id |
int(11)
|
|
|
|
| payment_zone |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| payment_zone_id |
int(11)
|
|
|
|
| payment_address_format |
text
|
utf8mb4_unicode_ci
|
|
|
| payment_custom_field |
text
|
utf8mb4_unicode_ci
|
|
|
| payment_method |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| payment_code |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| shipping_firstname |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| shipping_lastname |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| shipping_company |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| shipping_address_1 |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| shipping_address_2 |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| shipping_city |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| shipping_postcode |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| shipping_country |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| shipping_country_id |
int(11)
|
|
|
|
| shipping_zone |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| shipping_zone_id |
int(11)
|
|
|
|
| shipping_address_format |
text
|
utf8mb4_unicode_ci
|
|
|
| shipping_custom_field |
text
|
utf8mb4_unicode_ci
|
|
|
| shipping_method |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| shipping_code |
varchar(128)
|
utf8mb4_unicode_ci
|
|
|
| comment |
text
|
utf8mb4_unicode_ci
|
|
|
| total |
decimal(15,4)
|
|
|
|
| order_status_id |
int(11)
|
|
|
|
| affiliate_id |
int(11)
|
|
|
|
| commission |
decimal(15,4)
|
|
|
|
| marketing_id |
int(11)
|
|
|
|
| tracking |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| language_id |
int(11)
|
|
|
|
| currency_id |
int(11)
|
|
|
|
| currency_code |
varchar(3)
|
utf8mb4_unicode_ci
|
|
|
| currency_value |
decimal(15,8)
|
|
|
|
| ip |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| forwarded_ip |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| user_agent |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| accept_language |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| date_added |
datetime
|
|
|
|
| date_modified |
datetime
|
|
|
|
