Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,376–10,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10376 | 5358 | 3 | 2018-03-10 12:40:13 |
| 10377 | 5344 | 3 | 2018-03-10 12:54:15 |
| 10378 | 5346 | 2 | 2018-03-10 13:10:20 |
| 10379 | 5358 | 2 | 2018-03-10 13:36:37 |
| 10380 | 5345 | 2 | 2018-03-10 13:52:22 |
| 10381 | 5344 | 2 | 2018-03-10 14:11:43 |
| 10382 | 5361 | 1 | 2018-03-11 09:42:55 |
| 10383 | 5360 | 1 | 2018-03-11 09:51:40 |
| 10384 | 5361 | 2 | 2018-03-11 10:20:34 |
| 10385 | 5359 | 2 | 2018-03-11 10:46:19 |
| 10386 | 5360 | 2 | 2018-03-11 11:00:46 |
| 10387 | 5361 | 1 | 2018-03-11 11:29:54 |
| 10388 | 5359 | 1 | 2018-03-11 11:52:06 |
| 10389 | 5360 | 1 | 2018-03-11 11:54:03 |
| 10390 | 5359 | 2 | 2018-03-11 12:25:59 |
| 10391 | 5361 | 2 | 2018-03-11 12:26:57 |
| 10392 | 5360 | 2 | 2018-03-11 13:24:08 |
| 10393 | 5362 | 2 | 2018-03-11 13:35:37 |
| 10394 | 5362 | 3 | 2018-03-11 14:54:25 |
| 10395 | 5362 | 2 | 2018-03-11 16:20:42 |
| 10396 | 5365 | 1 | 2018-03-13 11:51:17 |
| 10397 | 5366 | 1 | 2018-03-13 11:52:06 |
| 10398 | 5368 | 1 | 2018-03-13 11:56:45 |
| 10399 | 5367 | 1 | 2018-03-13 12:06:08 |
| 10400 | 5368 | 3 | 2018-03-13 12:37:29 |
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;