Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,126–5,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5126 | 2533 | 1 | 2016-08-04 11:58:16 |
| 5127 | 2533 | 2 | 2016-08-04 13:06:15 |
| 5128 | 2594 | 2 | 2016-08-05 12:21:55 |
| 5129 | 2595 | 2 | 2016-08-05 12:32:46 |
| 5130 | 2598 | 2 | 2016-08-06 10:03:19 |
| 5131 | 2599 | 2 | 2016-08-06 10:03:41 |
| 5132 | 2601 | 1 | 2016-08-06 10:06:44 |
| 5133 | 2600 | 1 | 2016-08-06 10:17:09 |
| 5134 | 2602 | 2 | 2016-08-06 14:57:47 |
| 5135 | 2602 | 3 | 2016-08-06 15:59:07 |
| 5136 | 2602 | 2 | 2016-08-06 17:00:32 |
| 5137 | 2573 | 3 | 2016-08-07 09:59:39 |
| 5138 | 2574 | 3 | 2016-08-07 10:00:03 |
| 5139 | 2587 | 2 | 2016-08-07 10:08:51 |
| 5140 | 2572 | 2 | 2016-08-07 10:10:34 |
| 5141 | 2588 | 2 | 2016-08-07 10:14:53 |
| 5142 | 2573 | 1 | 2016-08-07 11:18:17 |
| 5143 | 2609 | 2 | 2016-08-07 12:24:52 |
| 5144 | 2606 | 1 | 2016-08-07 12:26:41 |
| 5145 | 2608 | 1 | 2016-08-07 12:30:49 |
| 5146 | 2607 | 1 | 2016-08-07 12:32:05 |
| 5147 | 2607 | 3 | 2016-08-07 13:25:57 |
| 5148 | 2609 | 3 | 2016-08-07 13:43:38 |
| 5149 | 2607 | 1 | 2016-08-07 14:42:11 |
| 5150 | 2559 | 1 | 2016-08-08 10:58:39 |
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;