Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,401–16,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16401 | 8110 | 1 | 2019-06-09 09:33:05 |
| 16402 | 8109 | 3 | 2019-06-09 09:59:19 |
| 16403 | 8335 | 3 | 2019-06-09 12:46:03 |
| 16404 | 8334 | 3 | 2019-06-09 12:55:19 |
| 16405 | 8333 | 3 | 2019-06-09 12:55:53 |
| 16406 | 8335 | 1 | 2019-06-09 13:33:51 |
| 16407 | 8334 | 1 | 2019-06-09 13:34:42 |
| 16408 | 8333 | 1 | 2019-06-09 13:36:28 |
| 16409 | 8323 | 1 | 2019-06-10 12:51:24 |
| 16410 | 8322 | 2 | 2019-06-10 12:57:13 |
| 16411 | 8323 | 3 | 2019-06-10 13:24:39 |
| 16412 | 8337 | 2 | 2019-06-10 15:39:33 |
| 16413 | 8337 | 3 | 2019-06-10 16:07:09 |
| 16414 | 8338 | 2 | 2019-06-11 09:44:59 |
| 16415 | 8339 | 2 | 2019-06-11 09:47:06 |
| 16416 | 8341 | 1 | 2019-06-11 11:06:33 |
| 16417 | 8340 | 2 | 2019-06-11 11:06:50 |
| 16418 | 8341 | 3 | 2019-06-11 11:57:29 |
| 16419 | 8314 | 2 | 2019-06-11 12:38:20 |
| 16420 | 8313 | 1 | 2019-06-11 12:46:58 |
| 16421 | 8341 | 2 | 2019-06-11 13:32:00 |
| 16422 | 8313 | 3 | 2019-06-11 13:37:49 |
| 16423 | 8314 | 3 | 2019-06-11 13:40:08 |
| 16424 | 8314 | 2 | 2019-06-11 14:37:06 |
| 16425 | 8276 | 1 | 2019-06-11 15:15:32 |
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;