Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,551–1,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1551 | 367 | 2 | 2015-08-02 12:14:21 |
| 1552 | 366 | 2 | 2015-08-02 12:14:50 |
| 1553 | 390 | 2 | 2015-08-02 12:15:06 |
| 1554 | 382 | 2 | 2015-08-02 12:15:33 |
| 1555 | 401 | 2 | 2015-08-02 12:15:40 |
| 1556 | 374 | 2 | 2015-08-02 12:15:45 |
| 1557 | 380 | 2 | 2015-08-02 12:16:09 |
| 1558 | 375 | 2 | 2015-08-02 12:16:36 |
| 1559 | 369 | 2 | 2015-08-02 12:16:50 |
| 1560 | 364 | 2 | 2015-08-02 12:16:54 |
| 1561 | 405 | 2 | 2015-08-02 12:16:55 |
| 1562 | 361 | 2 | 2015-08-02 12:17:03 |
| 1563 | 388 | 2 | 2015-08-02 12:17:07 |
| 1564 | 416 | 2 | 2015-08-02 12:17:15 |
| 1565 | 389 | 2 | 2015-08-02 12:17:19 |
| 1566 | 417 | 2 | 2015-08-02 12:17:44 |
| 1567 | 400 | 2 | 2015-08-02 12:17:50 |
| 1568 | 393 | 2 | 2015-08-02 12:18:01 |
| 1569 | 362 | 2 | 2015-08-02 12:18:37 |
| 1570 | 413 | 2 | 2015-08-02 12:18:57 |
| 1571 | 408 | 2 | 2015-08-02 12:19:01 |
| 1572 | 418 | 2 | 2015-08-02 12:19:09 |
| 1573 | 386 | 2 | 2015-08-02 12:19:56 |
| 1574 | 391 | 2 | 2015-08-02 12:20:10 |
| 1575 | 403 | 2 | 2015-08-02 12:20:14 |
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;