Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,351–3,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3351 | 1671 | 1 | 2016-01-24 14:03:15 |
| 3352 | 1669 | 1 | 2016-01-24 14:05:42 |
| 3353 | 1670 | 1 | 2016-01-24 14:07:56 |
| 3354 | 1668 | 3 | 2016-01-24 14:11:00 |
| 3355 | 1667 | 2 | 2016-01-24 14:17:17 |
| 3356 | 1667 | 3 | 2016-01-24 15:02:10 |
| 3357 | 1671 | 2 | 2016-01-24 15:08:49 |
| 3358 | 1670 | 2 | 2016-01-24 15:15:23 |
| 3359 | 1669 | 2 | 2016-01-24 15:21:28 |
| 3360 | 1668 | 1 | 2016-01-24 15:25:16 |
| 3361 | 1670 | 3 | 2016-01-24 15:54:08 |
| 3362 | 1669 | 3 | 2016-01-24 16:00:08 |
| 3363 | 1667 | 1 | 2016-01-24 16:08:20 |
| 3364 | 1671 | 3 | 2016-01-24 16:19:51 |
| 3365 | 1670 | 2 | 2016-01-24 16:26:10 |
| 3366 | 1667 | 3 | 2016-01-24 16:53:14 |
| 3367 | 1668 | 3 | 2016-01-24 16:56:16 |
| 3368 | 1669 | 2 | 2016-01-24 17:14:52 |
| 3369 | 1671 | 2 | 2016-01-24 17:38:30 |
| 3370 | 1749 | 2 | 2016-01-25 15:36:48 |
| 3371 | 1763 | 2 | 2016-01-26 10:54:02 |
| 3372 | 1764 | 2 | 2016-01-26 10:58:03 |
| 3373 | 1763 | 1 | 2016-01-26 11:23:59 |
| 3374 | 1764 | 1 | 2016-01-26 11:34:21 |
| 3375 | 1769 | 3 | 2016-01-30 12:55:44 |
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;