Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,476–12,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12476 | 6492 | 1 | 2018-08-18 16:49:55 |
| 12477 | 6493 | 3 | 2018-08-18 17:22:32 |
| 12478 | 6495 | 1 | 2018-08-19 09:32:47 |
| 12479 | 6495 | 3 | 2018-08-19 10:13:41 |
| 12480 | 6496 | 1 | 2018-08-19 11:16:20 |
| 12481 | 6497 | 1 | 2018-08-19 11:22:46 |
| 12482 | 6498 | 1 | 2018-08-19 11:23:06 |
| 12483 | 6495 | 2 | 2018-08-19 11:25:06 |
| 12484 | 6498 | 2 | 2018-08-19 11:49:32 |
| 12485 | 6496 | 2 | 2018-08-19 11:53:35 |
| 12486 | 6497 | 2 | 2018-08-19 12:10:36 |
| 12487 | 6495 | 3 | 2018-08-19 12:34:49 |
| 12488 | 6500 | 1 | 2018-08-19 12:52:34 |
| 12489 | 6499 | 1 | 2018-08-19 12:57:11 |
| 12490 | 6496 | 1 | 2018-08-19 13:10:05 |
| 12491 | 6497 | 1 | 2018-08-19 13:18:59 |
| 12492 | 6498 | 1 | 2018-08-19 13:23:59 |
| 12493 | 6499 | 3 | 2018-08-19 14:08:54 |
| 12494 | 6500 | 3 | 2018-08-19 14:24:17 |
| 12495 | 6335 | 1 | 2018-08-19 15:29:39 |
| 12496 | 6332 | 1 | 2018-08-19 15:37:52 |
| 12497 | 6336 | 2 | 2018-08-19 15:40:20 |
| 12498 | 6333 | 2 | 2018-08-19 15:40:53 |
| 12499 | 6334 | 1 | 2018-08-19 15:41:09 |
| 12500 | 6463 | 2 | 2018-08-19 15:48:02 |
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;