Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,601–10,625 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10601 | 5493 | 1 | 2018-03-31 10:14:40 |
| 10602 | 5491 | 1 | 2018-03-31 10:24:55 |
| 10603 | 5490 | 2 | 2018-03-31 12:22:28 |
| 10604 | 5488 | 2 | 2018-03-31 12:24:34 |
| 10605 | 5489 | 2 | 2018-03-31 12:24:43 |
| 10606 | 5486 | 2 | 2018-03-31 12:29:56 |
| 10607 | 5487 | 2 | 2018-03-31 12:32:11 |
| 10608 | 5486 | 1 | 2018-03-31 13:17:18 |
| 10609 | 5497 | 3 | 2018-03-31 13:28:29 |
| 10610 | 5495 | 3 | 2018-03-31 13:30:16 |
| 10611 | 5496 | 3 | 2018-03-31 13:36:14 |
| 10612 | 5494 | 3 | 2018-03-31 13:36:46 |
| 10613 | 5498 | 3 | 2018-03-31 13:37:57 |
| 10614 | 5497 | 1 | 2018-03-31 14:18:58 |
| 10615 | 5496 | 1 | 2018-03-31 14:23:30 |
| 10616 | 5495 | 1 | 2018-03-31 14:43:41 |
| 10617 | 5498 | 1 | 2018-03-31 14:50:27 |
| 10618 | 5494 | 1 | 2018-03-31 14:51:21 |
| 10619 | 5500 | 2 | 2018-04-01 10:00:21 |
| 10620 | 5461 | 2 | 2018-04-01 13:26:34 |
| 10621 | 5476 | 3 | 2018-04-01 15:04:21 |
| 10622 | 5474 | 2 | 2018-04-01 16:07:35 |
| 10623 | 5475 | 2 | 2018-04-01 16:09:40 |
| 10624 | 5504 | 3 | 2018-04-02 09:21:08 |
| 10625 | 5505 | 3 | 2018-04-02 09:34:17 |
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;