Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,001–1,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1001 | 515 | 2 | 2015-06-06 14:01:49 |
| 1002 | 514 | 2 | 2015-06-06 14:03:35 |
| 1003 | 517 | 2 | 2015-06-06 14:07:40 |
| 1004 | 516 | 2 | 2015-06-06 14:11:12 |
| 1005 | 639 | 3 | 2015-06-06 15:54:32 |
| 1006 | 607 | 2 | 2015-06-07 14:22:38 |
| 1007 | 607 | 3 | 2015-06-07 15:55:01 |
| 1008 | 607 | 2 | 2015-06-07 16:41:29 |
| 1009 | 645 | 3 | 2015-06-08 10:54:44 |
| 1010 | 643 | 3 | 2015-06-08 10:54:51 |
| 1011 | 644 | 3 | 2015-06-08 10:55:36 |
| 1012 | 646 | 3 | 2015-06-08 10:56:12 |
| 1013 | 642 | 2 | 2015-06-08 11:06:02 |
| 1014 | 640 | 2 | 2015-06-08 11:07:48 |
| 1015 | 641 | 2 | 2015-06-08 11:11:09 |
| 1016 | 647 | 2 | 2015-06-08 11:36:24 |
| 1017 | 648 | 2 | 2015-06-08 11:42:14 |
| 1018 | 649 | 2 | 2015-06-08 15:03:06 |
| 1019 | 636 | 2 | 2015-06-09 09:30:19 |
| 1020 | 635 | 2 | 2015-06-09 09:37:22 |
| 1021 | 624 | 3 | 2015-06-10 15:21:34 |
| 1022 | 625 | 2 | 2015-06-10 15:21:47 |
| 1023 | 624 | 2 | 2015-06-10 16:03:37 |
| 1024 | 624 | 3 | 2015-06-10 17:18:24 |
| 1025 | 632 | 1 | 2015-06-11 09:21:40 |
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;