| id |
int(10)
|
|
|
|
| channel |
enum('woocommerce', 'mercadolibre', 'facebook', 'b2b_direct')
|
utf8mb4_unicode_ci
|
|
|
| external_order_id |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| customer_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| customer_email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| customer_phone |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| shipping_address |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| postal_code |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| city |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| state |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| total_amount |
decimal(12,2)
|
|
|
|
| payment_status |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| operational_status |
enum('nuevo', 'en_taller_morelia', 'biselado_quirurgico', 'control_calidad', 'empaque', 'enviado', 'entregado')
|
utf8mb4_unicode_ci
|
|
|
| tracking_number |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| ready_for_guide |
tinyint(1)
|
|
|
|
| discount_total |
decimal(12,2)
|
|
|
|
| coupon_codes |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
