Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,426–13,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13426 | 6854 | 1 | 2018-10-11 13:42:04 |
| 13427 | 6869 | 1 | 2018-10-11 13:47:51 |
| 13428 | 6854 | 3 | 2018-10-11 14:12:51 |
| 13429 | 6872 | 2 | 2018-10-12 09:52:19 |
| 13430 | 6872 | 1 | 2018-10-12 10:34:06 |
| 13431 | 6856 | 2 | 2018-10-13 12:19:26 |
| 13432 | 6857 | 3 | 2018-10-13 12:24:53 |
| 13433 | 6874 | 2 | 2018-10-13 12:35:30 |
| 13434 | 6873 | 2 | 2018-10-13 12:35:56 |
| 13435 | 6876 | 1 | 2018-10-13 12:42:12 |
| 13436 | 6875 | 2 | 2018-10-13 12:43:44 |
| 13437 | 6877 | 2 | 2018-10-13 12:44:35 |
| 13438 | 6856 | 3 | 2018-10-13 13:49:12 |
| 13439 | 6831 | 2 | 2018-10-13 14:00:47 |
| 13440 | 6880 | 2 | 2018-10-13 14:09:50 |
| 13441 | 6881 | 2 | 2018-10-13 14:12:04 |
| 13442 | 6831 | 3 | 2018-10-13 14:39:33 |
| 13443 | 6856 | 2 | 2018-10-13 14:41:30 |
| 13444 | 6880 | 1 | 2018-10-13 15:31:04 |
| 13445 | 6881 | 1 | 2018-10-13 15:45:00 |
| 13446 | 6856 | 1 | 2018-10-13 15:46:22 |
| 13447 | 6880 | 3 | 2018-10-13 16:54:41 |
| 13448 | 6881 | 3 | 2018-10-13 17:09:33 |
| 13449 | 6842 | 1 | 2018-10-14 10:03:16 |
| 13450 | 6841 | 1 | 2018-10-14 10:04:14 |
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;