Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,476–5,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5476 | 2732 | 2 | 2016-09-15 11:32:08 |
| 5477 | 2733 | 2 | 2016-09-15 11:37:55 |
| 5478 | 2731 | 2 | 2016-09-15 11:47:02 |
| 5479 | 2731 | 3 | 2016-09-15 12:47:13 |
| 5480 | 2733 | 3 | 2016-09-15 12:51:49 |
| 5481 | 2732 | 3 | 2016-09-15 12:57:28 |
| 5482 | 2813 | 2 | 2016-09-15 15:10:56 |
| 5483 | 2783 | 3 | 2016-09-16 09:23:59 |
| 5484 | 2784 | 3 | 2016-09-16 09:28:44 |
| 5485 | 2784 | 2 | 2016-09-16 10:46:57 |
| 5486 | 2783 | 2 | 2016-09-16 10:53:06 |
| 5487 | 2784 | 1 | 2016-09-16 11:29:48 |
| 5488 | 2785 | 3 | 2016-09-16 11:58:46 |
| 5489 | 2783 | 1 | 2016-09-16 12:22:37 |
| 5490 | 2785 | 2 | 2016-09-16 12:28:20 |
| 5491 | 2809 | 2 | 2016-09-17 10:30:51 |
| 5492 | 2810 | 3 | 2016-09-17 10:41:52 |
| 5493 | 2809 | 1 | 2016-09-17 11:10:05 |
| 5494 | 2810 | 1 | 2016-09-17 11:57:19 |
| 5495 | 2691 | 2 | 2016-09-17 16:34:05 |
| 5496 | 2690 | 2 | 2016-09-17 16:42:24 |
| 5497 | 2691 | 1 | 2016-09-17 17:43:30 |
| 5498 | 2818 | 3 | 2016-09-18 10:42:00 |
| 5499 | 2818 | 1 | 2016-09-18 12:07:19 |
| 5500 | 2818 | 2 | 2016-09-18 13:07:09 |
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;