Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,601–17,625 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17601 | 8889 | 3 | 2019-09-10 10:26:04 |
| 17602 | 8897 | 2 | 2019-09-10 10:56:13 |
| 17603 | 8888 | 2 | 2019-09-10 10:59:26 |
| 17604 | 8895 | 3 | 2019-09-10 11:03:38 |
| 17605 | 8898 | 2 | 2019-09-10 11:07:39 |
| 17606 | 8899 | 2 | 2019-09-10 11:07:43 |
| 17607 | 8896 | 2 | 2019-09-10 11:09:36 |
| 17608 | 8889 | 2 | 2019-09-10 11:50:04 |
| 17609 | 8898 | 3 | 2019-09-10 12:06:44 |
| 17610 | 8873 | 2 | 2019-09-10 12:09:33 |
| 17611 | 8896 | 3 | 2019-09-10 12:13:57 |
| 17612 | 8897 | 3 | 2019-09-10 12:15:09 |
| 17613 | 8874 | 2 | 2019-09-10 12:16:49 |
| 17614 | 8895 | 2 | 2019-09-10 12:28:15 |
| 17615 | 8898 | 2 | 2019-09-10 12:40:11 |
| 17616 | 8899 | 3 | 2019-09-10 12:41:10 |
| 17617 | 8873 | 1 | 2019-09-10 13:01:00 |
| 17618 | 8897 | 2 | 2019-09-10 13:03:00 |
| 17619 | 8896 | 2 | 2019-09-10 13:28:23 |
| 17620 | 8874 | 3 | 2019-09-10 13:28:57 |
| 17621 | 8899 | 2 | 2019-09-10 13:53:53 |
| 17622 | 8898 | 1 | 2019-09-10 13:56:07 |
| 17623 | 8958 | 1 | 2019-09-11 10:51:47 |
| 17624 | 8956 | 2 | 2019-09-11 10:51:59 |
| 17625 | 8957 | 1 | 2019-09-11 10:53:42 |
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;