Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,276–6,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6276 | 3313 | 2 | 2016-12-27 11:07:51 |
| 6277 | 3311 | 1 | 2016-12-27 11:23:19 |
| 6278 | 3313 | 1 | 2016-12-27 11:46:14 |
| 6279 | 3078 | 1 | 2016-12-27 11:51:09 |
| 6280 | 3311 | 2 | 2016-12-27 11:54:16 |
| 6281 | 3314 | 1 | 2016-12-27 12:35:25 |
| 6282 | 3315 | 2 | 2016-12-27 12:41:22 |
| 6283 | 3316 | 2 | 2016-12-27 12:51:03 |
| 6284 | 3314 | 2 | 2016-12-27 13:04:25 |
| 6285 | 3315 | 3 | 2016-12-27 13:07:03 |
| 6286 | 3316 | 3 | 2016-12-27 14:16:39 |
| 6287 | 3315 | 1 | 2016-12-27 14:33:53 |
| 6288 | 3316 | 1 | 2016-12-27 15:03:22 |
| 6289 | 3319 | 1 | 2016-12-28 09:29:43 |
| 6290 | 3319 | 3 | 2016-12-28 10:44:40 |
| 6291 | 3302 | 1 | 2016-12-28 11:11:31 |
| 6292 | 3319 | 2 | 2016-12-28 12:14:33 |
| 6293 | 3319 | 3 | 2016-12-28 13:41:50 |
| 6294 | 3015 | 2 | 2016-12-28 14:39:58 |
| 6295 | 3016 | 2 | 2016-12-28 14:46:53 |
| 6296 | 3015 | 1 | 2016-12-28 15:56:36 |
| 6297 | 3016 | 1 | 2016-12-28 16:15:52 |
| 6298 | 3015 | 3 | 2016-12-28 16:29:19 |
| 6299 | 3016 | 3 | 2016-12-28 16:43:29 |
| 6300 | 3322 | 1 | 2016-12-29 10:20:54 |
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;