Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,376–16,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16376 | 8138 | 1 | 2019-06-06 14:20:32 |
| 16377 | 8136 | 3 | 2019-06-06 15:00:28 |
| 16378 | 8138 | 3 | 2019-06-06 15:23:27 |
| 16379 | 8307 | 2 | 2019-06-06 15:40:08 |
| 16380 | 8306 | 2 | 2019-06-06 15:45:33 |
| 16381 | 8307 | 1 | 2019-06-06 16:18:04 |
| 16382 | 8306 | 3 | 2019-06-06 17:06:56 |
| 16383 | 8317 | 1 | 2019-06-08 10:41:47 |
| 16384 | 8318 | 1 | 2019-06-08 10:49:07 |
| 16385 | 8329 | 3 | 2019-06-08 10:56:05 |
| 16386 | 8331 | 2 | 2019-06-08 11:05:01 |
| 16387 | 8330 | 2 | 2019-06-08 11:20:28 |
| 16388 | 8331 | 3 | 2019-06-08 11:41:52 |
| 16389 | 8330 | 3 | 2019-06-08 12:05:31 |
| 16390 | 8332 | 2 | 2019-06-08 14:47:36 |
| 16391 | 8332 | 1 | 2019-06-08 15:54:33 |
| 16392 | 8309 | 2 | 2019-06-08 15:58:43 |
| 16393 | 8308 | 2 | 2019-06-08 16:03:55 |
| 16394 | 8191 | 1 | 2019-06-08 16:21:09 |
| 16395 | 8192 | 1 | 2019-06-08 16:22:24 |
| 16396 | 8309 | 3 | 2019-06-08 17:11:07 |
| 16397 | 8192 | 2 | 2019-06-08 17:28:11 |
| 16398 | 8308 | 3 | 2019-06-08 17:36:34 |
| 16399 | 8191 | 2 | 2019-06-08 17:44:32 |
| 16400 | 8109 | 2 | 2019-06-09 09:30:10 |
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;