Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,201–2,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2201 | 1265 | 1 | 2015-10-05 12:13:38 |
| 2202 | 1266 | 2 | 2015-10-05 12:24:14 |
| 2203 | 1265 | 2 | 2015-10-05 13:48:26 |
| 2204 | 1188 | 2 | 2015-10-07 13:31:45 |
| 2205 | 1189 | 2 | 2015-10-07 13:45:37 |
| 2206 | 1188 | 1 | 2015-10-07 14:18:33 |
| 2207 | 1189 | 1 | 2015-10-07 14:34:42 |
| 2208 | 1290 | 2 | 2015-10-08 10:47:32 |
| 2209 | 1299 | 2 | 2015-10-10 10:48:20 |
| 2210 | 1302 | 1 | 2015-10-11 09:58:21 |
| 2211 | 1303 | 2 | 2015-10-11 09:59:14 |
| 2212 | 1300 | 2 | 2015-10-11 10:00:23 |
| 2213 | 1301 | 2 | 2015-10-11 10:00:32 |
| 2214 | 1300 | 1 | 2015-10-11 10:31:32 |
| 2215 | 1300 | 3 | 2015-10-11 11:00:28 |
| 2216 | 1303 | 1 | 2015-10-11 11:25:31 |
| 2217 | 1301 | 1 | 2015-10-11 11:27:55 |
| 2218 | 1303 | 3 | 2015-10-11 12:06:55 |
| 2219 | 1305 | 2 | 2015-10-11 12:09:20 |
| 2220 | 1304 | 1 | 2015-10-11 12:15:37 |
| 2221 | 1301 | 3 | 2015-10-11 12:17:14 |
| 2222 | 1306 | 1 | 2015-10-11 12:19:12 |
| 2223 | 1305 | 3 | 2015-10-11 13:01:19 |
| 2224 | 1306 | 3 | 2015-10-11 13:03:04 |
| 2225 | 1304 | 3 | 2015-10-11 13:12:00 |
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;