Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,576–3,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3576 | 1492 | 1 | 2016-03-03 11:03:56 |
| 3577 | 1495 | 1 | 2016-03-03 11:03:58 |
| 3578 | 1499 | 1 | 2016-03-03 11:04:22 |
| 3579 | 1485 | 1 | 2016-03-03 11:05:35 |
| 3580 | 1500 | 1 | 2016-03-03 11:05:47 |
| 3581 | 1494 | 1 | 2016-03-03 11:06:13 |
| 3582 | 1488 | 1 | 2016-03-03 11:06:41 |
| 3583 | 1798 | 2 | 2016-03-04 09:17:26 |
| 3584 | 1823 | 2 | 2016-03-05 13:15:18 |
| 3585 | 1824 | 2 | 2016-03-05 13:18:52 |
| 3586 | 1865 | 2 | 2016-03-06 10:47:54 |
| 3587 | 1864 | 2 | 2016-03-06 10:54:59 |
| 3588 | 1862 | 2 | 2016-03-06 11:14:36 |
| 3589 | 1859 | 3 | 2016-03-06 11:14:53 |
| 3590 | 1863 | 1 | 2016-03-06 11:16:22 |
| 3591 | 1861 | 1 | 2016-03-06 11:16:42 |
| 3592 | 1860 | 2 | 2016-03-06 11:18:02 |
| 3593 | 1865 | 3 | 2016-03-06 11:40:40 |
| 3594 | 1864 | 3 | 2016-03-06 11:58:31 |
| 3595 | 1862 | 1 | 2016-03-06 11:58:49 |
| 3596 | 1863 | 3 | 2016-03-06 12:21:50 |
| 3597 | 1864 | 2 | 2016-03-06 12:27:05 |
| 3598 | 1860 | 3 | 2016-03-06 12:37:00 |
| 3599 | 1861 | 3 | 2016-03-06 12:37:14 |
| 3600 | 1862 | 3 | 2016-03-06 13:13:46 |
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;