Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,251–6,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6251 | 2985 | 2 | 2016-12-26 11:18:44 |
| 6252 | 2954 | 2 | 2016-12-26 11:20:33 |
| 6253 | 2956 | 2 | 2016-12-26 11:22:26 |
| 6254 | 2980 | 2 | 2016-12-26 11:25:32 |
| 6255 | 2989 | 2 | 2016-12-26 11:28:03 |
| 6256 | 2970 | 2 | 2016-12-26 11:31:38 |
| 6257 | 2965 | 2 | 2016-12-26 11:34:09 |
| 6258 | 2961 | 2 | 2016-12-26 11:35:24 |
| 6259 | 2963 | 2 | 2016-12-26 11:38:46 |
| 6260 | 2984 | 2 | 2016-12-26 11:40:49 |
| 6261 | 2982 | 2 | 2016-12-26 11:40:51 |
| 6262 | 3309 | 1 | 2016-12-26 14:37:36 |
| 6263 | 3308 | 1 | 2016-12-26 14:43:59 |
| 6264 | 3310 | 1 | 2016-12-26 14:44:20 |
| 6265 | 3308 | 2 | 2016-12-26 15:19:25 |
| 6266 | 3309 | 2 | 2016-12-26 15:31:01 |
| 6267 | 3310 | 2 | 2016-12-26 15:42:06 |
| 6268 | 3309 | 1 | 2016-12-26 16:06:03 |
| 6269 | 3308 | 1 | 2016-12-26 16:40:37 |
| 6270 | 3310 | 1 | 2016-12-26 16:55:18 |
| 6271 | 3080 | 2 | 2016-12-27 10:48:09 |
| 6272 | 3078 | 3 | 2016-12-27 10:48:42 |
| 6273 | 3311 | 2 | 2016-12-27 10:55:25 |
| 6274 | 3079 | 2 | 2016-12-27 10:57:17 |
| 6275 | 3312 | 3 | 2016-12-27 11:07:13 |
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;