mysql> describe stores;
+-----------------+------------------+------+-----+---------+----------------+
| Field           | Type             | Null | Key | Default | Extra          |
+-----------------+------------------+------+-----+---------+----------------+
| id              | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| latitude        | float            | YES  |     | NULL    |                |
| longitude       | float            | YES  |     | NULL    |                |
| name            | varchar(50)      | YES  |     | NULL    |                |
| address_line_1  | varchar(40)      | YES  |     | NULL    |                |
| address_line_2  | varchar(40)      | YES  |     | NULL    |                |
| postal_code     | varchar(6)       | YES  |     | NULL    |                |
| city            | varchar(25)      | YES  |     | NULL    |                |
| telephone       | varchar(14)      | YES  |     | NULL    |                |
| fax             | varchar(14)      | YES  |     | NULL    |                |
| inventory_count | int(11)          | YES  |     | NULL    |                |
| products_count  | int(11)          | YES  |     | NULL    |                |
| sunday_open     | int(11)          | YES  |     | NULL    |                |
| sunday_close    | int(11)          | YES  |     | NULL    |                |
| monday_open     | int(11)          | YES  |     | NULL    |                |
| monday_close    | int(11)          | YES  |     | NULL    |                |
| tuesday_open    | int(11)          | YES  |     | NULL    |                |
| tuesday_close   | int(11)          | YES  |     | NULL    |                |
| wednesday_open  | int(11)          | YES  |     | NULL    |                |
| wednesday_close | int(11)          | YES  |     | NULL    |                |
| thursday_open   | int(11)          | YES  |     | NULL    |                |
| thursday_close  | int(11)          | YES  |     | NULL    |                |
| friday_open     | int(11)          | YES  |     | NULL    |                |
| friday_close    | int(11)          | YES  |     | NULL    |                |
| saturday_open   | int(11)          | YES  |     | NULL    |                |
| saturday_close  | int(11)          | YES  |     | NULL    |                |
+-----------------+------------------+------+-----+---------+----------------+


mysql> describe products;
+--------------------+------------------+------+-----+---------+----------------+
| Field              | Type             | Null | Key | Default | Extra          |
+--------------------+------------------+------+-----+---------+----------------+
| id                 | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| price_in_cents     | int(11)          | YES  |     | NULL    |                |
| name               | varchar(100)     | YES  |     | NULL    |                |
| stock_type         | varchar(10)      | YES  |     | NULL    |                |
| primary_category   | varchar(32)      | YES  |     | NULL    |                |
| secondary_category | varchar(32)      | YES  |     | NULL    |                |
| origin             | varchar(60)      | YES  |     | NULL    |                |
| package            | varchar(32)      | YES  |     | NULL    |                |
| alcohol_content    | int(11)          | YES  |     | NULL    |                |
| sugar_content      | varchar(5)       | YES  |     | NULL    |                |
| producer_name      | varchar(80)      | YES  |     | NULL    |                |
| inventory_count    | int(11)          | YES  |     | NULL    |                |
+--------------------+------------------+------+-----+---------+----------------+


mysql> describe inventories;
+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| id         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| store_id   | int(11)          | YES  | MUL | NULL    |                |
| product_id | int(11)          | YES  | MUL | NULL    |                |
| quantity   | int(11)          | YES  |     | NULL    |                |
| date       | date             | YES  | MUL | NULL    |                |
+------------+------------------+------+-----+---------+----------------+