Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,926–4,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4926 | 2481 | 3 | 2016-07-15 17:17:59 |
| 4927 | 2480 | 3 | 2016-07-15 17:38:17 |
| 4928 | 2500 | 1 | 2016-07-16 09:19:56 |
| 4929 | 2497 | 2 | 2016-07-16 09:25:32 |
| 4930 | 2499 | 1 | 2016-07-16 09:30:21 |
| 4931 | 2501 | 2 | 2016-07-16 09:33:03 |
| 4932 | 2498 | 1 | 2016-07-16 09:34:07 |
| 4933 | 2501 | 3 | 2016-07-16 10:01:48 |
| 4934 | 2492 | 2 | 2016-07-16 10:29:18 |
| 4935 | 2490 | 2 | 2016-07-16 10:39:02 |
| 4936 | 2501 | 2 | 2016-07-16 11:13:43 |
| 4937 | 2507 | 3 | 2016-07-16 14:17:55 |
| 4938 | 2506 | 3 | 2016-07-16 14:19:20 |
| 4939 | 2508 | 3 | 2016-07-16 14:23:09 |
| 4940 | 2504 | 3 | 2016-07-16 14:24:43 |
| 4941 | 2505 | 1 | 2016-07-16 14:28:55 |
| 4942 | 2503 | 2 | 2016-07-16 14:47:39 |
| 4943 | 2502 | 2 | 2016-07-16 14:48:52 |
| 4944 | 2505 | 2 | 2016-07-16 15:01:21 |
| 4945 | 2507 | 1 | 2016-07-16 15:14:05 |
| 4946 | 2502 | 3 | 2016-07-16 15:20:54 |
| 4947 | 2503 | 3 | 2016-07-16 15:29:16 |
| 4948 | 2502 | 2 | 2016-07-16 16:03:51 |
| 4949 | 2503 | 2 | 2016-07-16 16:28:29 |
| 4950 | 2483 | 1 | 2016-07-17 10:05:36 |
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;