Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,551–4,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4551 | 2210 | 2 | 2016-06-22 11:16:27 |
| 4552 | 2222 | 2 | 2016-06-22 11:17:03 |
| 4553 | 2235 | 2 | 2016-06-22 11:25:20 |
| 4554 | 2332 | 1 | 2016-06-23 09:35:26 |
| 4555 | 2331 | 1 | 2016-06-23 09:36:33 |
| 4556 | 2333 | 1 | 2016-06-23 09:38:41 |
| 4557 | 2330 | 1 | 2016-06-23 09:45:43 |
| 4558 | 2333 | 2 | 2016-06-23 10:19:23 |
| 4559 | 2333 | 3 | 2016-06-23 11:44:22 |
| 4560 | 2398 | 2 | 2016-06-23 13:40:38 |
| 4561 | 2399 | 2 | 2016-06-23 13:54:14 |
| 4562 | 2400 | 2 | 2016-06-23 13:55:23 |
| 4563 | 2376 | 3 | 2016-06-24 09:12:15 |
| 4564 | 2375 | 2 | 2016-06-24 09:21:42 |
| 4565 | 2406 | 3 | 2016-06-24 10:21:21 |
| 4566 | 2375 | 3 | 2016-06-24 10:29:31 |
| 4567 | 2375 | 1 | 2016-06-24 11:22:10 |
| 4568 | 2348 | 2 | 2016-06-24 11:38:57 |
| 4569 | 2350 | 2 | 2016-06-24 11:42:56 |
| 4570 | 2347 | 2 | 2016-06-24 11:43:13 |
| 4571 | 2346 | 2 | 2016-06-24 11:48:32 |
| 4572 | 2349 | 2 | 2016-06-24 11:49:13 |
| 4573 | 2349 | 1 | 2016-06-24 12:16:35 |
| 4574 | 2346 | 1 | 2016-06-24 12:23:30 |
| 4575 | 2348 | 1 | 2016-06-24 12:39:45 |
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;