Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,076–11,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11076 | 5394 | 3 | 2018-05-07 12:05:42 |
| 11077 | 5378 | 3 | 2018-05-07 12:05:51 |
| 11078 | 5392 | 3 | 2018-05-07 12:07:06 |
| 11079 | 5397 | 3 | 2018-05-07 12:07:30 |
| 11080 | 5411 | 3 | 2018-05-07 12:07:49 |
| 11081 | 5415 | 3 | 2018-05-07 12:08:03 |
| 11082 | 5423 | 3 | 2018-05-07 12:09:08 |
| 11083 | 5389 | 3 | 2018-05-07 12:09:11 |
| 11084 | 5377 | 3 | 2018-05-07 12:11:02 |
| 11085 | 5418 | 3 | 2018-05-07 12:11:13 |
| 11086 | 5390 | 3 | 2018-05-07 12:11:47 |
| 11087 | 5384 | 3 | 2018-05-07 12:12:04 |
| 11088 | 5408 | 3 | 2018-05-07 12:12:29 |
| 11089 | 5406 | 3 | 2018-05-07 12:12:43 |
| 11090 | 5398 | 3 | 2018-05-07 12:12:56 |
| 11091 | 5399 | 3 | 2018-05-07 12:12:59 |
| 11092 | 5413 | 3 | 2018-05-07 12:13:05 |
| 11093 | 5381 | 3 | 2018-05-07 12:13:34 |
| 11094 | 5422 | 3 | 2018-05-07 12:13:50 |
| 11095 | 5380 | 3 | 2018-05-07 12:14:35 |
| 11096 | 5416 | 3 | 2018-05-07 12:15:12 |
| 11097 | 5407 | 3 | 2018-05-07 12:15:18 |
| 11098 | 5412 | 3 | 2018-05-07 12:15:26 |
| 11099 | 5386 | 3 | 2018-05-07 12:15:38 |
| 11100 | 5410 | 3 | 2018-05-07 12:15:42 |
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;