Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,626–16,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16626 | 8327 | 1 | 2019-06-29 11:42:28 |
| 16627 | 8328 | 3 | 2019-06-29 11:55:47 |
| 16628 | 8410 | 2 | 2019-06-29 12:03:51 |
| 16629 | 8420 | 2 | 2019-06-30 10:17:22 |
| 16630 | 8383 | 2 | 2019-06-30 12:16:45 |
| 16631 | 8379 | 2 | 2019-06-30 12:23:28 |
| 16632 | 8382 | 2 | 2019-06-30 12:24:04 |
| 16633 | 8381 | 2 | 2019-06-30 12:26:00 |
| 16634 | 8407 | 2 | 2019-07-01 13:50:09 |
| 16635 | 8408 | 2 | 2019-07-01 14:01:32 |
| 16636 | 8407 | 1 | 2019-07-01 14:31:30 |
| 16637 | 8408 | 1 | 2019-07-01 15:33:46 |
| 16638 | 8453 | 2 | 2019-07-02 10:07:02 |
| 16639 | 8453 | 1 | 2019-07-02 10:32:53 |
| 16640 | 8411 | 2 | 2019-07-02 15:08:19 |
| 16641 | 8394 | 2 | 2019-07-03 10:52:09 |
| 16642 | 8395 | 2 | 2019-07-03 10:57:57 |
| 16643 | 8393 | 2 | 2019-07-03 11:01:34 |
| 16644 | 8392 | 2 | 2019-07-03 11:03:57 |
| 16645 | 8391 | 2 | 2019-07-03 11:05:42 |
| 16646 | 8393 | 3 | 2019-07-03 11:40:20 |
| 16647 | 8391 | 3 | 2019-07-03 12:10:02 |
| 16648 | 8394 | 3 | 2019-07-03 12:12:10 |
| 16649 | 8395 | 3 | 2019-07-03 12:14:58 |
| 16650 | 8393 | 2 | 2019-07-03 13:11:29 |
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;