Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,526–1,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1526 | 892 | 3 | 2015-07-30 12:31:06 |
| 1527 | 891 | 3 | 2015-07-30 12:31:09 |
| 1528 | 895 | 1 | 2015-08-01 09:50:20 |
| 1529 | 896 | 1 | 2015-08-01 09:52:14 |
| 1530 | 895 | 3 | 2015-08-01 10:45:24 |
| 1531 | 897 | 1 | 2015-08-01 11:48:52 |
| 1532 | 897 | 2 | 2015-08-01 12:14:54 |
| 1533 | 368 | 2 | 2015-08-02 12:07:00 |
| 1534 | 381 | 2 | 2015-08-02 12:08:15 |
| 1535 | 383 | 2 | 2015-08-02 12:08:35 |
| 1536 | 385 | 2 | 2015-08-02 12:08:47 |
| 1537 | 387 | 2 | 2015-08-02 12:09:02 |
| 1538 | 398 | 2 | 2015-08-02 12:09:13 |
| 1539 | 396 | 2 | 2015-08-02 12:09:48 |
| 1540 | 379 | 2 | 2015-08-02 12:09:53 |
| 1541 | 365 | 2 | 2015-08-02 12:11:07 |
| 1542 | 410 | 2 | 2015-08-02 12:11:26 |
| 1543 | 407 | 2 | 2015-08-02 12:11:44 |
| 1544 | 373 | 2 | 2015-08-02 12:12:35 |
| 1545 | 384 | 2 | 2015-08-02 12:12:41 |
| 1546 | 363 | 2 | 2015-08-02 12:12:43 |
| 1547 | 411 | 2 | 2015-08-02 12:13:03 |
| 1548 | 394 | 2 | 2015-08-02 12:13:24 |
| 1549 | 412 | 2 | 2015-08-02 12:13:41 |
| 1550 | 371 | 2 | 2015-08-02 12:14:15 |
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;