Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,176–5,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5176 | 2618 | 2 | 2016-08-11 12:21:19 |
| 5177 | 2614 | 2 | 2016-08-11 12:26:55 |
| 5178 | 2615 | 3 | 2016-08-11 12:48:36 |
| 5179 | 2617 | 1 | 2016-08-11 12:49:22 |
| 5180 | 2613 | 3 | 2016-08-11 13:00:44 |
| 5181 | 2616 | 3 | 2016-08-11 13:05:57 |
| 5182 | 2614 | 3 | 2016-08-11 13:14:31 |
| 5183 | 2619 | 2 | 2016-08-11 13:36:43 |
| 5184 | 2623 | 3 | 2016-08-11 13:38:55 |
| 5185 | 2622 | 2 | 2016-08-11 13:42:29 |
| 5186 | 2620 | 2 | 2016-08-11 13:44:29 |
| 5187 | 2621 | 2 | 2016-08-11 13:48:18 |
| 5188 | 2617 | 2 | 2016-08-11 13:59:20 |
| 5189 | 2622 | 1 | 2016-08-11 14:18:41 |
| 5190 | 2621 | 1 | 2016-08-11 14:30:40 |
| 5191 | 2620 | 1 | 2016-08-11 14:37:13 |
| 5192 | 2623 | 2 | 2016-08-11 15:12:25 |
| 5193 | 2623 | 3 | 2016-08-11 16:20:57 |
| 5194 | 2630 | 1 | 2016-08-13 10:24:16 |
| 5195 | 2628 | 2 | 2016-08-13 10:27:11 |
| 5196 | 2629 | 2 | 2016-08-13 10:33:56 |
| 5197 | 2628 | 1 | 2016-08-13 10:53:39 |
| 5198 | 2630 | 2 | 2016-08-13 11:15:17 |
| 5199 | 2630 | 3 | 2016-08-13 11:42:37 |
| 5200 | 2592 | 2 | 2016-08-13 14:45:08 |
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;