Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,451–8,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8451 | 4342 | 2 | 2017-08-13 14:00:33 |
| 8452 | 4381 | 2 | 2017-08-13 17:01:32 |
| 8453 | 4381 | 3 | 2017-08-13 17:49:15 |
| 8454 | 4384 | 2 | 2017-08-14 09:32:29 |
| 8455 | 4383 | 2 | 2017-08-14 09:34:27 |
| 8456 | 4382 | 2 | 2017-08-14 09:43:16 |
| 8457 | 4383 | 3 | 2017-08-14 10:43:59 |
| 8458 | 4384 | 1 | 2017-08-14 10:53:50 |
| 8459 | 4385 | 2 | 2017-08-14 13:24:48 |
| 8460 | 4388 | 2 | 2017-08-14 14:39:59 |
| 8461 | 4386 | 2 | 2017-08-14 14:44:33 |
| 8462 | 4389 | 2 | 2017-08-14 14:48:20 |
| 8463 | 4387 | 2 | 2017-08-14 14:53:19 |
| 8464 | 4385 | 1 | 2017-08-14 14:56:52 |
| 8465 | 4389 | 3 | 2017-08-14 15:16:17 |
| 8466 | 4388 | 3 | 2017-08-14 15:37:12 |
| 8467 | 4386 | 3 | 2017-08-14 16:18:24 |
| 8468 | 4389 | 1 | 2017-08-14 16:26:11 |
| 8469 | 4387 | 3 | 2017-08-14 16:28:12 |
| 8470 | 4388 | 1 | 2017-08-14 16:31:15 |
| 8471 | 4387 | 1 | 2017-08-14 17:02:59 |
| 8472 | 4386 | 1 | 2017-08-14 17:06:41 |
| 8473 | 4394 | 2 | 2017-08-15 10:05:03 |
| 8474 | 4395 | 1 | 2017-08-15 10:09:47 |
| 8475 | 4395 | 3 | 2017-08-15 10:38:05 |
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;