Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,451–16,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16451 | 8237 | 3 | 2019-06-14 16:18:51 |
| 16452 | 8310 | 3 | 2019-06-14 16:34:12 |
| 16453 | 8311 | 3 | 2019-06-14 17:08:39 |
| 16454 | 8356 | 1 | 2019-06-15 11:08:09 |
| 16455 | 8355 | 1 | 2019-06-15 11:08:38 |
| 16456 | 8357 | 1 | 2019-06-15 11:14:19 |
| 16457 | 8357 | 3 | 2019-06-15 11:57:00 |
| 16458 | 8355 | 3 | 2019-06-15 12:07:05 |
| 16459 | 8356 | 3 | 2019-06-15 12:41:32 |
| 16460 | 8376 | 2 | 2019-06-15 13:31:01 |
| 16461 | 8374 | 2 | 2019-06-15 13:44:17 |
| 16462 | 8375 | 2 | 2019-06-15 13:44:21 |
| 16463 | 8384 | 1 | 2019-06-16 10:36:43 |
| 16464 | 8377 | 2 | 2019-06-16 10:39:31 |
| 16465 | 8378 | 2 | 2019-06-16 10:42:07 |
| 16466 | 8370 | 2 | 2019-06-16 13:25:33 |
| 16467 | 8373 | 2 | 2019-06-16 13:28:24 |
| 16468 | 8372 | 2 | 2019-06-16 13:35:37 |
| 16469 | 8369 | 2 | 2019-06-16 13:40:22 |
| 16470 | 8372 | 3 | 2019-06-16 14:16:54 |
| 16471 | 8369 | 3 | 2019-06-16 14:30:16 |
| 16472 | 8373 | 3 | 2019-06-16 14:41:55 |
| 16473 | 8370 | 3 | 2019-06-16 14:46:54 |
| 16474 | 8372 | 2 | 2019-06-16 14:50:01 |
| 16475 | 8369 | 2 | 2019-06-16 14:58:14 |
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;