Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,701–16,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16701 | 8458 | 1 | 2019-07-08 12:02:19 |
| 16702 | 8456 | 1 | 2019-07-08 12:12:23 |
| 16703 | 8509 | 2 | 2019-07-08 12:19:33 |
| 16704 | 8458 | 2 | 2019-07-08 12:42:14 |
| 16705 | 8457 | 2 | 2019-07-08 12:50:31 |
| 16706 | 8456 | 2 | 2019-07-08 13:10:24 |
| 16707 | 8496 | 1 | 2019-07-08 15:19:05 |
| 16708 | 8496 | 2 | 2019-07-08 15:47:13 |
| 16709 | 8512 | 3 | 2019-07-09 11:59:14 |
| 16710 | 8512 | 2 | 2019-07-09 13:00:01 |
| 16711 | 8512 | 3 | 2019-07-09 14:08:36 |
| 16712 | 8512 | 1 | 2019-07-09 15:30:30 |
| 16713 | 8519 | 2 | 2019-07-10 10:56:19 |
| 16714 | 8518 | 2 | 2019-07-10 10:57:17 |
| 16715 | 8398 | 1 | 2019-07-10 12:15:27 |
| 16716 | 8502 | 2 | 2019-07-10 13:55:13 |
| 16717 | 8502 | 3 | 2019-07-10 15:20:53 |
| 16718 | 8502 | 1 | 2019-07-10 16:01:39 |
| 16719 | 8527 | 1 | 2019-07-11 10:38:03 |
| 16720 | 8528 | 2 | 2019-07-11 10:56:49 |
| 16721 | 8528 | 3 | 2019-07-11 11:52:00 |
| 16722 | 8522 | 2 | 2019-07-12 09:53:31 |
| 16723 | 8521 | 2 | 2019-07-12 09:54:12 |
| 16724 | 8520 | 2 | 2019-07-12 09:54:19 |
| 16725 | 8545 | 1 | 2019-07-12 13:32:34 |
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;