Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,451–18,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18451 | 9483 | 1 | 2019-11-28 10:53:30 |
| 18452 | 9480 | 1 | 2019-11-28 10:56:30 |
| 18453 | 9381 | 3 | 2019-11-28 10:59:23 |
| 18454 | 9482 | 2 | 2019-11-28 11:24:10 |
| 18455 | 9481 | 2 | 2019-11-28 11:31:39 |
| 18456 | 9483 | 2 | 2019-11-28 11:33:18 |
| 18457 | 9482 | 3 | 2019-11-28 12:10:01 |
| 18458 | 9481 | 3 | 2019-11-28 12:18:48 |
| 18459 | 9480 | 2 | 2019-11-28 12:32:04 |
| 18460 | 9480 | 3 | 2019-11-28 13:02:56 |
| 18461 | 9483 | 3 | 2019-11-28 13:07:26 |
| 18462 | 9428 | 3 | 2019-11-28 13:29:50 |
| 18463 | 9429 | 2 | 2019-11-28 13:32:26 |
| 18464 | 9428 | 1 | 2019-11-28 14:16:11 |
| 18465 | 9429 | 3 | 2019-11-28 14:28:10 |
| 18466 | 9429 | 2 | 2019-11-28 15:21:27 |
| 18467 | 9428 | 3 | 2019-11-28 15:26:37 |
| 18468 | 9473 | 1 | 2019-11-28 15:42:20 |
| 18469 | 9471 | 1 | 2019-11-28 15:43:35 |
| 18470 | 9470 | 1 | 2019-11-28 15:48:19 |
| 18471 | 9472 | 1 | 2019-11-28 15:55:54 |
| 18472 | 9473 | 3 | 2019-11-28 16:42:57 |
| 18473 | 9471 | 3 | 2019-11-28 16:46:59 |
| 18474 | 9470 | 3 | 2019-11-28 16:49:57 |
| 18475 | 9472 | 3 | 2019-11-28 16:53:58 |
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;