Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,851–4,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4851 | 2448 | 1 | 2016-07-10 13:41:16 |
| 4852 | 2448 | 3 | 2016-07-10 14:17:46 |
| 4853 | 2463 | 2 | 2016-07-11 11:03:57 |
| 4854 | 2464 | 2 | 2016-07-11 11:05:29 |
| 4855 | 2465 | 2 | 2016-07-11 11:28:09 |
| 4856 | 2467 | 2 | 2016-07-11 11:28:12 |
| 4857 | 2470 | 2 | 2016-07-11 11:29:05 |
| 4858 | 2468 | 2 | 2016-07-11 11:30:20 |
| 4859 | 2469 | 2 | 2016-07-11 11:30:46 |
| 4860 | 2466 | 2 | 2016-07-11 11:35:51 |
| 4861 | 2466 | 3 | 2016-07-11 12:12:39 |
| 4862 | 2467 | 3 | 2016-07-11 12:20:34 |
| 4863 | 2463 | 3 | 2016-07-11 12:22:25 |
| 4864 | 2464 | 3 | 2016-07-11 12:33:36 |
| 4865 | 2465 | 3 | 2016-07-11 12:34:10 |
| 4866 | 2469 | 3 | 2016-07-11 12:39:38 |
| 4867 | 2470 | 3 | 2016-07-11 12:49:50 |
| 4868 | 2468 | 3 | 2016-07-11 12:50:12 |
| 4869 | 2465 | 1 | 2016-07-11 13:03:49 |
| 4870 | 2466 | 1 | 2016-07-11 13:28:03 |
| 4871 | 2467 | 1 | 2016-07-11 13:42:05 |
| 4872 | 2465 | 2 | 2016-07-11 13:44:44 |
| 4873 | 2467 | 2 | 2016-07-11 14:20:56 |
| 4874 | 2472 | 3 | 2016-07-11 14:36:49 |
| 4875 | 2471 | 3 | 2016-07-11 14:41:44 |
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;