Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,026–2,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2026 | 1034 | 2 | 2015-09-09 10:30:55 |
| 2027 | 1035 | 2 | 2015-09-09 10:33:13 |
| 2028 | 1075 | 1 | 2015-09-09 17:03:32 |
| 2029 | 1074 | 1 | 2015-09-09 17:08:22 |
| 2030 | 1075 | 2 | 2015-09-09 17:35:54 |
| 2031 | 1080 | 2 | 2015-09-11 09:35:51 |
| 2032 | 1080 | 3 | 2015-09-11 10:07:59 |
| 2033 | 1080 | 1 | 2015-09-11 11:24:48 |
| 2034 | 1083 | 2 | 2015-09-11 12:25:59 |
| 2035 | 1084 | 2 | 2015-09-11 12:31:09 |
| 2036 | 1085 | 1 | 2015-09-11 12:42:13 |
| 2037 | 1084 | 1 | 2015-09-11 13:12:51 |
| 2038 | 1085 | 3 | 2015-09-11 13:43:40 |
| 2039 | 1083 | 1 | 2015-09-11 13:52:52 |
| 2040 | 1085 | 2 | 2015-09-11 14:35:04 |
| 2041 | 1085 | 3 | 2015-09-11 15:31:42 |
| 2042 | 1086 | 2 | 2015-09-12 16:03:47 |
| 2043 | 1086 | 3 | 2015-09-12 17:04:50 |
| 2044 | 1088 | 1 | 2015-09-13 10:36:56 |
| 2045 | 1087 | 1 | 2015-09-13 10:46:27 |
| 2046 | 1087 | 2 | 2015-09-13 11:16:16 |
| 2047 | 1089 | 2 | 2015-09-13 11:36:58 |
| 2048 | 1088 | 2 | 2015-09-13 11:42:43 |
| 2049 | 1090 | 2 | 2015-09-13 11:45:02 |
| 2050 | 1088 | 1 | 2015-09-13 12:20:33 |
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;