Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,701–13,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13701 | 7026 | 2 | 2018-11-06 13:21:33 |
| 13702 | 7025 | 1 | 2018-11-06 13:23:54 |
| 13703 | 7025 | 2 | 2018-11-06 14:21:08 |
| 13704 | 7026 | 3 | 2018-11-06 14:35:27 |
| 13705 | 7024 | 2 | 2018-11-06 14:36:34 |
| 13706 | 6946 | 1 | 2018-11-08 14:09:54 |
| 13707 | 6945 | 1 | 2018-11-08 14:19:20 |
| 13708 | 6944 | 1 | 2018-11-08 14:19:41 |
| 13709 | 6946 | 2 | 2018-11-08 14:40:23 |
| 13710 | 6944 | 2 | 2018-11-08 15:19:07 |
| 13711 | 6945 | 2 | 2018-11-08 15:52:17 |
| 13712 | 6947 | 2 | 2018-11-09 09:35:14 |
| 13713 | 7027 | 2 | 2018-11-09 10:33:21 |
| 13714 | 7028 | 2 | 2018-11-09 10:42:20 |
| 13715 | 7029 | 2 | 2018-11-09 10:43:28 |
| 13716 | 7029 | 1 | 2018-11-09 11:11:18 |
| 13717 | 7037 | 3 | 2018-11-10 10:37:56 |
| 13718 | 7036 | 2 | 2018-11-10 11:48:12 |
| 13719 | 7036 | 3 | 2018-11-10 13:21:36 |
| 13720 | 7036 | 2 | 2018-11-10 14:39:45 |
| 13721 | 7035 | 1 | 2018-11-10 16:00:26 |
| 13722 | 7034 | 1 | 2018-11-10 16:13:17 |
| 13723 | 7034 | 3 | 2018-11-10 17:00:20 |
| 13724 | 7035 | 3 | 2018-11-10 17:16:42 |
| 13725 | 7039 | 3 | 2018-11-11 09:26:32 |
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;