mysql> desc orders;
+-------------------------------+---------------+------+-----+---------+----------------+
| Field                         | Type          | Null | Key | Default | Extra          |
+-------------------------------+---------------+------+-----+---------+----------------+
| id                            | int(11)       | NO   | PRI | NULL    | auto_increment |
| billing_address_id            | int(11)       | NO   |     | NULL    |                |
| shipping_address_id           | int(11)       | NO   |     | NULL    |                |
| subtotal                      | decimal(16,2) | NO   |     | NULL    |                |
| shipping                      | decimal(10,2) | NO   |     | NULL    |                |
| taxes                         | decimal(16,2) | NO   |     | NULL    |                |
| total                         | decimal(16,2) | NO   |     | NULL    |                |
| created_at                    | datetime      | YES  |     | NULL    |                |
| updated_at                    | datetime      | YES  |     | NULL    |                |
| shipping_method               | varchar(40)   | NO   |     | NULL    |                |
| ip_address                    | varchar(15)   | NO   |     | NULL    |                |
| email                         | varchar(255)  | NO   |     | NULL    |                |
| completed_at                  | datetime      | YES  | MUL | NULL    |                |
| gift_card_number              | varchar(255)  | YES  |     | NULL    |                |
| gift_card_amount_applied      | decimal(16,2) | NO   |     | 0.00    |                |
| credit_card_amount_applied    | decimal(16,2) | NO   |     | 0.00    |                |
| delta                         | tinyint(1)    | NO   |     | NULL    |                |
| card_expiration_encrypted     | blob          | YES  |     | NULL    |                |
| billing_first_name_encrypted  | blob          | YES  |     | NULL    |                |
| billing_last_name_encrypted   | blob          | YES  |     | NULL    |                |
| shipping_first_name_encrypted | blob          | YES  |     | NULL    |                |
| shipping_last_name_encrypted  | blob          | YES  |     | NULL    |                |
| card_type_encrypted           | blob          | YES  |     | NULL    |                |
| card_number_encrypted         | blob          | YES  |     | NULL    |                |
| user_id                       | int(11)       | YES  | MUL | NULL    |                |
+-------------------------------+---------------+------+-----+---------+----------------+
25 rows in set (0.01 sec)