Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,401–10,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10401 | 5365 | 3 | 2018-03-13 12:45:25 |
| 10402 | 5366 | 3 | 2018-03-13 12:46:22 |
| 10403 | 5367 | 3 | 2018-03-13 13:18:33 |
| 10404 | 5364 | 2 | 2018-03-14 13:58:25 |
| 10405 | 5363 | 1 | 2018-03-14 14:06:42 |
| 10406 | 5363 | 2 | 2018-03-14 15:23:16 |
| 10407 | 5364 | 3 | 2018-03-14 15:27:16 |
| 10408 | 5363 | 3 | 2018-03-14 16:07:36 |
| 10409 | 5364 | 1 | 2018-03-14 16:54:08 |
| 10410 | 5364 | 2 | 2018-03-14 17:30:44 |
| 10411 | 5374 | 1 | 2018-03-15 11:58:11 |
| 10412 | 5373 | 2 | 2018-03-15 12:08:16 |
| 10413 | 5374 | 3 | 2018-03-15 13:00:19 |
| 10414 | 5376 | 2 | 2018-03-15 13:58:10 |
| 10415 | 5375 | 2 | 2018-03-15 14:00:19 |
| 10416 | 5302 | 2 | 2018-03-15 15:33:55 |
| 10417 | 5302 | 3 | 2018-03-15 16:21:31 |
| 10418 | 5427 | 2 | 2018-03-16 12:32:22 |
| 10419 | 5427 | 3 | 2018-03-16 13:50:43 |
| 10420 | 5428 | 2 | 2018-03-16 14:28:18 |
| 10421 | 5427 | 2 | 2018-03-16 15:15:38 |
| 10422 | 5341 | 2 | 2018-03-17 09:39:11 |
| 10423 | 5343 | 2 | 2018-03-17 09:40:26 |
| 10424 | 5340 | 2 | 2018-03-17 09:40:43 |
| 10425 | 5342 | 2 | 2018-03-17 09:41:56 |
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;