Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,226–17,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17226 | 8710 | 2 | 2019-08-09 12:50:01 |
| 17227 | 8736 | 2 | 2019-08-09 13:05:25 |
| 17228 | 8737 | 3 | 2019-08-09 13:30:51 |
| 17229 | 8655 | 1 | 2019-08-10 11:10:14 |
| 17230 | 8741 | 3 | 2019-08-10 11:39:36 |
| 17231 | 8742 | 2 | 2019-08-10 11:44:34 |
| 17232 | 8743 | 3 | 2019-08-10 11:47:58 |
| 17233 | 8744 | 3 | 2019-08-10 11:48:39 |
| 17234 | 8741 | 1 | 2019-08-10 12:13:50 |
| 17235 | 8742 | 1 | 2019-08-10 12:19:13 |
| 17236 | 8655 | 3 | 2019-08-10 12:19:40 |
| 17237 | 8658 | 2 | 2019-08-10 12:21:12 |
| 17238 | 8656 | 2 | 2019-08-10 12:21:50 |
| 17239 | 8658 | 1 | 2019-08-10 12:52:10 |
| 17240 | 8656 | 1 | 2019-08-10 13:05:46 |
| 17241 | 8743 | 1 | 2019-08-10 13:23:46 |
| 17242 | 8658 | 2 | 2019-08-10 13:39:50 |
| 17243 | 8656 | 2 | 2019-08-10 13:39:58 |
| 17244 | 8746 | 2 | 2019-08-10 14:32:03 |
| 17245 | 8694 | 1 | 2019-08-10 14:35:17 |
| 17246 | 8745 | 2 | 2019-08-10 14:37:52 |
| 17247 | 8693 | 2 | 2019-08-10 14:39:02 |
| 17248 | 8695 | 1 | 2019-08-10 14:39:15 |
| 17249 | 8694 | 2 | 2019-08-10 15:02:49 |
| 17250 | 8693 | 3 | 2019-08-10 15:05:01 |
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;