Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,601–11,625 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11601 | 6104 | 1 | 2018-06-29 10:10:27 |
| 11602 | 6105 | 2 | 2018-06-29 10:18:53 |
| 11603 | 6097 | 3 | 2018-06-29 10:49:16 |
| 11604 | 6098 | 3 | 2018-06-29 11:00:39 |
| 11605 | 6097 | 1 | 2018-06-29 11:29:04 |
| 11606 | 6106 | 3 | 2018-06-29 12:02:59 |
| 11607 | 6107 | 3 | 2018-06-29 12:11:13 |
| 11608 | 6098 | 1 | 2018-06-29 12:18:58 |
| 11609 | 6106 | 1 | 2018-06-29 12:50:13 |
| 11610 | 6098 | 2 | 2018-06-29 12:53:40 |
| 11611 | 6097 | 2 | 2018-06-29 13:01:36 |
| 11612 | 6107 | 1 | 2018-06-29 13:39:03 |
| 11613 | 6115 | 2 | 2018-06-30 10:08:41 |
| 11614 | 6114 | 2 | 2018-06-30 10:09:11 |
| 11615 | 6114 | 3 | 2018-06-30 10:51:24 |
| 11616 | 6117 | 2 | 2018-06-30 11:18:20 |
| 11617 | 6116 | 2 | 2018-06-30 11:19:43 |
| 11618 | 6118 | 2 | 2018-06-30 11:21:32 |
| 11619 | 6119 | 2 | 2018-06-30 11:22:52 |
| 11620 | 6115 | 3 | 2018-06-30 11:35:55 |
| 11621 | 6119 | 3 | 2018-06-30 12:20:35 |
| 11622 | 6117 | 3 | 2018-06-30 12:25:26 |
| 11623 | 6116 | 3 | 2018-06-30 12:33:42 |
| 11624 | 6118 | 3 | 2018-06-30 12:39:23 |
| 11625 | 6116 | 2 | 2018-06-30 13:13:06 |
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;