Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,001–2,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2001 | 1006 | 1 | 2015-09-03 12:25:20 |
| 2002 | 595 | 3 | 2015-09-03 12:26:07 |
| 2003 | 593 | 3 | 2015-09-03 12:27:02 |
| 2004 | 1008 | 2 | 2015-09-03 13:33:43 |
| 2005 | 1067 | 1 | 2015-09-04 10:17:14 |
| 2006 | 1063 | 2 | 2015-09-04 11:54:53 |
| 2007 | 1062 | 1 | 2015-09-04 11:58:51 |
| 2008 | 1063 | 1 | 2015-09-04 12:43:26 |
| 2009 | 1062 | 2 | 2015-09-04 12:48:31 |
| 2010 | 1062 | 3 | 2015-09-04 13:41:17 |
| 2011 | 1068 | 1 | 2015-09-05 11:54:16 |
| 2012 | 1024 | 1 | 2015-09-05 14:09:17 |
| 2013 | 1025 | 2 | 2015-09-05 14:17:11 |
| 2014 | 1026 | 1 | 2015-09-05 14:20:05 |
| 2015 | 1023 | 2 | 2015-09-05 14:21:36 |
| 2016 | 1069 | 2 | 2015-09-05 14:31:55 |
| 2017 | 1069 | 1 | 2015-09-05 15:10:39 |
| 2018 | 1023 | 1 | 2015-09-05 15:38:35 |
| 2019 | 1023 | 3 | 2015-09-05 16:50:07 |
| 2020 | 989 | 2 | 2015-09-06 16:37:18 |
| 2021 | 1072 | 1 | 2015-09-07 14:42:46 |
| 2022 | 1073 | 1 | 2015-09-07 14:55:14 |
| 2023 | 1021 | 3 | 2015-09-08 14:45:23 |
| 2024 | 1020 | 2 | 2015-09-08 14:58:00 |
| 2025 | 1021 | 1 | 2015-09-08 15:35:43 |
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;