Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,551–3,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3551 | 1490 | 1 | 2016-03-03 10:53:18 |
| 3552 | 1479 | 1 | 2016-03-03 10:53:23 |
| 3553 | 1480 | 1 | 2016-03-03 10:53:42 |
| 3554 | 1493 | 1 | 2016-03-03 10:54:23 |
| 3555 | 1496 | 1 | 2016-03-03 10:54:41 |
| 3556 | 1482 | 1 | 2016-03-03 10:54:43 |
| 3557 | 1466 | 1 | 2016-03-03 10:54:45 |
| 3558 | 1476 | 1 | 2016-03-03 10:54:55 |
| 3559 | 1473 | 1 | 2016-03-03 10:55:06 |
| 3560 | 1501 | 1 | 2016-03-03 10:55:37 |
| 3561 | 1462 | 1 | 2016-03-03 10:56:16 |
| 3562 | 1465 | 1 | 2016-03-03 10:56:35 |
| 3563 | 1464 | 1 | 2016-03-03 10:57:21 |
| 3564 | 1472 | 1 | 2016-03-03 10:57:42 |
| 3565 | 1478 | 1 | 2016-03-03 10:58:50 |
| 3566 | 1487 | 1 | 2016-03-03 10:58:59 |
| 3567 | 1481 | 1 | 2016-03-03 10:59:37 |
| 3568 | 1484 | 1 | 2016-03-03 10:59:43 |
| 3569 | 1468 | 1 | 2016-03-03 11:00:31 |
| 3570 | 1474 | 1 | 2016-03-03 11:00:59 |
| 3571 | 1477 | 1 | 2016-03-03 11:02:10 |
| 3572 | 1486 | 1 | 2016-03-03 11:02:18 |
| 3573 | 1497 | 1 | 2016-03-03 11:02:18 |
| 3574 | 1471 | 1 | 2016-03-03 11:02:19 |
| 3575 | 1498 | 1 | 2016-03-03 11:02:38 |
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;