mysql> show columns from orders;
+-------------------------------+-----------------------------------------------------------                                                               --------------------+------+-----+---------------------+----------------+
| Field                         | Type                                                                                                                                         | Null | Key | Default             | Extra          |
+-------------------------------+-----------------------------------------------------------                                                               --------------------+------+-----+---------------------+----------------+
| oid                           | int(10) unsigned                                                                                                                             |      | PRI | NULL                | auto_increment |
| uid                           | int(10) unsigned                                                                                                                             |      | MUL | 0                   |                |
| order_num                     | int(10) unsigned                                                                                                                             |      |     | 0                   |                |
| create_date                   | datetime                                                                                                                                     |      |     | 0000-00-00 00:00:00 |                |
| status_date                   | datetime                                                                                                                                     |      |     | 0000-00-00 00:00:00 |                |
| status                        | enum('New','Abandon','Process','Backorder','Canceled','Com                                                               pleted','Failed')   |      | MUL | New                 |                |
| removed                       | enum('Yes','No')                                                                                                                             |      |     | No                  |                |
| attempts                      | tinyint(4)                                                                                                                                   |      |     | 0                   |                |
| payment_method_id             | int(10) unsigned                                                                                                                             |      |     | 0                   |                |
| payment_is_realtime           | enum('Yes','No')                                                                                                                             |      |     | No                  |                |
| payment_method_name           | varchar(100)                                                                                                                                 |      |     |                     |                |
| payment_gateway_id            | varchar(100)                                                                                                                                 |      |     |                     |                |
| payment_status                | enum('Pending','Partial','Received','Refunded','Declined',                                                               'Canceled','Error') |      |     | Pending             |                |
| shipping_digital              | tinyint(1) unsigned                                                                                                                          |      |     | 0                   |                |
| shipping_completed            | tinyint(1) unsigned                                                                                                                          |      |     | 0                   |                |
| shipping_ssid                 | varchar(100)                                                                                                                                 |      |     |                     |                |
| shipping_carrier_id           | varchar(255)                                                                                                                                 |      |     |                     |                |
| shipping_method_id            | varchar(100)                                                                                                                                 |      |     |                     |                |
| shipping_cm_name              | varchar(100)                                                                                                                                 |      |     |                     |                |
| shipping_amount               | decimal(20,5) unsigned                                                                                                                       |      |     | 0.00000             |                |
| shipping_taxable              | tinyint(1) unsigned                                                                                                                          |      |     | 0                   |                |
| shipping_tax_rate             | decimal(20,5) unsigned                                                                                                                       |      |     | 0.00000             |                |
| shipping_tax_amount           | decimal(20,5) unsigned                                                                                                                       |      |     | 0.00000             |                |
| shipping_tax_description      | text                                                                                                                                         |      |     |                     |                |
| shipping_tracking_number      | varchar(250)                                                                                                                                 |      |     |                     |                |
| shipping_tracking_number_type | varchar(100)                                                                                                                                 |      |     |                     |                |
| handling_separated            | tinyint(1)                                                                                                                                   |      |     | 0                   |                |
| handling_fee                  | decimal(20,5) unsigned                                                                                                                       |      |     | 0.00000             |                |
| handling_fee_type             | enum('percent','amount')                                                                                                                     |      |     | percent             |                |
| handling_amount               | decimal(20,5) unsigned                                                                                                                       |      |     | 0.00000             |                |
| handling_taxable              | tinyint(1) unsigned                                                                                                                          |      |     | 0                   |                |
| handling_tax_rate             | decimal(20,5)                                                                                                                                |      |     | 0.00000             |                |
| handling_tax_amount           | decimal(20,5)                                                                                                                                |      |     | 0.00000             |                |
| handling_tax_description      | text                                                                                                                                         |      |     |                     |                |
| handling_text                 | varchar(100)                                                                                                                                 |      |     |                     |                |
| subtotal_amount               | decimal(20,5) unsigned                                                                                                                       |      |     | 0.00000             |                |
| discount_amount               | decimal(20,5) unsigned                                                                                                                       |      |     | 0.00000             |                |
| discount_value                | decimal(20,5) unsigned                                                                                                                       |      |     | 0.00000             |                |
| discount_type                 | enum('percent','amount','none')                                                                                                              |      |     | none                |                |
| promo_campaign_id             | int(10) unsigned                                                                                                                             |      |     | 0                   |                |
| promo_discount_amount         | decimal(20,5)                                                                                                                                |      |     | 0.00000             |                |
| promo_discount_value          | decimal(20,5)                                                                                                                                |      |     | 0.00000             |                |
| promo_discount_type           | enum('percent','amount','none')                                                                                                              |      |     | none                |                |
| tax_amount                    | decimal(20,5) unsigned                                                                                                                       |      |     | 0.00000             |                |
| total_amount                  | decimal(20,5) unsigned                                                                                                                       |      |     | 0.00000             |                |
| comments                      | text                                                                                                                                         |      |     |                     |                |
| shipping_name                 | varchar(255)                                                                                                                                 |      |     |                     |                |
| shipping_company              | varchar(255)                                                                                                                                 |      |     |                     |                |
| shipping_address1             | varchar(255)                                                                                                                                 |      |     |                     |                |
| shipping_address2             | varchar(255)                                                                                                                                 |      |     |                     |                |
| shipping_city                 | varchar(255)                                                                                                                                 |      |     |                     |                |
| shipping_state                | int(10) unsigned                                                                                                                             |      |     | 0                   |                |
| shipping_province             | varchar(255)                                                                                                                                 |      |     |                     |                |
| shipping_zip                  | varchar(10)                                                                                                                                  |      |     |                     |                |
| shipping_country              | int(10) unsigned                                                                                                                             |      |     | 0                   |                |
| gift_message                  | text                                                                                                                                         |      |     |                     |                |
| security_id                   | varchar(100)                                                                                                                                 |      |     |                     |                |
| custom1                       | text                                                                                                                                         |      |     |                     |                |
| custom2                       | text                                                                                                                                         |      |     |                     |                |
| custom3                       | text                                                                                                                                         |      |     |                     |                |
+-------------------------------+---------------------------------------------------------