Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,551–12,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12551 | 6563 | 1 | 2018-08-25 13:42:39 |
| 12552 | 6562 | 3 | 2018-08-25 14:04:54 |
| 12553 | 6563 | 3 | 2018-08-25 15:13:00 |
| 12554 | 6561 | 2 | 2018-08-25 16:09:44 |
| 12555 | 6561 | 3 | 2018-08-25 17:41:06 |
| 12556 | 6502 | 1 | 2018-08-26 14:18:10 |
| 12557 | 6501 | 1 | 2018-08-26 14:27:29 |
| 12558 | 6439 | 3 | 2018-08-26 14:28:21 |
| 12559 | 6437 | 3 | 2018-08-26 14:28:35 |
| 12560 | 6440 | 3 | 2018-08-26 14:31:15 |
| 12561 | 6438 | 3 | 2018-08-26 14:35:20 |
| 12562 | 6439 | 2 | 2018-08-26 14:57:13 |
| 12563 | 6440 | 2 | 2018-08-26 15:30:08 |
| 12564 | 6437 | 2 | 2018-08-26 15:58:14 |
| 12565 | 6438 | 2 | 2018-08-26 16:00:37 |
| 12566 | 5903 | 3 | 2018-08-27 10:17:25 |
| 12567 | 5909 | 3 | 2018-08-27 10:17:46 |
| 12568 | 5916 | 3 | 2018-08-27 10:18:03 |
| 12569 | 5926 | 3 | 2018-08-27 10:18:10 |
| 12570 | 5905 | 3 | 2018-08-27 10:18:23 |
| 12571 | 5904 | 3 | 2018-08-27 10:19:15 |
| 12572 | 5901 | 3 | 2018-08-27 10:19:56 |
| 12573 | 5902 | 3 | 2018-08-27 10:19:57 |
| 12574 | 5898 | 3 | 2018-08-27 10:20:44 |
| 12575 | 5900 | 3 | 2018-08-27 10:21:39 |
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;