Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,551–8,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8551 | 4465 | 2 | 2017-08-21 17:23:18 |
| 8552 | 4390 | 1 | 2017-08-22 09:32:03 |
| 8553 | 4390 | 2 | 2017-08-22 10:05:48 |
| 8554 | 4469 | 2 | 2017-08-22 12:00:30 |
| 8555 | 4475 | 2 | 2017-08-22 12:01:10 |
| 8556 | 4472 | 2 | 2017-08-22 12:05:30 |
| 8557 | 4473 | 2 | 2017-08-22 12:07:23 |
| 8558 | 4471 | 2 | 2017-08-22 12:14:40 |
| 8559 | 4474 | 2 | 2017-08-22 12:15:12 |
| 8560 | 4473 | 3 | 2017-08-22 12:45:00 |
| 8561 | 4472 | 3 | 2017-08-22 12:52:22 |
| 8562 | 4474 | 3 | 2017-08-22 13:02:32 |
| 8563 | 4477 | 1 | 2017-08-22 13:03:20 |
| 8564 | 4476 | 1 | 2017-08-22 13:07:45 |
| 8565 | 4471 | 3 | 2017-08-22 13:14:09 |
| 8566 | 4475 | 3 | 2017-08-22 13:24:04 |
| 8567 | 4408 | 2 | 2017-08-22 13:46:53 |
| 8568 | 4473 | 1 | 2017-08-22 13:49:47 |
| 8569 | 4474 | 1 | 2017-08-22 13:51:06 |
| 8570 | 4472 | 1 | 2017-08-22 13:54:55 |
| 8571 | 4476 | 3 | 2017-08-22 13:55:29 |
| 8572 | 4475 | 1 | 2017-08-22 14:09:46 |
| 8573 | 4477 | 3 | 2017-08-22 14:25:31 |
| 8574 | 4471 | 1 | 2017-08-22 14:39:30 |
| 8575 | 4478 | 3 | 2017-08-22 16:10:29 |
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;