Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,476–19,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19476 | 9823 | 1 | 2020-02-19 14:03:33 |
| 19477 | 9821 | 3 | 2020-02-19 14:11:09 |
| 19478 | 9819 | 3 | 2020-02-19 14:24:56 |
| 19479 | 9822 | 1 | 2020-02-19 14:26:02 |
| 19480 | 9822 | 3 | 2020-02-19 14:55:33 |
| 19481 | 9823 | 3 | 2020-02-19 15:36:14 |
| 19482 | 9828 | 2 | 2020-02-19 16:40:24 |
| 19483 | 9829 | 1 | 2020-02-19 16:49:51 |
| 19484 | 9829 | 3 | 2020-02-19 17:20:55 |
| 19485 | 9830 | 1 | 2020-02-20 11:07:02 |
| 19486 | 9799 | 2 | 2020-02-20 15:04:55 |
| 19487 | 9801 | 2 | 2020-02-20 15:05:59 |
| 19488 | 9797 | 2 | 2020-02-20 15:07:50 |
| 19489 | 9798 | 2 | 2020-02-20 15:09:06 |
| 19490 | 9800 | 2 | 2020-02-20 15:12:30 |
| 19491 | 9801 | 3 | 2020-02-20 15:35:44 |
| 19492 | 9799 | 3 | 2020-02-20 15:49:47 |
| 19493 | 9797 | 3 | 2020-02-20 16:12:35 |
| 19494 | 9801 | 1 | 2020-02-20 16:12:45 |
| 19495 | 9800 | 3 | 2020-02-20 16:24:49 |
| 19496 | 9798 | 3 | 2020-02-20 16:24:59 |
| 19497 | 9798 | 1 | 2020-02-20 17:13:14 |
| 19498 | 9797 | 1 | 2020-02-20 17:29:05 |
| 19499 | 9801 | 2 | 2020-02-20 17:35:07 |
| 19500 | 9800 | 1 | 2020-02-20 17:35:23 |
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;