Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,801–12,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12801 | 5858 | 2 | 2018-08-29 14:04:03 |
| 12802 | 5857 | 2 | 2018-08-29 14:05:24 |
| 12803 | 5848 | 2 | 2018-08-29 14:06:21 |
| 12804 | 5846 | 2 | 2018-08-29 14:07:05 |
| 12805 | 5838 | 2 | 2018-08-29 14:07:48 |
| 12806 | 5845 | 2 | 2018-08-29 14:08:22 |
| 12807 | 5843 | 2 | 2018-08-29 14:08:48 |
| 12808 | 5862 | 2 | 2018-08-29 14:09:37 |
| 12809 | 5840 | 2 | 2018-08-29 14:09:42 |
| 12810 | 5861 | 2 | 2018-08-29 14:10:01 |
| 12811 | 5851 | 2 | 2018-08-29 14:11:05 |
| 12812 | 5842 | 2 | 2018-08-29 14:11:46 |
| 12813 | 5863 | 2 | 2018-08-29 14:11:58 |
| 12814 | 5836 | 2 | 2018-08-29 14:12:04 |
| 12815 | 5850 | 2 | 2018-08-29 14:12:59 |
| 12816 | 5864 | 2 | 2018-08-29 14:13:03 |
| 12817 | 6470 | 3 | 2018-08-29 14:20:55 |
| 12818 | 6572 | 2 | 2018-08-30 09:24:13 |
| 12819 | 6571 | 2 | 2018-08-30 09:29:56 |
| 12820 | 6580 | 2 | 2018-08-30 09:40:14 |
| 12821 | 6582 | 2 | 2018-08-30 09:45:35 |
| 12822 | 6581 | 2 | 2018-08-30 09:46:14 |
| 12823 | 6580 | 3 | 2018-08-30 10:08:42 |
| 12824 | 6581 | 3 | 2018-08-30 10:17:17 |
| 12825 | 6571 | 1 | 2018-08-30 10:30: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;