Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,426–5,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5426 | 2772 | 1 | 2016-09-08 12:45:43 |
| 5427 | 2779 | 3 | 2016-09-08 12:49:47 |
| 5428 | 2771 | 2 | 2016-09-08 13:46:07 |
| 5429 | 2770 | 2 | 2016-09-08 13:47:42 |
| 5430 | 2772 | 2 | 2016-09-08 13:48:06 |
| 5431 | 2770 | 1 | 2016-09-08 14:48:40 |
| 5432 | 2771 | 1 | 2016-09-08 15:01:15 |
| 5433 | 2772 | 1 | 2016-09-08 15:12:29 |
| 5434 | 2798 | 2 | 2016-09-09 15:43:19 |
| 5435 | 2799 | 1 | 2016-09-09 15:51:04 |
| 5436 | 2800 | 1 | 2016-09-09 15:55:29 |
| 5437 | 2801 | 1 | 2016-09-09 15:55:43 |
| 5438 | 2801 | 2 | 2016-09-09 16:33:23 |
| 5439 | 2799 | 2 | 2016-09-09 16:50:16 |
| 5440 | 2760 | 2 | 2016-09-09 16:53:26 |
| 5441 | 2801 | 1 | 2016-09-09 17:49:46 |
| 5442 | 2755 | 2 | 2016-09-10 09:39:07 |
| 5443 | 2759 | 2 | 2016-09-10 09:48:20 |
| 5444 | 2756 | 2 | 2016-09-10 09:49:21 |
| 5445 | 2757 | 2 | 2016-09-10 09:49:45 |
| 5446 | 2758 | 2 | 2016-09-10 09:51:23 |
| 5447 | 2802 | 2 | 2016-09-10 13:46:13 |
| 5448 | 2761 | 2 | 2016-09-11 11:19:07 |
| 5449 | 2762 | 2 | 2016-09-11 11:19:55 |
| 5450 | 2763 | 2 | 2016-09-11 11:23:19 |
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;