Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,426–3,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3426 | 1790 | 2 | 2016-02-13 11:22:32 |
| 3427 | 1795 | 2 | 2016-02-14 16:20:30 |
| 3428 | 1797 | 2 | 2016-02-14 16:26:31 |
| 3429 | 1794 | 2 | 2016-02-14 16:30:10 |
| 3430 | 1796 | 2 | 2016-02-14 16:34:17 |
| 3431 | 1797 | 1 | 2016-02-14 17:01:30 |
| 3432 | 1796 | 3 | 2016-02-14 17:17:57 |
| 3433 | 1796 | 1 | 2016-02-14 17:44:07 |
| 3434 | 1794 | 3 | 2016-02-14 17:46:05 |
| 3435 | 1799 | 2 | 2016-02-16 09:45:20 |
| 3436 | 1800 | 2 | 2016-02-16 09:52:12 |
| 3437 | 1801 | 2 | 2016-02-16 09:57:16 |
| 3438 | 1800 | 3 | 2016-02-16 10:25:06 |
| 3439 | 1801 | 3 | 2016-02-16 10:29:51 |
| 3440 | 1801 | 1 | 2016-02-16 11:06:22 |
| 3441 | 1799 | 3 | 2016-02-16 11:08:20 |
| 3442 | 1803 | 3 | 2016-02-16 16:52:19 |
| 3443 | 1806 | 1 | 2016-02-16 16:52:30 |
| 3444 | 1805 | 1 | 2016-02-16 16:54:08 |
| 3445 | 1802 | 3 | 2016-02-16 16:54:16 |
| 3446 | 1804 | 3 | 2016-02-16 16:58:42 |
| 3447 | 1805 | 3 | 2016-02-16 17:28:44 |
| 3448 | 1792 | 2 | 2016-02-17 11:54:30 |
| 3449 | 1793 | 2 | 2016-02-17 11:57:35 |
| 3450 | 1791 | 2 | 2016-02-17 11:59:25 |
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;