Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,476–3,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3476 | 1820 | 1 | 2016-02-19 10:45:40 |
| 3477 | 1822 | 1 | 2016-02-19 10:56:06 |
| 3478 | 1825 | 2 | 2016-02-19 17:01:59 |
| 3479 | 1825 | 1 | 2016-02-19 17:27:04 |
| 3480 | 1826 | 3 | 2016-02-20 12:06:54 |
| 3481 | 1826 | 2 | 2016-02-20 12:46:07 |
| 3482 | 1807 | 2 | 2016-02-22 12:32:35 |
| 3483 | 1807 | 1 | 2016-02-22 13:01:38 |
| 3484 | 1829 | 1 | 2016-02-23 10:51:31 |
| 3485 | 1827 | 1 | 2016-02-23 10:58:06 |
| 3486 | 1830 | 1 | 2016-02-23 11:00:46 |
| 3487 | 1828 | 1 | 2016-02-23 11:04:02 |
| 3488 | 1827 | 3 | 2016-02-23 11:30:29 |
| 3489 | 1830 | 3 | 2016-02-23 11:42:46 |
| 3490 | 1829 | 3 | 2016-02-23 11:51:04 |
| 3491 | 1831 | 2 | 2016-02-25 13:51:43 |
| 3492 | 1831 | 3 | 2016-02-25 14:32:08 |
| 3493 | 1773 | 2 | 2016-02-26 11:06:06 |
| 3494 | 1773 | 1 | 2016-02-26 12:22:07 |
| 3495 | 1746 | 2 | 2016-02-27 11:49:35 |
| 3496 | 1744 | 2 | 2016-02-27 11:50:48 |
| 3497 | 1747 | 2 | 2016-02-27 11:52:17 |
| 3498 | 1748 | 2 | 2016-02-27 11:54:55 |
| 3499 | 1745 | 2 | 2016-02-27 11:59:16 |
| 3500 | 1748 | 1 | 2016-02-27 12:57:40 |
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;