Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,551–18,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18551 | 9516 | 2 | 2019-12-08 10:47:48 |
| 18552 | 9515 | 2 | 2019-12-08 10:51:33 |
| 18553 | 9399 | 2 | 2019-12-08 11:13:23 |
| 18554 | 9522 | 3 | 2019-12-08 11:20:49 |
| 18555 | 9400 | 1 | 2019-12-08 11:34:50 |
| 18556 | 9523 | 3 | 2019-12-08 11:41:15 |
| 18557 | 9399 | 1 | 2019-12-08 11:46:49 |
| 18558 | 9521 | 3 | 2019-12-08 12:01:05 |
| 18559 | 9400 | 2 | 2019-12-08 12:13:15 |
| 18560 | 9523 | 1 | 2019-12-08 12:20:53 |
| 18561 | 9399 | 2 | 2019-12-08 12:32:02 |
| 18562 | 9521 | 1 | 2019-12-08 12:40:31 |
| 18563 | 9526 | 1 | 2019-12-08 13:23:49 |
| 18564 | 9526 | 3 | 2019-12-08 14:10:03 |
| 18565 | 9474 | 2 | 2019-12-08 14:14:32 |
| 18566 | 9475 | 2 | 2019-12-08 14:14:46 |
| 18567 | 9526 | 2 | 2019-12-08 14:43:17 |
| 18568 | 9527 | 2 | 2019-12-08 16:03:55 |
| 18569 | 9527 | 3 | 2019-12-08 17:35:26 |
| 18570 | 9530 | 2 | 2019-12-10 11:02:27 |
| 18571 | 9531 | 2 | 2019-12-10 11:04:03 |
| 18572 | 9532 | 1 | 2019-12-10 12:37:59 |
| 18573 | 9532 | 2 | 2019-12-10 13:26:49 |
| 18574 | 9533 | 2 | 2019-12-10 14:31:47 |
| 18575 | 9534 | 2 | 2019-12-10 14:32: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;