Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,876–4,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4876 | 2466 | 2 | 2016-07-11 14:42:49 |
| 4877 | 2424 | 3 | 2016-07-12 09:10:49 |
| 4878 | 2424 | 2 | 2016-07-12 10:17:21 |
| 4879 | 2424 | 1 | 2016-07-12 11:08:10 |
| 4880 | 2475 | 2 | 2016-07-12 12:10:56 |
| 4881 | 2427 | 2 | 2016-07-12 12:14:23 |
| 4882 | 2474 | 3 | 2016-07-12 12:14:31 |
| 4883 | 2428 | 2 | 2016-07-12 12:21:34 |
| 4884 | 2425 | 2 | 2016-07-12 12:21:48 |
| 4885 | 2426 | 2 | 2016-07-12 12:22:35 |
| 4886 | 2474 | 1 | 2016-07-12 12:58:52 |
| 4887 | 2474 | 2 | 2016-07-12 13:38:08 |
| 4888 | 2473 | 3 | 2016-07-12 14:09:31 |
| 4889 | 2474 | 1 | 2016-07-12 14:15:33 |
| 4890 | 2485 | 1 | 2016-07-14 10:21:58 |
| 4891 | 2484 | 2 | 2016-07-14 10:33:18 |
| 4892 | 2484 | 3 | 2016-07-14 11:04:35 |
| 4893 | 2486 | 2 | 2016-07-14 16:18:11 |
| 4894 | 2488 | 3 | 2016-07-14 16:19:07 |
| 4895 | 2487 | 2 | 2016-07-14 16:30:58 |
| 4896 | 2488 | 1 | 2016-07-14 17:03:25 |
| 4897 | 2486 | 3 | 2016-07-14 17:09:06 |
| 4898 | 2487 | 3 | 2016-07-14 17:29:48 |
| 4899 | 2489 | 1 | 2016-07-15 09:51:25 |
| 4900 | 2496 | 1 | 2016-07-15 10:08:17 |
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;