Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,451–5,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5451 | 2765 | 2 | 2016-09-11 11:27:08 |
| 5452 | 2764 | 2 | 2016-09-11 11:29:36 |
| 5453 | 2763 | 1 | 2016-09-11 11:50:44 |
| 5454 | 2764 | 1 | 2016-09-11 12:14:15 |
| 5455 | 2761 | 1 | 2016-09-11 12:29:26 |
| 5456 | 2762 | 1 | 2016-09-11 12:30:04 |
| 5457 | 2765 | 1 | 2016-09-11 12:55:26 |
| 5458 | 2763 | 2 | 2016-09-11 13:01:08 |
| 5459 | 2764 | 2 | 2016-09-11 13:05:31 |
| 5460 | 2761 | 2 | 2016-09-11 13:07:25 |
| 5461 | 2762 | 2 | 2016-09-11 13:34:24 |
| 5462 | 2764 | 3 | 2016-09-11 13:46:43 |
| 5463 | 2761 | 3 | 2016-09-11 13:55:27 |
| 5464 | 2763 | 3 | 2016-09-11 14:09:45 |
| 5465 | 2765 | 2 | 2016-09-11 14:16:04 |
| 5466 | 2762 | 3 | 2016-09-11 14:42:08 |
| 5467 | 2765 | 3 | 2016-09-11 15:01:36 |
| 5468 | 2804 | 2 | 2016-09-12 11:56:06 |
| 5469 | 2805 | 2 | 2016-09-12 11:57:45 |
| 5470 | 2804 | 3 | 2016-09-12 12:30:29 |
| 5471 | 2805 | 3 | 2016-09-12 13:30:52 |
| 5472 | 2811 | 2 | 2016-09-13 10:06:19 |
| 5473 | 2811 | 3 | 2016-09-13 11:38:18 |
| 5474 | 2812 | 2 | 2016-09-13 15:03:57 |
| 5475 | 2812 | 1 | 2016-09-13 16:26:11 |
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;