Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,401–18,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18401 | 9454 | 2 | 2019-11-23 11:14:53 |
| 18402 | 9467 | 3 | 2019-11-23 11:15:12 |
| 18403 | 9458 | 2 | 2019-11-23 11:15:29 |
| 18404 | 9457 | 2 | 2019-11-23 11:21:41 |
| 18405 | 9455 | 2 | 2019-11-23 11:22:29 |
| 18406 | 9466 | 2 | 2019-11-23 11:55:45 |
| 18407 | 9456 | 1 | 2019-11-23 11:58:57 |
| 18408 | 9457 | 1 | 2019-11-23 12:08:09 |
| 18409 | 9465 | 2 | 2019-11-23 12:16:38 |
| 18410 | 9463 | 1 | 2019-11-23 12:21:01 |
| 18411 | 9467 | 2 | 2019-11-23 12:25:28 |
| 18412 | 9458 | 1 | 2019-11-23 12:28:23 |
| 18413 | 9455 | 1 | 2019-11-23 12:28:29 |
| 18414 | 9464 | 1 | 2019-11-23 12:29:57 |
| 18415 | 9454 | 1 | 2019-11-23 12:38:55 |
| 18416 | 9465 | 1 | 2019-11-23 12:52:37 |
| 18417 | 9464 | 3 | 2019-11-23 13:09:43 |
| 18418 | 9466 | 1 | 2019-11-23 13:20:13 |
| 18419 | 9467 | 1 | 2019-11-23 13:23:51 |
| 18420 | 9463 | 3 | 2019-11-23 13:48:37 |
| 18421 | 9434 | 1 | 2019-11-23 15:39:50 |
| 18422 | 9434 | 3 | 2019-11-23 16:30:47 |
| 18423 | 9434 | 2 | 2019-11-23 17:16:25 |
| 18424 | 9423 | 2 | 2019-11-24 10:50:04 |
| 18425 | 9423 | 1 | 2019-11-24 11:23:54 |
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;