Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,926–12,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12926 | 6365 | 2 | 2018-08-31 12:09:38 |
| 12927 | 6361 | 2 | 2018-08-31 12:11:00 |
| 12928 | 6369 | 2 | 2018-08-31 12:11:33 |
| 12929 | 6382 | 2 | 2018-08-31 12:12:41 |
| 12930 | 6366 | 2 | 2018-08-31 12:13:07 |
| 12931 | 6362 | 2 | 2018-08-31 12:14:06 |
| 12932 | 6576 | 2 | 2018-08-31 12:14:20 |
| 12933 | 6578 | 2 | 2018-08-31 12:14:44 |
| 12934 | 6370 | 2 | 2018-08-31 12:19:40 |
| 12935 | 6577 | 2 | 2018-08-31 12:21:04 |
| 12936 | 6579 | 2 | 2018-08-31 12:24:58 |
| 12937 | 6360 | 2 | 2018-08-31 12:26:25 |
| 12938 | 6388 | 2 | 2018-08-31 12:28:36 |
| 12939 | 6363 | 2 | 2018-08-31 12:28:41 |
| 12940 | 6364 | 2 | 2018-08-31 12:29:03 |
| 12941 | 6386 | 2 | 2018-08-31 12:29:15 |
| 12942 | 6389 | 2 | 2018-08-31 12:30:26 |
| 12943 | 6358 | 2 | 2018-08-31 12:39:42 |
| 12944 | 6380 | 2 | 2018-08-31 12:39:53 |
| 12945 | 6359 | 2 | 2018-08-31 12:44:13 |
| 12946 | 6368 | 2 | 2018-08-31 12:51:41 |
| 12947 | 6367 | 2 | 2018-08-31 12:57:45 |
| 12948 | 6387 | 2 | 2018-08-31 12:58:12 |
| 12949 | 6579 | 3 | 2018-08-31 13:17:20 |
| 12950 | 6578 | 1 | 2018-08-31 13:17:29 |
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;