Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,551–14,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14551 | 7476 | 1 | 2019-02-05 17:40:03 |
| 14552 | 7475 | 1 | 2019-02-05 17:47:39 |
| 14553 | 7584 | 3 | 2019-02-06 10:50:11 |
| 14554 | 7582 | 1 | 2019-02-06 11:02:30 |
| 14555 | 7583 | 3 | 2019-02-06 11:02:36 |
| 14556 | 7585 | 3 | 2019-02-06 11:02:46 |
| 14557 | 7583 | 2 | 2019-02-06 11:38:26 |
| 14558 | 7584 | 2 | 2019-02-06 12:05:31 |
| 14559 | 7585 | 2 | 2019-02-06 12:27:16 |
| 14560 | 7582 | 2 | 2019-02-06 12:30:40 |
| 14561 | 7583 | 1 | 2019-02-06 13:02:52 |
| 14562 | 7582 | 3 | 2019-02-06 13:16:29 |
| 14563 | 7585 | 1 | 2019-02-06 13:28:24 |
| 14564 | 7583 | 2 | 2019-02-06 13:33:48 |
| 14565 | 7582 | 2 | 2019-02-06 13:55:49 |
| 14566 | 7585 | 2 | 2019-02-06 14:28:21 |
| 14567 | 7588 | 2 | 2019-02-07 09:44:16 |
| 14568 | 7588 | 1 | 2019-02-07 11:15:18 |
| 14569 | 7588 | 3 | 2019-02-07 11:55:51 |
| 14570 | 7575 | 3 | 2019-02-07 13:06:43 |
| 14571 | 7574 | 3 | 2019-02-07 13:08:28 |
| 14572 | 7574 | 2 | 2019-02-07 14:21:48 |
| 14573 | 7575 | 2 | 2019-02-07 14:39:14 |
| 14574 | 7594 | 3 | 2019-02-07 14:41:13 |
| 14575 | 7595 | 3 | 2019-02-07 14:42:59 |
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;