Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,301–14,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14301 | 7343 | 1 | 2018-12-23 16:46:05 |
| 14302 | 6628 | 1 | 2018-12-24 10:36:34 |
| 14303 | 6641 | 1 | 2018-12-24 10:37:10 |
| 14304 | 6666 | 1 | 2018-12-24 10:38:04 |
| 14305 | 6637 | 1 | 2018-12-24 10:38:05 |
| 14306 | 6639 | 1 | 2018-12-24 10:38:40 |
| 14307 | 6650 | 1 | 2018-12-24 10:39:12 |
| 14308 | 6636 | 1 | 2018-12-24 10:39:29 |
| 14309 | 6647 | 1 | 2018-12-24 10:39:44 |
| 14310 | 6627 | 1 | 2018-12-24 10:40:31 |
| 14311 | 6651 | 1 | 2018-12-24 10:40:53 |
| 14312 | 6653 | 1 | 2018-12-24 10:41:09 |
| 14313 | 6649 | 1 | 2018-12-24 10:41:14 |
| 14314 | 6626 | 1 | 2018-12-24 10:41:19 |
| 14315 | 6667 | 1 | 2018-12-24 10:41:22 |
| 14316 | 6670 | 1 | 2018-12-24 10:41:26 |
| 14317 | 6668 | 1 | 2018-12-24 10:41:33 |
| 14318 | 6682 | 1 | 2018-12-24 10:41:54 |
| 14319 | 6629 | 1 | 2018-12-24 10:42:25 |
| 14320 | 6634 | 1 | 2018-12-24 10:42:25 |
| 14321 | 7266 | 2 | 2018-12-24 10:42:30 |
| 14322 | 6643 | 1 | 2018-12-24 10:43:12 |
| 14323 | 6631 | 1 | 2018-12-24 10:43:14 |
| 14324 | 6679 | 1 | 2018-12-24 10:43:17 |
| 14325 | 6661 | 1 | 2018-12-24 10:43:20 |
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;