Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,576–4,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4576 | 2350 | 1 | 2016-06-24 12:48:57 |
| 4577 | 2347 | 1 | 2016-06-24 13:02:26 |
| 4578 | 2346 | 2 | 2016-06-24 13:07:56 |
| 4579 | 2348 | 2 | 2016-06-24 13:17:33 |
| 4580 | 2405 | 2 | 2016-06-24 13:25:03 |
| 4581 | 2350 | 2 | 2016-06-24 13:39:09 |
| 4582 | 2349 | 2 | 2016-06-24 13:41:06 |
| 4583 | 2408 | 2 | 2016-06-24 13:55:00 |
| 4584 | 2407 | 2 | 2016-06-24 13:58:06 |
| 4585 | 2347 | 2 | 2016-06-24 14:02:15 |
| 4586 | 2409 | 1 | 2016-06-25 13:57:54 |
| 4587 | 2410 | 2 | 2016-06-25 14:20:20 |
| 4588 | 2410 | 3 | 2016-06-25 15:01:13 |
| 4589 | 2409 | 2 | 2016-06-25 15:15:07 |
| 4590 | 2415 | 1 | 2016-06-26 12:10:33 |
| 4591 | 2416 | 1 | 2016-06-26 12:12:14 |
| 4592 | 2417 | 1 | 2016-06-26 12:13:03 |
| 4593 | 2418 | 1 | 2016-06-26 12:19:24 |
| 4594 | 2419 | 1 | 2016-06-26 12:23:52 |
| 4595 | 2411 | 2 | 2016-06-27 12:12:28 |
| 4596 | 2414 | 2 | 2016-06-27 12:13:06 |
| 4597 | 2412 | 2 | 2016-06-27 12:16:45 |
| 4598 | 2413 | 2 | 2016-06-27 12:21:52 |
| 4599 | 2413 | 1 | 2016-06-27 12:56:29 |
| 4600 | 2411 | 1 | 2016-06-27 13:11:15 |
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;