Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,426–14,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14426 | 7265 | 2 | 2019-01-05 16:37:42 |
| 14427 | 7264 | 2 | 2019-01-05 16:45:04 |
| 14428 | 7262 | 2 | 2019-01-05 16:46:08 |
| 14429 | 7372 | 1 | 2019-01-06 10:18:46 |
| 14430 | 7371 | 1 | 2019-01-06 10:22:56 |
| 14431 | 7377 | 2 | 2019-01-06 13:03:20 |
| 14432 | 7378 | 2 | 2019-01-06 14:16:53 |
| 14433 | 7373 | 2 | 2019-01-08 15:29:56 |
| 14434 | 7374 | 3 | 2019-01-08 15:30:09 |
| 14435 | 7376 | 2 | 2019-01-08 15:30:24 |
| 14436 | 7375 | 2 | 2019-01-08 15:40:07 |
| 14437 | 7376 | 3 | 2019-01-08 15:56:56 |
| 14438 | 7375 | 3 | 2019-01-08 16:09:07 |
| 14439 | 7373 | 3 | 2019-01-08 16:39:27 |
| 14440 | 7375 | 1 | 2019-01-08 17:24:27 |
| 14441 | 7376 | 1 | 2019-01-08 17:28:02 |
| 14442 | 7381 | 1 | 2019-01-09 10:12:50 |
| 14443 | 7380 | 1 | 2019-01-09 10:16:49 |
| 14444 | 7352 | 2 | 2019-01-09 13:07:44 |
| 14445 | 7353 | 2 | 2019-01-09 13:11:32 |
| 14446 | 7355 | 2 | 2019-01-09 13:12:54 |
| 14447 | 7354 | 2 | 2019-01-09 13:15:39 |
| 14448 | 7354 | 3 | 2019-01-09 13:57:18 |
| 14449 | 7355 | 3 | 2019-01-09 14:02:22 |
| 14450 | 7352 | 3 | 2019-01-09 14:18:30 |
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;