Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,651–16,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16651 | 8391 | 2 | 2019-07-03 13:31:52 |
| 16652 | 8395 | 2 | 2019-07-03 13:35:17 |
| 16653 | 8394 | 2 | 2019-07-03 13:38:10 |
| 16654 | 8393 | 3 | 2019-07-03 14:10:31 |
| 16655 | 8394 | 3 | 2019-07-03 14:15:28 |
| 16656 | 8391 | 3 | 2019-07-03 14:47:32 |
| 16657 | 8395 | 3 | 2019-07-03 15:00:23 |
| 16658 | 8460 | 2 | 2019-07-04 12:46:40 |
| 16659 | 8461 | 2 | 2019-07-04 12:54:16 |
| 16660 | 8461 | 3 | 2019-07-04 14:07:25 |
| 16661 | 8460 | 3 | 2019-07-04 14:20:22 |
| 16662 | 8462 | 1 | 2019-07-05 11:47:53 |
| 16663 | 8462 | 3 | 2019-07-05 12:42:05 |
| 16664 | 8451 | 3 | 2019-07-06 11:31:48 |
| 16665 | 8452 | 3 | 2019-07-06 11:42:33 |
| 16666 | 8451 | 1 | 2019-07-06 11:57:19 |
| 16667 | 8452 | 1 | 2019-07-06 12:47:24 |
| 16668 | 8498 | 3 | 2019-07-06 14:00:32 |
| 16669 | 8499 | 3 | 2019-07-06 14:02:08 |
| 16670 | 8497 | 3 | 2019-07-06 14:08:25 |
| 16671 | 8501 | 2 | 2019-07-06 14:08:29 |
| 16672 | 8500 | 2 | 2019-07-06 14:11:49 |
| 16673 | 8499 | 2 | 2019-07-06 14:35:25 |
| 16674 | 8498 | 2 | 2019-07-06 14:37:49 |
| 16675 | 8500 | 1 | 2019-07-06 14:39:15 |
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;