Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,376–18,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18376 | 9460 | 3 | 2019-11-22 12:38:03 |
| 18377 | 9461 | 2 | 2019-11-22 13:06:56 |
| 18378 | 9175 | 3 | 2019-11-22 13:20:04 |
| 18379 | 9459 | 2 | 2019-11-22 13:28:06 |
| 18380 | 9461 | 3 | 2019-11-22 13:44:48 |
| 18381 | 9460 | 2 | 2019-11-22 13:54:26 |
| 18382 | 9462 | 3 | 2019-11-22 14:00:39 |
| 18383 | 9175 | 1 | 2019-11-22 14:14:08 |
| 18384 | 9459 | 3 | 2019-11-22 14:53:17 |
| 18385 | 9427 | 3 | 2019-11-22 15:06:09 |
| 18386 | 9426 | 3 | 2019-11-22 15:08:16 |
| 18387 | 9462 | 2 | 2019-11-22 15:19:09 |
| 18388 | 9460 | 3 | 2019-11-22 15:22:07 |
| 18389 | 9427 | 2 | 2019-11-22 15:40:40 |
| 18390 | 9397 | 1 | 2019-11-22 16:16:37 |
| 18391 | 9427 | 3 | 2019-11-22 16:25:56 |
| 18392 | 9398 | 2 | 2019-11-22 16:26:56 |
| 18393 | 9426 | 2 | 2019-11-22 16:42:48 |
| 18394 | 9426 | 3 | 2019-11-22 17:11:00 |
| 18395 | 9467 | 2 | 2019-11-23 09:54:00 |
| 18396 | 9466 | 2 | 2019-11-23 09:59:01 |
| 18397 | 9465 | 2 | 2019-11-23 10:08:59 |
| 18398 | 9465 | 3 | 2019-11-23 11:02:01 |
| 18399 | 9466 | 3 | 2019-11-23 11:09:21 |
| 18400 | 9456 | 2 | 2019-11-23 11:11:03 |
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;