Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,001–13,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13001 | 6591 | 3 | 2018-09-02 14:33:09 |
| 13002 | 6583 | 1 | 2018-09-03 12:22:32 |
| 13003 | 6584 | 1 | 2018-09-03 12:32:42 |
| 13004 | 6584 | 2 | 2018-09-03 13:33:49 |
| 13005 | 6583 | 2 | 2018-09-03 13:54:27 |
| 13006 | 6557 | 2 | 2018-09-03 14:06:21 |
| 13007 | 6556 | 2 | 2018-09-03 14:07:11 |
| 13008 | 6558 | 2 | 2018-09-03 14:15:57 |
| 13009 | 6584 | 3 | 2018-09-03 14:49:43 |
| 13010 | 6556 | 3 | 2018-09-03 14:59:06 |
| 13011 | 6557 | 3 | 2018-09-03 14:59:56 |
| 13012 | 6583 | 3 | 2018-09-03 15:04:22 |
| 13013 | 6558 | 3 | 2018-09-03 15:28:09 |
| 13014 | 6557 | 2 | 2018-09-03 15:45:27 |
| 13015 | 6556 | 2 | 2018-09-03 16:04:30 |
| 13016 | 6558 | 2 | 2018-09-03 16:19:42 |
| 13017 | 6570 | 1 | 2018-09-04 11:05:01 |
| 13018 | 6568 | 1 | 2018-09-04 11:08:23 |
| 13019 | 6569 | 1 | 2018-09-04 11:08:42 |
| 13020 | 6613 | 3 | 2018-09-04 11:36:35 |
| 13021 | 6613 | 1 | 2018-09-04 12:26:45 |
| 13022 | 6611 | 3 | 2018-09-04 15:39:47 |
| 13023 | 6612 | 3 | 2018-09-04 15:44:06 |
| 13024 | 6617 | 2 | 2018-09-05 11:01:56 |
| 13025 | 6616 | 2 | 2018-09-05 11:05:48 |
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;