Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,626–10,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10626 | 5505 | 1 | 2018-04-02 10:38:33 |
| 10627 | 5504 | 1 | 2018-04-02 10:45:23 |
| 10628 | 5504 | 2 | 2018-04-02 11:31:13 |
| 10629 | 5505 | 2 | 2018-04-02 11:46:06 |
| 10630 | 5453 | 2 | 2018-04-02 12:02:48 |
| 10631 | 5452 | 2 | 2018-04-02 12:04:56 |
| 10632 | 5511 | 2 | 2018-04-02 14:43:28 |
| 10633 | 5511 | 3 | 2018-04-02 15:53:54 |
| 10634 | 5511 | 2 | 2018-04-02 16:39:02 |
| 10635 | 5350 | 1 | 2018-04-04 09:11:44 |
| 10636 | 5517 | 2 | 2018-04-04 09:16:01 |
| 10637 | 5351 | 2 | 2018-04-04 09:25:42 |
| 10638 | 5518 | 2 | 2018-04-04 09:27:37 |
| 10639 | 5350 | 2 | 2018-04-04 10:09:02 |
| 10640 | 5351 | 1 | 2018-04-04 10:59:52 |
| 10641 | 5351 | 3 | 2018-04-04 11:47:02 |
| 10642 | 5520 | 2 | 2018-04-05 11:36:03 |
| 10643 | 5514 | 3 | 2018-04-05 11:59:10 |
| 10644 | 5513 | 2 | 2018-04-05 12:02:03 |
| 10645 | 5513 | 1 | 2018-04-05 12:27:45 |
| 10646 | 5520 | 3 | 2018-04-05 12:42:20 |
| 10647 | 5520 | 1 | 2018-04-05 13:17:38 |
| 10648 | 5513 | 2 | 2018-04-05 13:21:22 |
| 10649 | 5464 | 2 | 2018-04-06 10:52:06 |
| 10650 | 5510 | 1 | 2018-04-06 10:57:53 |
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;