Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,426–7,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7426 | 3879 | 1 | 2017-05-02 12:38:30 |
| 7427 | 3428 | 2 | 2017-05-03 12:11:00 |
| 7428 | 3430 | 2 | 2017-05-03 12:11:19 |
| 7429 | 3454 | 2 | 2017-05-03 12:12:59 |
| 7430 | 3440 | 2 | 2017-05-03 12:13:05 |
| 7431 | 3469 | 2 | 2017-05-03 12:14:14 |
| 7432 | 3460 | 2 | 2017-05-03 12:14:17 |
| 7433 | 3458 | 2 | 2017-05-03 12:14:31 |
| 7434 | 3434 | 2 | 2017-05-03 12:16:16 |
| 7435 | 3466 | 2 | 2017-05-03 12:17:03 |
| 7436 | 3425 | 2 | 2017-05-03 12:17:24 |
| 7437 | 3431 | 2 | 2017-05-03 12:17:31 |
| 7438 | 3437 | 2 | 2017-05-03 12:18:08 |
| 7439 | 3433 | 2 | 2017-05-03 12:18:52 |
| 7440 | 3457 | 2 | 2017-05-03 12:20:04 |
| 7441 | 3443 | 2 | 2017-05-03 12:20:09 |
| 7442 | 3445 | 2 | 2017-05-03 12:20:13 |
| 7443 | 3435 | 2 | 2017-05-03 12:21:17 |
| 7444 | 3439 | 2 | 2017-05-03 12:21:24 |
| 7445 | 3426 | 2 | 2017-05-03 12:21:47 |
| 7446 | 3459 | 2 | 2017-05-03 12:21:50 |
| 7447 | 3455 | 2 | 2017-05-03 12:21:56 |
| 7448 | 3462 | 2 | 2017-05-03 12:23:03 |
| 7449 | 3429 | 2 | 2017-05-03 12:23:08 |
| 7450 | 3450 | 2 | 2017-05-03 12:23:44 |
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;