Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,526–12,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12526 | 6516 | 3 | 2018-08-23 10:30:30 |
| 12527 | 6516 | 1 | 2018-08-23 11:03:12 |
| 12528 | 6516 | 2 | 2018-08-23 12:02:51 |
| 12529 | 6554 | 2 | 2018-08-23 12:42:56 |
| 12530 | 6555 | 2 | 2018-08-23 12:43:31 |
| 12531 | 6555 | 3 | 2018-08-23 13:11:05 |
| 12532 | 6554 | 3 | 2018-08-23 14:13:03 |
| 12533 | 6555 | 2 | 2018-08-23 14:45:32 |
| 12534 | 6554 | 2 | 2018-08-23 15:16:19 |
| 12535 | 6555 | 3 | 2018-08-23 16:06:05 |
| 12536 | 6554 | 3 | 2018-08-23 16:45:09 |
| 12537 | 6494 | 1 | 2018-08-24 09:39:23 |
| 12538 | 6494 | 2 | 2018-08-24 10:19:10 |
| 12539 | 6416 | 3 | 2018-08-25 10:27:40 |
| 12540 | 6560 | 1 | 2018-08-25 10:32:20 |
| 12541 | 6417 | 3 | 2018-08-25 10:33:09 |
| 12542 | 6513 | 1 | 2018-08-25 10:45:07 |
| 12543 | 6416 | 2 | 2018-08-25 10:55:15 |
| 12544 | 6560 | 2 | 2018-08-25 11:00:34 |
| 12545 | 6416 | 3 | 2018-08-25 11:36:37 |
| 12546 | 6513 | 3 | 2018-08-25 12:01:13 |
| 12547 | 6416 | 1 | 2018-08-25 12:01:44 |
| 12548 | 6560 | 3 | 2018-08-25 12:16:00 |
| 12549 | 6513 | 2 | 2018-08-25 12:39:22 |
| 12550 | 6562 | 1 | 2018-08-25 13:35:21 |
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;