Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,651–18,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18651 | 9007 | 3 | 2019-12-15 11:35:57 |
| 18652 | 8993 | 3 | 2019-12-15 11:37:05 |
| 18653 | 8967 | 2 | 2019-12-15 11:46:52 |
| 18654 | 8974 | 2 | 2019-12-15 11:51:13 |
| 18655 | 8990 | 2 | 2019-12-15 11:52:58 |
| 18656 | 8971 | 2 | 2019-12-15 11:56:06 |
| 18657 | 8996 | 2 | 2019-12-15 11:56:25 |
| 18658 | 9005 | 2 | 2019-12-15 11:56:46 |
| 18659 | 8989 | 2 | 2019-12-15 11:57:46 |
| 18660 | 9002 | 2 | 2019-12-15 11:59:18 |
| 18661 | 8977 | 2 | 2019-12-15 12:01:36 |
| 18662 | 8992 | 2 | 2019-12-15 12:02:39 |
| 18663 | 8995 | 2 | 2019-12-15 12:03:00 |
| 18664 | 9518 | 2 | 2019-12-15 12:04:52 |
| 18665 | 9517 | 2 | 2019-12-15 12:05:30 |
| 18666 | 8963 | 2 | 2019-12-15 12:07:10 |
| 18667 | 8993 | 2 | 2019-12-15 12:07:50 |
| 18668 | 8980 | 2 | 2019-12-15 12:08:35 |
| 18669 | 8970 | 2 | 2019-12-15 12:09:04 |
| 18670 | 9008 | 2 | 2019-12-15 12:10:30 |
| 18671 | 8983 | 2 | 2019-12-15 12:10:45 |
| 18672 | 8994 | 2 | 2019-12-15 12:11:18 |
| 18673 | 9001 | 2 | 2019-12-15 12:11:48 |
| 18674 | 8988 | 2 | 2019-12-15 12:11:51 |
| 18675 | 8973 | 2 | 2019-12-15 12:13:21 |
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;