Skip to content

Instantly share code, notes, and snippets.

@nassredean

nassredean/window-blog-post-table-structure

Last active June 1, 2016 21:18
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save nassredean/4a4c09dce032af39ae5c5657a942b4fc to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save nassredean/4a4c09dce032af39ae5c5657a942b4fc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
window-blog-post-table-structure
SALES STORES
+------+-----------+------------+----------+--------------+ +------+---------------+
| id | user_id | store_id | amount | entered_at | | id | name |
|------+-----------+------------+----------+--------------| |------+---------------|
| 1 | 1 | 1 | 10000.0 | 2015-11-07 | | 1 | Gucci |
| 2 | 1 | 1 | 30000.0 | 2015-11-29 | | 2 | Louis Vuitton |
| 3 | 1 | 2 | 11000.0 | 2015-11-08 | | 3 | Fendi |
| 4 | 1 | 2 | 19000.0 | 2015-11-26 | +------+---------------+
| 5 | 1 | 3 | 14000.0 | 2015-11-15 |
| 6 | 1 | 3 | 14000.0 | 2015-11-23 | USERS
| 7 | 1 | 1 | 30000.0 | 2015-12-08 | +------+--------+
| 8 | 1 | 1 | 40000.0 | 2015-12-29 | | id | name |
| 9 | 1 | 2 | 10000.0 | 2015-12-01 | |------+--------|
| 10 | 1 | 2 | 11400.0 | 2015-12-14 | | 1 | Sarah |
| 11 | 1 | 3 | 21000.0 | 2015-12-26 | +------+--------+
| 12 | 1 | 3 | 21000.0 | 2015-12-26 |
+------+-----------+------------+----------+--------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment