Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,601–8,625 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8601 | 4401 | 2 | 2017-08-26 11:54:04 |
| 8602 | 4497 | 2 | 2017-08-26 12:06:06 |
| 8603 | 4498 | 2 | 2017-08-26 12:11:14 |
| 8604 | 4496 | 2 | 2017-08-26 12:20:33 |
| 8605 | 4497 | 1 | 2017-08-26 12:57:26 |
| 8606 | 4401 | 1 | 2017-08-26 13:08:45 |
| 8607 | 4402 | 1 | 2017-08-26 13:10:49 |
| 8608 | 4498 | 1 | 2017-08-26 13:22:46 |
| 8609 | 4496 | 1 | 2017-08-26 13:47:26 |
| 8610 | 4503 | 2 | 2017-08-26 14:16:22 |
| 8611 | 4503 | 1 | 2017-08-26 15:45:42 |
| 8612 | 4506 | 2 | 2017-08-26 15:53:20 |
| 8613 | 4504 | 2 | 2017-08-26 15:59:12 |
| 8614 | 4470 | 1 | 2017-08-26 16:02:17 |
| 8615 | 4505 | 2 | 2017-08-26 16:03:20 |
| 8616 | 4470 | 3 | 2017-08-26 16:35:15 |
| 8617 | 4470 | 2 | 2017-08-26 17:44:27 |
| 8618 | 4515 | 2 | 2017-08-27 12:12:48 |
| 8619 | 4517 | 2 | 2017-08-27 12:18:05 |
| 8620 | 4519 | 2 | 2017-08-27 12:19:55 |
| 8621 | 4518 | 2 | 2017-08-27 12:24:06 |
| 8622 | 4516 | 2 | 2017-08-27 12:27:22 |
| 8623 | 4518 | 3 | 2017-08-27 13:01:11 |
| 8624 | 4519 | 3 | 2017-08-27 13:11:21 |
| 8625 | 4516 | 3 | 2017-08-27 13:11:36 |
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;