Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,326–8,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8326 | 4312 | 2 | 2017-07-28 11:50:07 |
| 8327 | 4311 | 2 | 2017-07-28 11:51:52 |
| 8328 | 4306 | 1 | 2017-07-28 12:00:32 |
| 8329 | 4311 | 1 | 2017-07-28 12:48:50 |
| 8330 | 4312 | 1 | 2017-07-28 13:21:22 |
| 8331 | 4306 | 2 | 2017-07-28 13:27:43 |
| 8332 | 4310 | 3 | 2017-07-28 13:30:43 |
| 8333 | 4311 | 2 | 2017-07-28 13:48:24 |
| 8334 | 4312 | 2 | 2017-07-28 14:03:50 |
| 8335 | 4313 | 1 | 2017-07-28 14:06:50 |
| 8336 | 4310 | 2 | 2017-07-28 14:11:14 |
| 8337 | 4311 | 3 | 2017-07-28 14:19:56 |
| 8338 | 4313 | 3 | 2017-07-28 14:55:55 |
| 8339 | 4312 | 3 | 2017-07-28 15:11:55 |
| 8340 | 4309 | 2 | 2017-07-28 15:58:22 |
| 8341 | 4305 | 3 | 2017-07-29 10:32:18 |
| 8342 | 4305 | 2 | 2017-07-29 11:01:17 |
| 8343 | 4301 | 2 | 2017-07-30 10:30:08 |
| 8344 | 4302 | 2 | 2017-07-30 10:39:52 |
| 8345 | 4302 | 3 | 2017-07-30 11:44:02 |
| 8346 | 4301 | 3 | 2017-07-30 11:57:09 |
| 8347 | 4316 | 2 | 2017-07-30 12:19:08 |
| 8348 | 4302 | 2 | 2017-07-30 12:44:40 |
| 8349 | 4301 | 2 | 2017-07-30 13:18:36 |
| 8350 | 4316 | 3 | 2017-07-30 13:44:35 |
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;