Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,901–6,925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6901 | 3272 | 3 | 2017-03-15 11:47:24 |
| 6902 | 3297 | 3 | 2017-03-15 11:47:50 |
| 6903 | 3282 | 3 | 2017-03-15 11:48:34 |
| 6904 | 3301 | 3 | 2017-03-15 11:48:40 |
| 6905 | 3277 | 3 | 2017-03-15 11:51:16 |
| 6906 | 3291 | 3 | 2017-03-15 11:51:24 |
| 6907 | 3292 | 3 | 2017-03-15 11:51:35 |
| 6908 | 3298 | 3 | 2017-03-15 11:52:39 |
| 6909 | 3283 | 3 | 2017-03-15 11:52:41 |
| 6910 | 3265 | 2 | 2017-03-15 12:03:54 |
| 6911 | 3285 | 2 | 2017-03-15 12:04:19 |
| 6912 | 3254 | 2 | 2017-03-15 12:09:17 |
| 6913 | 3284 | 2 | 2017-03-15 12:10:23 |
| 6914 | 3256 | 2 | 2017-03-15 12:12:10 |
| 6915 | 3299 | 2 | 2017-03-15 12:14:16 |
| 6916 | 3301 | 2 | 2017-03-15 12:14:49 |
| 6917 | 3282 | 2 | 2017-03-15 12:14:54 |
| 6918 | 3272 | 2 | 2017-03-15 12:15:59 |
| 6919 | 3274 | 2 | 2017-03-15 12:18:09 |
| 6920 | 3268 | 2 | 2017-03-15 12:19:42 |
| 6921 | 3263 | 2 | 2017-03-15 12:20:47 |
| 6922 | 3276 | 2 | 2017-03-15 12:21:49 |
| 6923 | 3271 | 2 | 2017-03-15 12:22:19 |
| 6924 | 3258 | 2 | 2017-03-15 12:23:25 |
| 6925 | 3292 | 2 | 2017-03-15 12:23:44 |
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;