Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,426–9,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9426 | 4844 | 3 | 2017-11-13 11:54:07 |
| 9427 | 4845 | 1 | 2017-11-13 12:19:13 |
| 9428 | 4844 | 1 | 2017-11-13 12:58:29 |
| 9429 | 4852 | 2 | 2017-11-15 12:28:34 |
| 9430 | 4851 | 2 | 2017-11-15 12:42:47 |
| 9431 | 4780 | 1 | 2017-11-15 12:50:28 |
| 9432 | 4852 | 3 | 2017-11-15 13:55:17 |
| 9433 | 4780 | 3 | 2017-11-15 14:11:30 |
| 9434 | 4780 | 2 | 2017-11-15 15:03:37 |
| 9435 | 4855 | 2 | 2017-11-17 11:59:51 |
| 9436 | 4853 | 2 | 2017-11-17 12:05:59 |
| 9437 | 4854 | 1 | 2017-11-17 12:08:43 |
| 9438 | 4856 | 2 | 2017-11-17 12:13:06 |
| 9439 | 4854 | 2 | 2017-11-17 12:41:00 |
| 9440 | 4856 | 1 | 2017-11-17 12:56:32 |
| 9441 | 4855 | 3 | 2017-11-17 13:27:23 |
| 9442 | 4853 | 1 | 2017-11-17 13:29:17 |
| 9443 | 4855 | 2 | 2017-11-17 14:16:37 |
| 9444 | 4856 | 2 | 2017-11-17 14:20:50 |
| 9445 | 4853 | 2 | 2017-11-17 14:31:46 |
| 9446 | 4807 | 2 | 2017-11-18 10:09:59 |
| 9447 | 4808 | 2 | 2017-11-18 10:19:14 |
| 9448 | 4807 | 1 | 2017-11-18 11:36:17 |
| 9449 | 4860 | 3 | 2017-11-21 09:52:48 |
| 9450 | 4860 | 1 | 2017-11-21 10:43:08 |
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;