Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,426–4,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4426 | 2356 | 1 | 2016-06-09 14:13:48 |
| 4427 | 2355 | 2 | 2016-06-09 14:25:16 |
| 4428 | 2260 | 2 | 2016-06-09 14:52:46 |
| 4429 | 2259 | 2 | 2016-06-09 14:57:02 |
| 4430 | 2261 | 2 | 2016-06-09 15:03:36 |
| 4431 | 2354 | 3 | 2016-06-09 15:31:33 |
| 4432 | 2356 | 3 | 2016-06-09 15:42:10 |
| 4433 | 2259 | 1 | 2016-06-09 15:51:49 |
| 4434 | 2260 | 1 | 2016-06-09 15:57:40 |
| 4435 | 2261 | 1 | 2016-06-09 16:24:33 |
| 4436 | 2356 | 1 | 2016-06-09 16:42:59 |
| 4437 | 2354 | 1 | 2016-06-09 16:48:57 |
| 4438 | 2358 | 2 | 2016-06-10 11:14:36 |
| 4439 | 2357 | 2 | 2016-06-10 11:23:01 |
| 4440 | 2359 | 2 | 2016-06-10 13:02:43 |
| 4441 | 2359 | 3 | 2016-06-10 14:00:18 |
| 4442 | 2339 | 2 | 2016-06-10 15:10:58 |
| 4443 | 2360 | 1 | 2016-06-10 16:45:38 |
| 4444 | 2361 | 1 | 2016-06-10 16:48:31 |
| 4445 | 2362 | 1 | 2016-06-10 16:57:41 |
| 4446 | 2362 | 2 | 2016-06-10 17:41:17 |
| 4447 | 2325 | 1 | 2016-06-11 13:26:54 |
| 4448 | 2324 | 1 | 2016-06-11 13:30:51 |
| 4449 | 2326 | 3 | 2016-06-11 13:32:32 |
| 4450 | 2326 | 2 | 2016-06-11 14:24:01 |
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;