Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,451–19,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19451 | 9802 | 3 | 2020-02-17 12:17:02 |
| 19452 | 9690 | 3 | 2020-02-17 12:31:06 |
| 19453 | 9815 | 3 | 2020-02-17 12:35:31 |
| 19454 | 9811 | 1 | 2020-02-17 12:51:48 |
| 19455 | 9692 | 1 | 2020-02-17 13:06:45 |
| 19456 | 9691 | 1 | 2020-02-17 13:10:51 |
| 19457 | 9816 | 2 | 2020-02-17 13:49:28 |
| 19458 | 9811 | 2 | 2020-02-17 13:49:58 |
| 19459 | 9818 | 1 | 2020-02-17 13:52:18 |
| 19460 | 9817 | 3 | 2020-02-17 13:54:58 |
| 19461 | 9816 | 1 | 2020-02-17 14:16:58 |
| 19462 | 9811 | 1 | 2020-02-17 14:41:34 |
| 19463 | 9818 | 3 | 2020-02-17 15:10:32 |
| 19464 | 9805 | 1 | 2020-02-18 10:38:38 |
| 19465 | 9806 | 1 | 2020-02-18 10:50:04 |
| 19466 | 9812 | 1 | 2020-02-18 14:19:58 |
| 19467 | 9812 | 2 | 2020-02-18 15:43:48 |
| 19468 | 9823 | 2 | 2020-02-19 12:55:58 |
| 19469 | 9821 | 2 | 2020-02-19 13:02:13 |
| 19470 | 9822 | 2 | 2020-02-19 13:05:29 |
| 19471 | 9820 | 2 | 2020-02-19 13:05:30 |
| 19472 | 9819 | 2 | 2020-02-19 13:06:22 |
| 19473 | 9819 | 1 | 2020-02-19 13:35:51 |
| 19474 | 9821 | 1 | 2020-02-19 13:36:51 |
| 19475 | 9820 | 1 | 2020-02-19 13:53:10 |
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;