Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,676–10,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10676 | 5508 | 2 | 2018-04-09 09:10:33 |
| 10677 | 5506 | 3 | 2018-04-09 10:22:18 |
| 10678 | 5508 | 1 | 2018-04-09 10:41:03 |
| 10679 | 5507 | 1 | 2018-04-09 10:43:07 |
| 10680 | 5534 | 2 | 2018-04-09 15:30:33 |
| 10681 | 5535 | 2 | 2018-04-09 15:30:52 |
| 10682 | 5533 | 2 | 2018-04-09 15:32:52 |
| 10683 | 5534 | 1 | 2018-04-09 16:12:43 |
| 10684 | 5535 | 1 | 2018-04-09 16:43:41 |
| 10685 | 5533 | 1 | 2018-04-09 16:59:52 |
| 10686 | 5534 | 2 | 2018-04-09 17:17:31 |
| 10687 | 5535 | 2 | 2018-04-09 17:43:53 |
| 10688 | 5536 | 3 | 2018-04-10 11:49:55 |
| 10689 | 5538 | 3 | 2018-04-10 11:51:53 |
| 10690 | 5537 | 3 | 2018-04-10 12:00:13 |
| 10691 | 5537 | 2 | 2018-04-10 12:53:31 |
| 10692 | 5519 | 2 | 2018-04-10 13:05:54 |
| 10693 | 5536 | 2 | 2018-04-10 13:25:00 |
| 10694 | 5537 | 3 | 2018-04-10 13:25:39 |
| 10695 | 5519 | 3 | 2018-04-10 13:42:51 |
| 10696 | 5536 | 3 | 2018-04-10 13:54:56 |
| 10697 | 5537 | 2 | 2018-04-10 14:19:18 |
| 10698 | 5536 | 2 | 2018-04-10 14:44:32 |
| 10699 | 5539 | 3 | 2018-04-10 15:31:11 |
| 10700 | 5516 | 2 | 2018-04-10 15:41:33 |
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;