Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,851–17,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17851 | 8614 | 2 | 2019-10-15 13:54:55 |
| 17852 | 8609 | 2 | 2019-10-15 13:55:28 |
| 17853 | 8622 | 2 | 2019-10-15 13:55:53 |
| 17854 | 8605 | 2 | 2019-10-15 13:56:03 |
| 17855 | 8624 | 2 | 2019-10-15 13:58:49 |
| 17856 | 8607 | 2 | 2019-10-15 13:59:04 |
| 17857 | 8610 | 2 | 2019-10-15 13:59:23 |
| 17858 | 8618 | 2 | 2019-10-15 13:59:25 |
| 17859 | 8617 | 2 | 2019-10-15 14:00:16 |
| 17860 | 8616 | 2 | 2019-10-15 14:01:19 |
| 17861 | 8602 | 2 | 2019-10-15 14:01:44 |
| 17862 | 8628 | 2 | 2019-10-15 14:02:55 |
| 17863 | 8604 | 2 | 2019-10-15 14:05:08 |
| 17864 | 8613 | 2 | 2019-10-15 14:06:09 |
| 17865 | 8621 | 2 | 2019-10-15 14:06:33 |
| 17866 | 8599 | 2 | 2019-10-15 14:06:52 |
| 17867 | 8620 | 2 | 2019-10-15 14:07:08 |
| 17868 | 8608 | 2 | 2019-10-15 14:07:13 |
| 17869 | 8626 | 2 | 2019-10-15 14:07:14 |
| 17870 | 8625 | 2 | 2019-10-15 14:07:39 |
| 17871 | 8606 | 2 | 2019-10-15 14:08:20 |
| 17872 | 8623 | 2 | 2019-10-15 14:09:23 |
| 17873 | 8629 | 2 | 2019-10-15 14:09:28 |
| 17874 | 8630 | 2 | 2019-10-15 14:10:20 |
| 17875 | 9172 | 3 | 2019-10-15 15:18:18 |
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;