Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,301–5,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5301 | 2692 | 1 | 2016-08-24 10:58:20 |
| 5302 | 2693 | 2 | 2016-08-24 11:52:34 |
| 5303 | 2692 | 2 | 2016-08-24 12:07:20 |
| 5304 | 2682 | 2 | 2016-08-24 14:13:49 |
| 5305 | 2683 | 2 | 2016-08-24 14:17:56 |
| 5306 | 2684 | 2 | 2016-08-24 14:18:43 |
| 5307 | 2685 | 2 | 2016-08-25 10:29:19 |
| 5308 | 2688 | 1 | 2016-08-25 10:35:16 |
| 5309 | 2686 | 1 | 2016-08-25 10:37:21 |
| 5310 | 2689 | 1 | 2016-08-25 10:39:23 |
| 5311 | 2687 | 1 | 2016-08-25 10:39:58 |
| 5312 | 2685 | 3 | 2016-08-25 10:58:43 |
| 5313 | 2686 | 2 | 2016-08-25 11:17:13 |
| 5314 | 2687 | 2 | 2016-08-25 11:27:14 |
| 5315 | 2688 | 2 | 2016-08-25 11:40:36 |
| 5316 | 2685 | 1 | 2016-08-25 12:04:58 |
| 5317 | 2689 | 2 | 2016-08-25 12:07:53 |
| 5318 | 2585 | 2 | 2016-08-25 16:58:56 |
| 5319 | 2586 | 2 | 2016-08-25 17:00:18 |
| 5320 | 2584 | 2 | 2016-08-25 17:04:32 |
| 5321 | 2586 | 1 | 2016-08-25 17:34:16 |
| 5322 | 2585 | 1 | 2016-08-25 17:43:46 |
| 5323 | 2737 | 2 | 2016-08-26 09:18:25 |
| 5324 | 2738 | 2 | 2016-08-26 09:19:02 |
| 5325 | 2736 | 2 | 2016-08-26 09:26:35 |
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;