Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,001–18,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18001 | 9296 | 1 | 2019-10-26 10:59:26 |
| 18002 | 9297 | 1 | 2019-10-26 11:35:53 |
| 18003 | 9182 | 1 | 2019-10-26 11:40:49 |
| 18004 | 9183 | 3 | 2019-10-26 11:47:50 |
| 18005 | 9182 | 3 | 2019-10-26 12:43:08 |
| 18006 | 9182 | 1 | 2019-10-26 13:21:34 |
| 18007 | 9238 | 2 | 2019-10-26 15:03:59 |
| 18008 | 9237 | 2 | 2019-10-26 15:13:18 |
| 18009 | 9236 | 2 | 2019-10-26 15:17:09 |
| 18010 | 9236 | 3 | 2019-10-26 15:47:14 |
| 18011 | 9237 | 1 | 2019-10-26 15:56:51 |
| 18012 | 9238 | 1 | 2019-10-26 16:01:52 |
| 18013 | 9237 | 3 | 2019-10-26 16:55:00 |
| 18014 | 9238 | 3 | 2019-10-26 17:14:48 |
| 18015 | 9310 | 2 | 2019-10-27 15:14:42 |
| 18016 | 9309 | 2 | 2019-10-27 15:19:27 |
| 18017 | 9310 | 3 | 2019-10-27 16:16:49 |
| 18018 | 9310 | 2 | 2019-10-27 17:05:58 |
| 18019 | 9310 | 3 | 2019-10-27 17:45:26 |
| 18020 | 9173 | 2 | 2019-10-28 11:44:56 |
| 18021 | 9322 | 2 | 2019-10-28 11:54:27 |
| 18022 | 9173 | 3 | 2019-10-28 12:12:46 |
| 18023 | 9173 | 1 | 2019-10-28 13:28:21 |
| 18024 | 9319 | 2 | 2019-10-28 13:56:58 |
| 18025 | 9318 | 2 | 2019-10-28 14:02:31 |
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;