Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,326–9,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9326 | 4442 | 2 | 2017-11-06 13:50:52 |
| 9327 | 4427 | 2 | 2017-11-06 13:51:04 |
| 9328 | 4439 | 2 | 2017-11-06 13:51:35 |
| 9329 | 4424 | 2 | 2017-11-06 13:51:54 |
| 9330 | 4429 | 2 | 2017-11-06 13:52:07 |
| 9331 | 4455 | 2 | 2017-11-06 13:52:35 |
| 9332 | 4446 | 2 | 2017-11-06 13:53:37 |
| 9333 | 4436 | 2 | 2017-11-06 13:53:52 |
| 9334 | 4426 | 2 | 2017-11-06 13:54:34 |
| 9335 | 4459 | 2 | 2017-11-06 13:55:12 |
| 9336 | 4461 | 2 | 2017-11-06 13:55:36 |
| 9337 | 4430 | 2 | 2017-11-06 13:55:39 |
| 9338 | 4840 | 3 | 2017-11-06 13:56:13 |
| 9339 | 4458 | 2 | 2017-11-06 13:57:00 |
| 9340 | 4457 | 2 | 2017-11-06 13:57:24 |
| 9341 | 4447 | 2 | 2017-11-06 13:57:58 |
| 9342 | 4443 | 2 | 2017-11-06 13:58:03 |
| 9343 | 4432 | 2 | 2017-11-06 13:58:35 |
| 9344 | 4438 | 2 | 2017-11-06 13:58:57 |
| 9345 | 4435 | 2 | 2017-11-06 13:59:05 |
| 9346 | 4444 | 2 | 2017-11-06 13:59:14 |
| 9347 | 4431 | 2 | 2017-11-06 14:00:06 |
| 9348 | 4433 | 2 | 2017-11-06 14:00:24 |
| 9349 | 4839 | 3 | 2017-11-06 14:00:27 |
| 9350 | 4451 | 2 | 2017-11-06 14:01:42 |
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;