Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,476–16,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16476 | 8369 | 3 | 2019-06-16 15:35:49 |
| 16477 | 8373 | 2 | 2019-06-16 15:44:54 |
| 16478 | 8370 | 2 | 2019-06-16 16:20:50 |
| 16479 | 8373 | 3 | 2019-06-16 16:21:20 |
| 16480 | 8372 | 3 | 2019-06-16 16:24:03 |
| 16481 | 8370 | 3 | 2019-06-16 17:02:49 |
| 16482 | 8352 | 3 | 2019-06-17 09:26:37 |
| 16483 | 8351 | 3 | 2019-06-17 09:30:37 |
| 16484 | 8325 | 3 | 2019-06-17 09:50:39 |
| 16485 | 8352 | 1 | 2019-06-17 10:06:31 |
| 16486 | 8351 | 1 | 2019-06-17 10:22:40 |
| 16487 | 8325 | 2 | 2019-06-17 10:55:06 |
| 16488 | 8352 | 2 | 2019-06-17 11:02:15 |
| 16489 | 8351 | 2 | 2019-06-17 11:12:45 |
| 16490 | 8325 | 1 | 2019-06-17 11:50:37 |
| 16491 | 8312 | 2 | 2019-06-17 13:47:20 |
| 16492 | 8364 | 2 | 2019-06-18 10:59:22 |
| 16493 | 8363 | 2 | 2019-06-18 11:04:45 |
| 16494 | 8362 | 2 | 2019-06-18 11:08:53 |
| 16495 | 8397 | 2 | 2019-06-18 11:46:26 |
| 16496 | 8363 | 3 | 2019-06-18 11:49:52 |
| 16497 | 8364 | 1 | 2019-06-18 11:52:57 |
| 16498 | 8362 | 3 | 2019-06-18 12:18:36 |
| 16499 | 8343 | 1 | 2019-06-18 12:33:34 |
| 16500 | 8344 | 2 | 2019-06-18 12:35:26 |
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;