Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,876–3,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3876 | 2018 | 3 | 2016-04-01 14:08:06 |
| 3877 | 2020 | 3 | 2016-04-01 14:09:49 |
| 3878 | 2001 | 3 | 2016-04-01 14:11:04 |
| 3879 | 2003 | 3 | 2016-04-01 14:11:35 |
| 3880 | 2004 | 3 | 2016-04-01 14:12:10 |
| 3881 | 2005 | 3 | 2016-04-01 14:12:52 |
| 3882 | 2002 | 2 | 2016-04-01 14:18:07 |
| 3883 | 2013 | 2 | 2016-04-01 14:23:16 |
| 3884 | 2014 | 2 | 2016-04-01 14:24:39 |
| 3885 | 2015 | 1 | 2016-04-01 14:29:44 |
| 3886 | 2016 | 1 | 2016-04-01 14:32:39 |
| 3887 | 2017 | 2 | 2016-04-01 14:35:10 |
| 3888 | 2004 | 1 | 2016-04-01 14:49:10 |
| 3889 | 2005 | 1 | 2016-04-01 14:52:47 |
| 3890 | 2003 | 1 | 2016-04-01 14:57:02 |
| 3891 | 2015 | 3 | 2016-04-01 15:10:39 |
| 3892 | 2014 | 1 | 2016-04-01 15:12:44 |
| 3893 | 2001 | 1 | 2016-04-01 15:18:09 |
| 3894 | 2017 | 1 | 2016-04-01 15:29:14 |
| 3895 | 2016 | 3 | 2016-04-01 15:45:52 |
| 3896 | 2015 | 2 | 2016-04-01 15:47:54 |
| 3897 | 2017 | 3 | 2016-04-01 16:19:47 |
| 3898 | 2014 | 2 | 2016-04-01 16:24:26 |
| 3899 | 2015 | 1 | 2016-04-01 16:35:06 |
| 3900 | 2023 | 2 | 2016-04-01 16:50:03 |
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;