+-----------+------------+-----------+
| good_code | store_code | name      |
+-----------+------------+-----------+
| 80085236  | 730        | June 2017 |
+-----------+------------+-----------+
|  80085236 | 714        | May 2017  |
+-----------+------------+-----------+

+-----------+-------------------------+-------------------------+
| name      | start                   | end                     |
+-----------+-------------------------+-------------------------+
| May 2017  | 2017-05-16 00:00:00.000 | 2017-05-29 00:00:00.000 |
+-----------+-------------------------+-------------------------+
| June 2017 | 2017-06-18 00:00:00.000 | 2017-07-25 00:00:00.000 |
+-----------+-------------------------+-------------------------+
| July 2017 | 2017-07-16 00:00:00.000 | 2017-07-20 00:00:00.000 |
+-----------+-------------------------+-------------------------+

+-----------+------------+-------------------------+-------------------------+
| good_code | store_code | start                   | end                     |
+-----------+------------+-------------------------+-------------------------+
| 10009662  | 31254      | 2011-02-14 00:00:00.000 | 1900-01-01 00:00:00.000 |
+-----------+------------+-------------------------+-------------------------+
| 10009654  | 576        | 2017-05-16 00:00:00.000 | 2017-08-16 00:00:00.000 |
+-----------+------------+-------------------------+-------------------------+
| 10009654  | 730        | 2016-03-16 00:00:00.000 | 2016-11-16 00:00:00.000 |
+-----------+------------+-------------------------+-------------------------+

+---------+-----------+
| good_id | good_code |
+---------+-----------+
| 1       | 80085236  |
+---------+-----------+
| 24      | 80085236  |
+---------+-----------+

+----------+------------+
| store_id | store_code |
+----------+------------+
| 31       | 730        |
+----------+------------+
| 56       | 714        |
+----------+------------+

+----------+----------+---------+-------+
| date_id  | store_id | good_id | promo |
+----------+----------+---------+-------+
| 20170619 | 31       | 1       | NULL  |
+----------+----------+---------+-------+
| 20170718 | 56       | 24      | NULL  |
+----------+----------+---------+-------+