Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,826–4,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4826 | 2442 | 2 | 2016-07-02 12:45:44 |
| 4827 | 2441 | 2 | 2016-07-02 12:53:34 |
| 4828 | 2444 | 2 | 2016-07-02 13:08:19 |
| 4829 | 2446 | 2 | 2016-07-03 15:35:49 |
| 4830 | 2446 | 3 | 2016-07-03 16:41:38 |
| 4831 | 2452 | 1 | 2016-07-06 10:28:31 |
| 4832 | 2452 | 2 | 2016-07-06 12:02:58 |
| 4833 | 2452 | 1 | 2016-07-06 13:37:54 |
| 4834 | 2452 | 3 | 2016-07-06 14:46:42 |
| 4835 | 2451 | 2 | 2016-07-06 15:41:20 |
| 4836 | 2451 | 3 | 2016-07-06 16:46:03 |
| 4837 | 2396 | 3 | 2016-07-07 10:37:32 |
| 4838 | 2449 | 2 | 2016-07-07 11:39:22 |
| 4839 | 2449 | 3 | 2016-07-07 12:25:00 |
| 4840 | 2420 | 2 | 2016-07-08 09:10:09 |
| 4841 | 2421 | 2 | 2016-07-08 09:13:19 |
| 4842 | 2422 | 2 | 2016-07-08 09:13:30 |
| 4843 | 2421 | 1 | 2016-07-08 10:04:14 |
| 4844 | 2422 | 1 | 2016-07-08 10:11:43 |
| 4845 | 2420 | 1 | 2016-07-08 10:28:47 |
| 4846 | 2422 | 3 | 2016-07-08 10:49:13 |
| 4847 | 2420 | 3 | 2016-07-08 10:54:37 |
| 4848 | 2421 | 3 | 2016-07-08 11:22:11 |
| 4849 | 2459 | 2 | 2016-07-09 09:16:00 |
| 4850 | 2458 | 2 | 2016-07-09 09:22:51 |
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;