Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,626–2,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2626 | 1448 | 2 | 2015-11-14 09:34:05 |
| 2627 | 1449 | 3 | 2015-11-14 10:38:21 |
| 2628 | 1450 | 3 | 2015-11-14 10:40:44 |
| 2629 | 1449 | 1 | 2015-11-14 11:05:35 |
| 2630 | 1450 | 1 | 2015-11-14 11:36:43 |
| 2631 | 1453 | 1 | 2015-11-14 13:30:53 |
| 2632 | 1453 | 2 | 2015-11-14 13:57:29 |
| 2633 | 1357 | 1 | 2015-11-15 12:55:37 |
| 2634 | 1358 | 1 | 2015-11-15 13:08:13 |
| 2635 | 1357 | 3 | 2015-11-15 13:48:07 |
| 2636 | 1358 | 3 | 2015-11-15 14:25:09 |
| 2637 | 1357 | 2 | 2015-11-15 14:44:11 |
| 2638 | 1358 | 1 | 2015-11-15 15:45:11 |
| 2639 | 1458 | 1 | 2015-11-17 16:05:25 |
| 2640 | 1457 | 1 | 2015-11-17 16:14:53 |
| 2641 | 1458 | 3 | 2015-11-17 17:07:38 |
| 2642 | 1457 | 3 | 2015-11-17 17:39:58 |
| 2643 | 1436 | 2 | 2015-11-18 09:57:16 |
| 2644 | 1433 | 2 | 2015-11-18 10:02:05 |
| 2645 | 1434 | 2 | 2015-11-18 10:02:32 |
| 2646 | 1435 | 2 | 2015-11-18 10:08:23 |
| 2647 | 1460 | 2 | 2015-11-18 10:09:27 |
| 2648 | 1459 | 2 | 2015-11-18 10:21:47 |
| 2649 | 1432 | 2 | 2015-11-19 13:25:02 |
| 2650 | 1452 | 2 | 2015-11-20 12:44:24 |
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;