Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,001–11,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11001 | 5096 | 3 | 2018-05-04 13:45:58 |
| 11002 | 5079 | 3 | 2018-05-04 13:46:28 |
| 11003 | 5109 | 3 | 2018-05-04 13:48:59 |
| 11004 | 5084 | 3 | 2018-05-04 13:49:14 |
| 11005 | 5101 | 3 | 2018-05-04 13:50:44 |
| 11006 | 5090 | 3 | 2018-05-04 13:51:49 |
| 11007 | 5119 | 3 | 2018-05-04 13:52:40 |
| 11008 | 5115 | 3 | 2018-05-04 13:53:17 |
| 11009 | 5111 | 3 | 2018-05-04 13:53:34 |
| 11010 | 5074 | 3 | 2018-05-04 13:54:42 |
| 11011 | 5073 | 3 | 2018-05-04 14:00:04 |
| 11012 | 5108 | 3 | 2018-05-04 14:04:00 |
| 11013 | 5094 | 3 | 2018-05-04 14:05:38 |
| 11014 | 5087 | 3 | 2018-05-04 14:06:36 |
| 11015 | 5103 | 3 | 2018-05-04 14:06:49 |
| 11016 | 5070 | 3 | 2018-05-04 14:10:34 |
| 11017 | 5088 | 3 | 2018-05-04 14:10:42 |
| 11018 | 5120 | 3 | 2018-05-04 14:13:56 |
| 11019 | 5093 | 3 | 2018-05-04 14:14:25 |
| 11020 | 5095 | 3 | 2018-05-04 14:16:28 |
| 11021 | 5078 | 3 | 2018-05-04 14:16:45 |
| 11022 | 5100 | 3 | 2018-05-04 14:17:00 |
| 11023 | 5116 | 3 | 2018-05-04 14:18:44 |
| 11024 | 5097 | 3 | 2018-05-04 14:20:13 |
| 11025 | 5687 | 1 | 2018-05-04 15:22:33 |
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;