Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,526–3,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3526 | 1841 | 3 | 2016-02-29 14:55:49 |
| 3527 | 1842 | 3 | 2016-02-29 15:06:30 |
| 3528 | 1843 | 3 | 2016-02-29 15:11:10 |
| 3529 | 1841 | 1 | 2016-02-29 15:25:16 |
| 3530 | 1840 | 1 | 2016-02-29 16:07:50 |
| 3531 | 1842 | 1 | 2016-02-29 16:23:27 |
| 3532 | 1843 | 1 | 2016-02-29 16:39:45 |
| 3533 | 1846 | 2 | 2016-03-02 09:57:13 |
| 3534 | 1847 | 2 | 2016-03-02 10:03:24 |
| 3535 | 1848 | 1 | 2016-03-02 10:07:47 |
| 3536 | 1849 | 2 | 2016-03-02 10:07:57 |
| 3537 | 1848 | 3 | 2016-03-02 10:41:21 |
| 3538 | 1846 | 3 | 2016-03-02 11:01:57 |
| 3539 | 1849 | 3 | 2016-03-02 11:18:18 |
| 3540 | 1847 | 3 | 2016-03-02 11:21:33 |
| 3541 | 1850 | 2 | 2016-03-02 17:01:26 |
| 3542 | 1851 | 2 | 2016-03-02 17:05:27 |
| 3543 | 1463 | 1 | 2016-03-03 10:47:06 |
| 3544 | 1475 | 1 | 2016-03-03 10:48:31 |
| 3545 | 1469 | 1 | 2016-03-03 10:49:24 |
| 3546 | 1491 | 1 | 2016-03-03 10:50:15 |
| 3547 | 1467 | 1 | 2016-03-03 10:50:51 |
| 3548 | 1483 | 1 | 2016-03-03 10:51:29 |
| 3549 | 1489 | 1 | 2016-03-03 10:51:36 |
| 3550 | 1470 | 1 | 2016-03-03 10:52:43 |
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;