Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,851–12,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12851 | 6365 | 2 | 2018-08-31 10:04:45 |
| 12852 | 6373 | 2 | 2018-08-31 10:05:21 |
| 12853 | 6359 | 2 | 2018-08-31 10:05:58 |
| 12854 | 6388 | 2 | 2018-08-31 10:06:11 |
| 12855 | 6377 | 2 | 2018-08-31 10:07:15 |
| 12856 | 6389 | 2 | 2018-08-31 10:07:42 |
| 12857 | 6368 | 2 | 2018-08-31 10:07:52 |
| 12858 | 6375 | 2 | 2018-08-31 10:08:12 |
| 12859 | 6367 | 2 | 2018-08-31 10:09:45 |
| 12860 | 6382 | 2 | 2018-08-31 10:10:52 |
| 12861 | 6363 | 2 | 2018-08-31 10:11:10 |
| 12862 | 6372 | 2 | 2018-08-31 10:11:19 |
| 12863 | 6361 | 2 | 2018-08-31 10:11:49 |
| 12864 | 6374 | 2 | 2018-08-31 10:11:55 |
| 12865 | 6376 | 2 | 2018-08-31 10:12:31 |
| 12866 | 6369 | 2 | 2018-08-31 10:13:03 |
| 12867 | 6364 | 2 | 2018-08-31 10:13:10 |
| 12868 | 6384 | 2 | 2018-08-31 10:13:12 |
| 12869 | 6387 | 2 | 2018-08-31 10:13:34 |
| 12870 | 6370 | 2 | 2018-08-31 10:13:59 |
| 12871 | 6386 | 2 | 2018-08-31 10:14:27 |
| 12872 | 6380 | 2 | 2018-08-31 10:14:59 |
| 12873 | 6594 | 3 | 2018-08-31 10:16:08 |
| 12874 | 6381 | 2 | 2018-08-31 10:16:36 |
| 12875 | 6371 | 1 | 2018-08-31 10:35:59 |
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;