Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,276–13,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13276 | 6548 | 2 | 2018-10-05 12:05:55 |
| 13277 | 6524 | 2 | 2018-10-05 12:06:02 |
| 13278 | 6532 | 2 | 2018-10-05 12:06:29 |
| 13279 | 6520 | 2 | 2018-10-05 12:07:32 |
| 13280 | 6526 | 2 | 2018-10-05 12:08:18 |
| 13281 | 6533 | 2 | 2018-10-05 12:08:30 |
| 13282 | 6535 | 2 | 2018-10-05 12:08:41 |
| 13283 | 6536 | 2 | 2018-10-05 12:08:56 |
| 13284 | 6551 | 2 | 2018-10-05 12:09:39 |
| 13285 | 6550 | 2 | 2018-10-05 12:10:20 |
| 13286 | 6543 | 2 | 2018-10-05 12:10:26 |
| 13287 | 6542 | 2 | 2018-10-05 12:11:27 |
| 13288 | 6540 | 2 | 2018-10-05 12:12:18 |
| 13289 | 6553 | 2 | 2018-10-05 12:14:33 |
| 13290 | 6521 | 3 | 2018-10-05 12:25:14 |
| 13291 | 6522 | 3 | 2018-10-05 12:26:23 |
| 13292 | 6529 | 3 | 2018-10-05 12:28:36 |
| 13293 | 6519 | 3 | 2018-10-05 12:30:16 |
| 13294 | 6538 | 3 | 2018-10-05 12:33:31 |
| 13295 | 6526 | 3 | 2018-10-05 12:34:13 |
| 13296 | 6518 | 3 | 2018-10-05 12:34:44 |
| 13297 | 6535 | 3 | 2018-10-05 12:37:41 |
| 13298 | 6520 | 3 | 2018-10-05 12:44:49 |
| 13299 | 6551 | 3 | 2018-10-05 12:45:37 |
| 13300 | 6534 | 3 | 2018-10-05 12:49:52 |
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;