Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,651–2,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2651 | 1451 | 2 | 2015-11-20 12:45:22 |
| 2652 | 1503 | 2 | 2015-11-21 11:13:04 |
| 2653 | 1503 | 3 | 2015-11-21 12:34:03 |
| 2654 | 1502 | 1 | 2015-11-21 13:04:54 |
| 2655 | 1429 | 1 | 2015-11-21 13:14:15 |
| 2656 | 1431 | 1 | 2015-11-21 13:26:44 |
| 2657 | 1430 | 1 | 2015-11-21 13:29:40 |
| 2658 | 1502 | 2 | 2015-11-21 13:54:53 |
| 2659 | 1507 | 1 | 2015-11-21 15:04:54 |
| 2660 | 1508 | 3 | 2015-11-22 09:31:11 |
| 2661 | 1508 | 1 | 2015-11-22 09:58:20 |
| 2662 | 1506 | 2 | 2015-11-22 14:56:45 |
| 2663 | 1505 | 2 | 2015-11-22 15:08:33 |
| 2664 | 1504 | 2 | 2015-11-22 15:09:10 |
| 2665 | 1511 | 1 | 2015-11-24 11:55:04 |
| 2666 | 1510 | 1 | 2015-11-24 12:00:14 |
| 2667 | 1509 | 1 | 2015-11-24 12:06:08 |
| 2668 | 1513 | 2 | 2015-11-24 14:01:50 |
| 2669 | 1512 | 2 | 2015-11-24 14:10:20 |
| 2670 | 1513 | 3 | 2015-11-24 15:06:30 |
| 2671 | 1512 | 3 | 2015-11-24 15:19:43 |
| 2672 | 1513 | 2 | 2015-11-24 15:41:19 |
| 2673 | 1512 | 2 | 2015-11-24 16:18:31 |
| 2674 | 1514 | 2 | 2015-11-26 13:37:01 |
| 2675 | 1515 | 1 | 2015-11-26 14:25:08 |
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;