Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,526–4,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4526 | 2226 | 3 | 2016-06-22 09:51:40 |
| 4527 | 2222 | 3 | 2016-06-22 09:52:05 |
| 4528 | 2228 | 3 | 2016-06-22 09:52:17 |
| 4529 | 2210 | 3 | 2016-06-22 09:53:44 |
| 4530 | 2239 | 3 | 2016-06-22 09:54:28 |
| 4531 | 2233 | 3 | 2016-06-22 09:57:52 |
| 4532 | 2232 | 3 | 2016-06-22 09:59:55 |
| 4533 | 2235 | 3 | 2016-06-22 10:00:07 |
| 4534 | 2234 | 3 | 2016-06-22 10:01:48 |
| 4535 | 2209 | 2 | 2016-06-22 10:20:31 |
| 4536 | 2240 | 2 | 2016-06-22 10:21:19 |
| 4537 | 2227 | 2 | 2016-06-22 10:23:27 |
| 4538 | 2212 | 2 | 2016-06-22 10:27:11 |
| 4539 | 2228 | 2 | 2016-06-22 10:27:20 |
| 4540 | 2232 | 2 | 2016-06-22 10:27:56 |
| 4541 | 2223 | 2 | 2016-06-22 10:28:03 |
| 4542 | 2234 | 2 | 2016-06-22 10:38:56 |
| 4543 | 2236 | 2 | 2016-06-22 10:40:53 |
| 4544 | 2214 | 2 | 2016-06-22 10:42:26 |
| 4545 | 2213 | 2 | 2016-06-22 10:48:04 |
| 4546 | 2217 | 2 | 2016-06-22 10:50:21 |
| 4547 | 2226 | 2 | 2016-06-22 11:01:03 |
| 4548 | 2238 | 2 | 2016-06-22 11:05:08 |
| 4549 | 2233 | 2 | 2016-06-22 11:05:39 |
| 4550 | 2239 | 2 | 2016-06-22 11:12:43 |
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;