Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,426–16,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16426 | 8324 | 3 | 2019-06-12 10:35:12 |
| 16427 | 8350 | 2 | 2019-06-13 12:54:55 |
| 16428 | 8349 | 2 | 2019-06-13 12:56:08 |
| 16429 | 8347 | 2 | 2019-06-13 13:04:57 |
| 16430 | 8348 | 2 | 2019-06-13 13:06:58 |
| 16431 | 8336 | 2 | 2019-06-13 13:17:13 |
| 16432 | 8349 | 3 | 2019-06-13 13:22:14 |
| 16433 | 8347 | 3 | 2019-06-13 13:45:12 |
| 16434 | 8350 | 3 | 2019-06-13 14:06:15 |
| 16435 | 8347 | 1 | 2019-06-13 14:34:51 |
| 16436 | 8298 | 2 | 2019-06-14 10:08:21 |
| 16437 | 8298 | 1 | 2019-06-14 10:46:51 |
| 16438 | 8298 | 2 | 2019-06-14 11:46:27 |
| 16439 | 8361 | 3 | 2019-06-14 12:41:12 |
| 16440 | 8360 | 2 | 2019-06-14 12:44:48 |
| 16441 | 8361 | 2 | 2019-06-14 13:33:39 |
| 16442 | 8360 | 3 | 2019-06-14 14:08:50 |
| 16443 | 8361 | 3 | 2019-06-14 14:55:11 |
| 16444 | 8360 | 2 | 2019-06-14 15:06:45 |
| 16445 | 8360 | 1 | 2019-06-14 15:51:41 |
| 16446 | 8236 | 3 | 2019-06-14 15:52:21 |
| 16447 | 8237 | 2 | 2019-06-14 15:53:31 |
| 16448 | 8361 | 2 | 2019-06-14 15:57:00 |
| 16449 | 8310 | 1 | 2019-06-14 16:00:02 |
| 16450 | 8311 | 1 | 2019-06-14 16:05:56 |
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;