Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,351–18,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18351 | 9422 | 3 | 2019-11-19 11:50:56 |
| 18352 | 9422 | 2 | 2019-11-19 12:44:18 |
| 18353 | 9343 | 3 | 2019-11-19 13:39:30 |
| 18354 | 9344 | 3 | 2019-11-19 13:50:57 |
| 18355 | 9343 | 2 | 2019-11-19 14:19:47 |
| 18356 | 9344 | 1 | 2019-11-19 15:18:05 |
| 18357 | 9344 | 3 | 2019-11-19 15:49:00 |
| 18358 | 9343 | 3 | 2019-11-19 15:53:06 |
| 18359 | 9433 | 2 | 2019-11-20 11:53:14 |
| 18360 | 9432 | 2 | 2019-11-20 11:55:15 |
| 18361 | 9430 | 2 | 2019-11-20 12:00:25 |
| 18362 | 9431 | 2 | 2019-11-20 12:03:14 |
| 18363 | 9430 | 3 | 2019-11-20 12:27:02 |
| 18364 | 9431 | 3 | 2019-11-20 12:50:56 |
| 18365 | 9432 | 3 | 2019-11-20 12:56:04 |
| 18366 | 9433 | 3 | 2019-11-20 13:07:18 |
| 18367 | 9443 | 3 | 2019-11-21 15:07:25 |
| 18368 | 9444 | 3 | 2019-11-21 15:09:42 |
| 18369 | 9446 | 3 | 2019-11-21 15:14:40 |
| 18370 | 9445 | 3 | 2019-11-21 15:15:15 |
| 18371 | 9447 | 3 | 2019-11-21 15:16:06 |
| 18372 | 9175 | 2 | 2019-11-22 11:54:42 |
| 18373 | 9459 | 3 | 2019-11-22 12:31:18 |
| 18374 | 9462 | 2 | 2019-11-22 12:31:31 |
| 18375 | 9461 | 3 | 2019-11-22 12:31:46 |
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;