Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,526–5,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5526 | 2788 | 2 | 2016-09-21 17:36:28 |
| 5527 | 2834 | 1 | 2016-09-22 10:54:13 |
| 5528 | 2833 | 2 | 2016-09-22 10:59:38 |
| 5529 | 2835 | 2 | 2016-09-22 11:05:38 |
| 5530 | 2834 | 3 | 2016-09-22 11:30:06 |
| 5531 | 2834 | 1 | 2016-09-22 12:46:19 |
| 5532 | 2838 | 2 | 2016-09-22 15:14:29 |
| 5533 | 2836 | 2 | 2016-09-22 15:16:59 |
| 5534 | 2839 | 2 | 2016-09-22 15:17:12 |
| 5535 | 2837 | 2 | 2016-09-22 15:30:52 |
| 5536 | 2803 | 2 | 2016-09-22 15:58:10 |
| 5537 | 2803 | 1 | 2016-09-22 17:17:46 |
| 5538 | 2803 | 3 | 2016-09-22 17:43:34 |
| 5539 | 2826 | 1 | 2016-09-24 10:15:53 |
| 5540 | 2826 | 3 | 2016-09-24 11:25:59 |
| 5541 | 2789 | 1 | 2016-09-24 12:32:34 |
| 5542 | 2826 | 1 | 2016-09-24 12:34:05 |
| 5543 | 2789 | 3 | 2016-09-24 13:47:15 |
| 5544 | 2841 | 2 | 2016-09-24 14:01:11 |
| 5545 | 2843 | 2 | 2016-09-24 14:03:55 |
| 5546 | 2844 | 2 | 2016-09-24 14:09:39 |
| 5547 | 2842 | 1 | 2016-09-24 14:14:01 |
| 5548 | 2845 | 1 | 2016-09-24 14:15:17 |
| 5549 | 2841 | 1 | 2016-09-24 14:31:10 |
| 5550 | 2842 | 2 | 2016-09-24 15:06:26 |
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;