Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,326–15,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15326 | 7814 | 2 | 2019-03-25 13:10:09 |
| 15327 | 7816 | 3 | 2019-03-26 12:08:48 |
| 15328 | 7815 | 3 | 2019-03-26 12:12:49 |
| 15329 | 7817 | 3 | 2019-03-26 12:18:17 |
| 15330 | 7818 | 2 | 2019-03-26 12:19:29 |
| 15331 | 7815 | 2 | 2019-03-26 12:48:14 |
| 15332 | 7816 | 2 | 2019-03-26 12:53:24 |
| 15333 | 7817 | 2 | 2019-03-26 13:16:31 |
| 15334 | 7818 | 3 | 2019-03-26 13:41:53 |
| 15335 | 7817 | 3 | 2019-03-26 13:44:19 |
| 15336 | 7815 | 3 | 2019-03-26 13:52:14 |
| 15337 | 7816 | 3 | 2019-03-26 14:28:35 |
| 15338 | 7818 | 1 | 2019-03-26 14:59:10 |
| 15339 | 7902 | 2 | 2019-03-27 10:07:52 |
| 15340 | 7902 | 1 | 2019-03-27 11:04:34 |
| 15341 | 7904 | 1 | 2019-03-27 11:27:24 |
| 15342 | 7905 | 1 | 2019-03-27 11:32:23 |
| 15343 | 7903 | 2 | 2019-03-27 11:32:44 |
| 15344 | 7906 | 1 | 2019-03-27 11:36:35 |
| 15345 | 7905 | 2 | 2019-03-27 12:03:22 |
| 15346 | 7904 | 2 | 2019-03-27 12:25:39 |
| 15347 | 7906 | 2 | 2019-03-27 12:35:43 |
| 15348 | 7903 | 3 | 2019-03-27 12:57:04 |
| 15349 | 7905 | 3 | 2019-03-27 13:16:11 |
| 15350 | 7904 | 3 | 2019-03-27 13:52:07 |
Table definition
CREATE TABLE wing_scan (
scan_id INTEGER PRIMARY KEY,
ticket_id INTEGER NOT NULL REFERENCES ticket (ticket_id),
wing_id INTEGER NOT NULL REFERENCES wing (wing_id),
scanned_at TEXT NOT NULL
) STRICT;