Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 476–500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 476 | 51 | 2 | 2015-04-25 12:42:11 |
| 477 | 54 | 2 | 2015-04-25 12:44:46 |
| 478 | 59 | 1 | 2015-04-25 12:48:06 |
| 479 | 60 | 1 | 2015-04-25 12:48:36 |
| 480 | 50 | 1 | 2015-04-25 12:49:08 |
| 481 | 52 | 2 | 2015-04-25 12:49:29 |
| 482 | 57 | 1 | 2015-04-25 12:50:30 |
| 483 | 16 | 1 | 2015-04-25 12:51:48 |
| 484 | 34 | 1 | 2015-04-25 12:53:39 |
| 485 | 21 | 1 | 2015-04-25 12:55:57 |
| 486 | 62 | 1 | 2015-04-25 12:55:58 |
| 487 | 30 | 1 | 2015-04-25 12:56:23 |
| 488 | 32 | 1 | 2015-04-25 12:57:22 |
| 489 | 39 | 1 | 2015-04-25 12:57:31 |
| 490 | 49 | 1 | 2015-04-25 12:58:02 |
| 491 | 27 | 1 | 2015-04-25 13:04:01 |
| 492 | 10 | 1 | 2015-04-25 13:04:13 |
| 493 | 29 | 1 | 2015-04-25 13:04:15 |
| 494 | 24 | 1 | 2015-04-25 13:05:49 |
| 495 | 36 | 1 | 2015-04-25 13:07:05 |
| 496 | 46 | 1 | 2015-04-25 13:07:59 |
| 497 | 45 | 1 | 2015-04-25 13:08:39 |
| 498 | 31 | 1 | 2015-04-25 13:10:43 |
| 499 | 47 | 1 | 2015-04-25 13:17:46 |
| 500 | 38 | 1 | 2015-04-25 13:19:21 |
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;