Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,026–17,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17026 | 8467 | 3 | 2019-07-25 13:27:51 |
| 17027 | 8464 | 3 | 2019-07-25 13:28:15 |
| 17028 | 8472 | 3 | 2019-07-25 13:32:37 |
| 17029 | 8477 | 3 | 2019-07-25 13:34:26 |
| 17030 | 8489 | 3 | 2019-07-25 13:35:37 |
| 17031 | 8485 | 3 | 2019-07-25 13:39:24 |
| 17032 | 8482 | 3 | 2019-07-25 13:46:08 |
| 17033 | 8487 | 3 | 2019-07-25 13:47:27 |
| 17034 | 8470 | 3 | 2019-07-25 13:48:37 |
| 17035 | 8463 | 3 | 2019-07-25 13:50:49 |
| 17036 | 8632 | 3 | 2019-07-25 13:57:00 |
| 17037 | 8480 | 3 | 2019-07-25 13:59:12 |
| 17038 | 8484 | 3 | 2019-07-25 14:02:18 |
| 17039 | 8475 | 3 | 2019-07-25 14:03:47 |
| 17040 | 8486 | 3 | 2019-07-25 14:04:25 |
| 17041 | 8473 | 3 | 2019-07-25 14:05:02 |
| 17042 | 8483 | 3 | 2019-07-25 14:05:40 |
| 17043 | 8469 | 3 | 2019-07-25 14:07:58 |
| 17044 | 8476 | 3 | 2019-07-25 14:08:30 |
| 17045 | 8493 | 3 | 2019-07-25 14:13:09 |
| 17046 | 8481 | 3 | 2019-07-25 14:13:54 |
| 17047 | 8468 | 3 | 2019-07-25 14:14:44 |
| 17048 | 8490 | 3 | 2019-07-25 14:18:15 |
| 17049 | 8471 | 3 | 2019-07-25 14:19:19 |
| 17050 | 8632 | 2 | 2019-07-25 14:34:10 |
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;