Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,401–14,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14401 | 7346 | 3 | 2018-12-27 16:26:44 |
| 14402 | 7344 | 3 | 2018-12-27 17:00:03 |
| 14403 | 7345 | 2 | 2018-12-27 17:24:26 |
| 14404 | 7360 | 2 | 2018-12-28 10:50:28 |
| 14405 | 7363 | 2 | 2018-12-28 14:53:29 |
| 14406 | 7362 | 1 | 2018-12-28 14:58:29 |
| 14407 | 7362 | 2 | 2018-12-28 15:34:42 |
| 14408 | 7363 | 3 | 2018-12-28 15:42:45 |
| 14409 | 7364 | 3 | 2018-12-29 11:15:16 |
| 14410 | 7365 | 3 | 2018-12-29 11:20:17 |
| 14411 | 7288 | 1 | 2018-12-30 14:09:06 |
| 14412 | 7287 | 1 | 2018-12-30 14:10:39 |
| 14413 | 7366 | 1 | 2019-01-03 15:06:40 |
| 14414 | 7367 | 2 | 2019-01-03 15:15:04 |
| 14415 | 7367 | 1 | 2019-01-03 16:20:44 |
| 14416 | 7361 | 2 | 2019-01-04 10:58:55 |
| 14417 | 7331 | 3 | 2019-01-04 13:08:46 |
| 14418 | 7331 | 2 | 2019-01-04 13:59:53 |
| 14419 | 7331 | 3 | 2019-01-04 14:34:37 |
| 14420 | 7368 | 2 | 2019-01-04 15:00:38 |
| 14421 | 7369 | 2 | 2019-01-05 09:26:07 |
| 14422 | 7370 | 2 | 2019-01-05 09:33:42 |
| 14423 | 7370 | 3 | 2019-01-05 10:47:01 |
| 14424 | 7370 | 1 | 2019-01-05 11:41:23 |
| 14425 | 7263 | 2 | 2019-01-05 16:37:36 |
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;