Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,176–16,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16176 | 7998 | 2 | 2019-05-31 12:10:35 |
| 16177 | 8009 | 2 | 2019-05-31 12:10:38 |
| 16178 | 8028 | 2 | 2019-05-31 12:11:23 |
| 16179 | 8012 | 2 | 2019-05-31 12:11:28 |
| 16180 | 8022 | 2 | 2019-05-31 12:11:28 |
| 16181 | 8013 | 2 | 2019-05-31 12:11:39 |
| 16182 | 8024 | 2 | 2019-05-31 12:12:15 |
| 16183 | 8015 | 2 | 2019-05-31 12:12:48 |
| 16184 | 8025 | 2 | 2019-05-31 12:13:09 |
| 16185 | 8011 | 2 | 2019-05-31 12:13:58 |
| 16186 | 8033 | 2 | 2019-05-31 12:14:01 |
| 16187 | 8020 | 2 | 2019-05-31 12:14:05 |
| 16188 | 8007 | 2 | 2019-05-31 12:14:11 |
| 16189 | 8032 | 2 | 2019-05-31 12:14:17 |
| 16190 | 8029 | 2 | 2019-05-31 12:14:27 |
| 16191 | 8021 | 2 | 2019-05-31 12:14:57 |
| 16192 | 8031 | 2 | 2019-05-31 12:18:36 |
| 16193 | 8016 | 2 | 2019-05-31 12:18:49 |
| 16194 | 8027 | 2 | 2019-05-31 12:18:49 |
| 16195 | 8001 | 2 | 2019-05-31 12:18:53 |
| 16196 | 8002 | 2 | 2019-05-31 12:19:54 |
| 16197 | 8034 | 2 | 2019-05-31 12:20:36 |
| 16198 | 7997 | 2 | 2019-05-31 12:20:58 |
| 16199 | 8004 | 2 | 2019-05-31 12:21:28 |
| 16200 | 8030 | 2 | 2019-05-31 12:21:30 |
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;