Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,376–14,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14376 | 7349 | 3 | 2018-12-26 10:49:06 |
| 14377 | 7348 | 3 | 2018-12-26 10:51:43 |
| 14378 | 7351 | 3 | 2018-12-26 10:58:32 |
| 14379 | 7348 | 1 | 2018-12-26 11:29:16 |
| 14380 | 7350 | 1 | 2018-12-26 11:34:13 |
| 14381 | 7351 | 1 | 2018-12-26 12:11:46 |
| 14382 | 7349 | 1 | 2018-12-26 12:13:24 |
| 14383 | 7357 | 2 | 2018-12-26 13:39:07 |
| 14384 | 7356 | 2 | 2018-12-26 13:41:32 |
| 14385 | 7359 | 2 | 2018-12-26 13:43:33 |
| 14386 | 7358 | 2 | 2018-12-26 13:44:42 |
| 14387 | 7357 | 3 | 2018-12-26 14:28:51 |
| 14388 | 7250 | 3 | 2018-12-26 14:41:12 |
| 14389 | 7251 | 2 | 2018-12-26 14:46:32 |
| 14390 | 7358 | 3 | 2018-12-26 14:57:44 |
| 14391 | 7359 | 3 | 2018-12-26 15:00:48 |
| 14392 | 7356 | 3 | 2018-12-26 15:13:13 |
| 14393 | 7251 | 3 | 2018-12-26 16:07:29 |
| 14394 | 7251 | 2 | 2018-12-26 17:39:58 |
| 14395 | 7346 | 2 | 2018-12-27 15:21:00 |
| 14396 | 7347 | 2 | 2018-12-27 15:24:03 |
| 14397 | 7345 | 2 | 2018-12-27 15:29:58 |
| 14398 | 7344 | 2 | 2018-12-27 15:31:23 |
| 14399 | 7347 | 3 | 2018-12-27 16:04:22 |
| 14400 | 7345 | 1 | 2018-12-27 16:26:24 |
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;