Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,526–14,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14526 | 7577 | 3 | 2019-02-01 12:01:19 |
| 14527 | 7576 | 2 | 2019-02-01 12:51:16 |
| 14528 | 7577 | 2 | 2019-02-01 13:28:49 |
| 14529 | 7580 | 2 | 2019-02-02 15:58:32 |
| 14530 | 7579 | 2 | 2019-02-02 16:10:56 |
| 14531 | 7580 | 1 | 2019-02-02 16:32:04 |
| 14532 | 7579 | 1 | 2019-02-02 17:13:19 |
| 14533 | 7527 | 2 | 2019-02-03 12:05:09 |
| 14534 | 7530 | 2 | 2019-02-03 12:14:50 |
| 14535 | 7529 | 3 | 2019-02-03 12:18:04 |
| 14536 | 7528 | 2 | 2019-02-03 12:19:14 |
| 14537 | 7530 | 1 | 2019-02-03 13:14:33 |
| 14538 | 7527 | 1 | 2019-02-03 13:20:07 |
| 14539 | 7528 | 1 | 2019-02-03 13:35:59 |
| 14540 | 7527 | 2 | 2019-02-03 14:27:45 |
| 14541 | 7530 | 2 | 2019-02-03 14:39:06 |
| 14542 | 7528 | 2 | 2019-02-03 15:06:30 |
| 14543 | 7587 | 2 | 2019-02-04 11:10:33 |
| 14544 | 7587 | 3 | 2019-02-04 12:15:10 |
| 14545 | 7587 | 1 | 2019-02-04 13:10:32 |
| 14546 | 7589 | 2 | 2019-02-05 12:10:51 |
| 14547 | 7590 | 2 | 2019-02-05 12:12:21 |
| 14548 | 7591 | 2 | 2019-02-05 12:12:39 |
| 14549 | 7476 | 2 | 2019-02-05 16:38:50 |
| 14550 | 7475 | 2 | 2019-02-05 16:40:00 |
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;