Skip to content

Instantly share code, notes, and snippets.

@ChadTaljaardt

ChadTaljaardt/database

Created February 14, 2017 15:29
Show Gist options
  • Save ChadTaljaardt/14beb7a3e7a34eb46ad8ca49c4525780 to your computer and use it in GitHub Desktop.
Save ChadTaljaardt/14beb7a3e7a34eb46ad8ca49c4525780 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
database
mysql> SELECT * FROM plates;
+--------------------------------------+---------+---------------------+---------------------+
| id | plate | created_at | updated_at |
+--------------------------------------+---------+---------------------+---------------------+
| e0dd8fd5-88c8-479c-902a-c4b80842ecac | RX61GDU | 2017-02-11 21:36:34 | 2017-02-11 21:36:34 |
| 4e055fc0-bd83-4452-a0d2-1bc41d18c35d | | 2017-02-13 17:47:32 | 2017-02-13 17:47:32 |
| 6bd341f2-ac9c-44b3-bb39-9c824d4002ed | AE02RYA | 2017-02-14 02:28:20 | 2017-02-14 15:18:57 |
+--------------------------------------+---------+---------------------+---------------------+
3 rows in set (0.00 sec)
mysql> SELECT * from detections;
+--------------------------------------+--------------------------------------+--------------------------------------+-------------+---------------------+---------------------+
| id | plate_id | user_id | incident_id | created_at | updated_at |
+--------------------------------------+--------------------------------------+--------------------------------------+-------------+---------------------+---------------------+
| 70f0054a-d441-44a3-9de4-9f4079eab014 | e0dd8fd5-88c8-479c-902a-c4b80842ecac | 311bd620-4440-4cb6-9c8b-2fa6fcb28c97 | NULL | 2017-02-11 21:36:34 | 2017-02-11 21:36:34 |
| fc0df9bc-0676-489c-ab76-db816b01e7c1 | 4e055fc0-bd83-4452-a0d2-1bc41d18c35d | 7edd441b-f719-4b6d-94ad-7c7a97ac48c1 | NULL | 2017-02-13 17:47:32 | 2017-02-13 17:47:32 |
| 0228814d-eea6-465e-9a22-a9a86e412613 | 4e055fc0-bd83-4452-a0d2-1bc41d18c35d | 7edd441b-f719-4b6d-94ad-7c7a97ac48c1 | NULL | 2017-02-13 17:47:34 | 2017-02-13 17:47:34 |
| 45ff03ee-6f45-4e65-babb-f420c70e222c | 4e055fc0-bd83-4452-a0d2-1bc41d18c35d | 7edd441b-f719-4b6d-94ad-7c7a97ac48c1 | NULL | 2017-02-13 17:48:07 | 2017-02-13 17:48:07 |
| 6fbbc2fa-03e7-47d3-8028-a4d645853aec | 6bd341f2-ac9c-44b3-bb39-9c824d4002ed | 311bd620-4440-4cb6-9c8b-2fa6fcb28c97 | NULL | 2017-02-14 02:28:20 | 2017-02-14 02:28:20 |
| 9c955bf4-ab30-4465-b9e8-3e82f534dce8 | 6bd341f2-ac9c-44b3-bb39-9c824d4002ed | 311bd620-4440-4cb6-9c8b-2fa6fcb28c97 | NULL | 2017-02-14 15:14:04 | 2017-02-14 15:14:04 |
| 7758a8da-eec2-4694-b6d1-1a7698feba77 | 6bd341f2-ac9c-44b3-bb39-9c824d4002ed | 311bd620-4440-4cb6-9c8b-2fa6fcb28c97 | NULL | 2017-02-14 15:18:57 | 2017-02-14 15:18:57 |
+--------------------------------------+--------------------------------------+--------------------------------------+-------------+---------------------+---------------------+
7 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment