Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,801–18,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18801 | 9246 | 2 | 2019-12-20 14:10:43 |
| 18802 | 9273 | 2 | 2019-12-20 14:10:49 |
| 18803 | 9279 | 2 | 2019-12-20 14:11:20 |
| 18804 | 9260 | 2 | 2019-12-20 14:11:41 |
| 18805 | 9263 | 2 | 2019-12-20 14:11:51 |
| 18806 | 9276 | 2 | 2019-12-20 14:12:08 |
| 18807 | 9256 | 2 | 2019-12-20 14:12:12 |
| 18808 | 9255 | 2 | 2019-12-20 14:12:46 |
| 18809 | 9257 | 2 | 2019-12-20 14:13:28 |
| 18810 | 9254 | 2 | 2019-12-20 14:13:43 |
| 18811 | 9270 | 2 | 2019-12-20 14:13:52 |
| 18812 | 9245 | 2 | 2019-12-20 14:15:38 |
| 18813 | 9267 | 2 | 2019-12-20 14:15:51 |
| 18814 | 9283 | 2 | 2019-12-20 14:15:51 |
| 18815 | 9251 | 2 | 2019-12-20 14:15:57 |
| 18816 | 9284 | 2 | 2019-12-20 14:16:02 |
| 18817 | 9286 | 2 | 2019-12-20 14:16:08 |
| 18818 | 9262 | 2 | 2019-12-20 14:16:55 |
| 18819 | 9277 | 2 | 2019-12-20 14:17:32 |
| 18820 | 9288 | 2 | 2019-12-20 14:18:00 |
| 18821 | 9287 | 2 | 2019-12-20 14:18:06 |
| 18822 | 9271 | 2 | 2019-12-20 14:18:46 |
| 18823 | 9241 | 2 | 2019-12-20 14:19:00 |
| 18824 | 9275 | 2 | 2019-12-20 14:19:29 |
| 18825 | 9264 | 2 | 2019-12-20 14:20:17 |
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;