Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,526–9,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9526 | 4717 | 1 | 2017-11-22 13:01:02 |
| 9527 | 4713 | 1 | 2017-11-22 13:03:05 |
| 9528 | 4736 | 1 | 2017-11-22 13:05:44 |
| 9529 | 4709 | 1 | 2017-11-22 13:06:00 |
| 9530 | 4691 | 1 | 2017-11-22 13:07:07 |
| 9531 | 4688 | 1 | 2017-11-22 13:10:15 |
| 9532 | 4720 | 1 | 2017-11-22 13:11:10 |
| 9533 | 4733 | 1 | 2017-11-22 13:14:18 |
| 9534 | 4707 | 1 | 2017-11-22 13:16:17 |
| 9535 | 4693 | 1 | 2017-11-22 13:17:57 |
| 9536 | 4731 | 1 | 2017-11-22 13:19:22 |
| 9537 | 4724 | 1 | 2017-11-22 13:19:41 |
| 9538 | 4684 | 1 | 2017-11-22 13:24:26 |
| 9539 | 4722 | 1 | 2017-11-22 13:24:41 |
| 9540 | 4711 | 1 | 2017-11-22 13:27:55 |
| 9541 | 4697 | 1 | 2017-11-22 13:28:41 |
| 9542 | 4725 | 1 | 2017-11-22 13:28:54 |
| 9543 | 4712 | 1 | 2017-11-22 13:29:23 |
| 9544 | 4685 | 1 | 2017-11-22 13:31:30 |
| 9545 | 4726 | 1 | 2017-11-22 13:32:33 |
| 9546 | 4715 | 1 | 2017-11-22 13:32:43 |
| 9547 | 4698 | 1 | 2017-11-22 13:33:25 |
| 9548 | 4734 | 1 | 2017-11-22 13:35:41 |
| 9549 | 4741 | 1 | 2017-11-22 13:35:43 |
| 9550 | 4689 | 1 | 2017-11-22 13:39:41 |
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;