Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,401–12,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12401 | 6422 | 3 | 2018-08-13 13:25:52 |
| 12402 | 6419 | 3 | 2018-08-13 13:28:40 |
| 12403 | 6421 | 3 | 2018-08-13 13:46:19 |
| 12404 | 6464 | 2 | 2018-08-13 14:23:22 |
| 12405 | 6420 | 3 | 2018-08-13 14:36:40 |
| 12406 | 6465 | 2 | 2018-08-13 14:48:45 |
| 12407 | 6468 | 2 | 2018-08-14 11:25:19 |
| 12408 | 6467 | 3 | 2018-08-14 11:35:12 |
| 12409 | 6262 | 2 | 2018-08-14 12:47:40 |
| 12410 | 6468 | 1 | 2018-08-14 12:49:31 |
| 12411 | 6337 | 2 | 2018-08-14 14:30:19 |
| 12412 | 6337 | 3 | 2018-08-14 14:57:19 |
| 12413 | 6451 | 1 | 2018-08-15 16:31:16 |
| 12414 | 6452 | 1 | 2018-08-15 16:33:37 |
| 12415 | 6452 | 2 | 2018-08-15 17:13:15 |
| 12416 | 6451 | 2 | 2018-08-15 17:20:40 |
| 12417 | 6475 | 3 | 2018-08-16 12:55:17 |
| 12418 | 6475 | 2 | 2018-08-16 13:24:46 |
| 12419 | 6473 | 2 | 2018-08-16 13:36:54 |
| 12420 | 6472 | 2 | 2018-08-16 13:39:24 |
| 12421 | 6471 | 2 | 2018-08-16 13:40:43 |
| 12422 | 6474 | 2 | 2018-08-16 13:42:04 |
| 12423 | 6473 | 1 | 2018-08-16 14:25:47 |
| 12424 | 6475 | 3 | 2018-08-16 14:42:56 |
| 12425 | 6472 | 1 | 2018-08-16 14:45:59 |
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;