Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 451–475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 451 | 23 | 1 | 2015-04-25 12:21:50 |
| 452 | 65 | 1 | 2015-04-25 12:21:51 |
| 453 | 13 | 2 | 2015-04-25 12:21:52 |
| 454 | 8 | 1 | 2015-04-25 12:21:58 |
| 455 | 53 | 2 | 2015-04-25 12:22:17 |
| 456 | 61 | 2 | 2015-04-25 12:22:55 |
| 457 | 28 | 1 | 2015-04-25 12:24:06 |
| 458 | 33 | 2 | 2015-04-25 12:26:57 |
| 459 | 9 | 1 | 2015-04-25 12:27:04 |
| 460 | 48 | 1 | 2015-04-25 12:27:49 |
| 461 | 30 | 2 | 2015-04-25 12:28:14 |
| 462 | 32 | 2 | 2015-04-25 12:28:39 |
| 463 | 64 | 2 | 2015-04-25 12:29:22 |
| 464 | 11 | 1 | 2015-04-25 12:29:50 |
| 465 | 18 | 1 | 2015-04-25 12:30:08 |
| 466 | 46 | 2 | 2015-04-25 12:30:51 |
| 467 | 14 | 2 | 2015-04-25 12:31:40 |
| 468 | 36 | 2 | 2015-04-25 12:33:33 |
| 469 | 17 | 2 | 2015-04-25 12:33:47 |
| 470 | 43 | 2 | 2015-04-25 12:35:10 |
| 471 | 26 | 1 | 2015-04-25 12:36:14 |
| 472 | 12 | 2 | 2015-04-25 12:36:33 |
| 473 | 55 | 2 | 2015-04-25 12:37:16 |
| 474 | 298 | 3 | 2015-04-25 12:38:57 |
| 475 | 37 | 1 | 2015-04-25 12:41:35 |
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;