Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,276–3,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3276 | 1662 | 3 | 2016-01-12 12:49:00 |
| 3277 | 1664 | 3 | 2016-01-12 12:57:25 |
| 3278 | 1663 | 3 | 2016-01-12 13:06:30 |
| 3279 | 1662 | 1 | 2016-01-12 13:31:48 |
| 3280 | 1664 | 1 | 2016-01-12 13:34:03 |
| 3281 | 1660 | 1 | 2016-01-12 13:34:41 |
| 3282 | 1661 | 1 | 2016-01-12 13:59:51 |
| 3283 | 1663 | 1 | 2016-01-12 14:17:43 |
| 3284 | 1662 | 2 | 2016-01-12 14:20:33 |
| 3285 | 1660 | 2 | 2016-01-12 14:28:36 |
| 3286 | 1664 | 2 | 2016-01-12 15:01:29 |
| 3287 | 1661 | 2 | 2016-01-12 15:09:25 |
| 3288 | 1663 | 2 | 2016-01-12 15:33:46 |
| 3289 | 1665 | 2 | 2016-01-13 16:19:58 |
| 3290 | 1666 | 2 | 2016-01-13 16:23:00 |
| 3291 | 1665 | 1 | 2016-01-13 17:20:02 |
| 3292 | 1666 | 1 | 2016-01-13 17:27:48 |
| 3293 | 1608 | 2 | 2016-01-15 15:08:14 |
| 3294 | 1609 | 2 | 2016-01-15 15:16:04 |
| 3295 | 1609 | 1 | 2016-01-15 15:44:41 |
| 3296 | 1609 | 2 | 2016-01-15 16:12:28 |
| 3297 | 1608 | 1 | 2016-01-15 16:36:01 |
| 3298 | 1608 | 2 | 2016-01-15 17:13:08 |
| 3299 | 1737 | 2 | 2016-01-16 13:35:25 |
| 3300 | 1742 | 2 | 2016-01-18 09:24:16 |
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;