Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,526–17,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17526 | 8810 | 3 | 2019-08-31 13:17:13 |
| 17527 | 8814 | 3 | 2019-08-31 13:17:18 |
| 17528 | 8811 | 3 | 2019-08-31 13:18:10 |
| 17529 | 8852 | 2 | 2019-08-31 14:14:00 |
| 17530 | 8811 | 2 | 2019-08-31 14:14:30 |
| 17531 | 8810 | 2 | 2019-08-31 14:17:49 |
| 17532 | 8813 | 2 | 2019-08-31 14:18:29 |
| 17533 | 8814 | 2 | 2019-08-31 14:32:00 |
| 17534 | 8812 | 2 | 2019-08-31 14:40:44 |
| 17535 | 8814 | 3 | 2019-08-31 15:04:27 |
| 17536 | 8811 | 3 | 2019-08-31 15:16:11 |
| 17537 | 8813 | 3 | 2019-08-31 15:27:03 |
| 17538 | 8814 | 1 | 2019-08-31 15:49:46 |
| 17539 | 8810 | 3 | 2019-08-31 15:50:15 |
| 17540 | 8812 | 3 | 2019-08-31 15:50:44 |
| 17541 | 8811 | 1 | 2019-08-31 16:11:33 |
| 17542 | 8813 | 1 | 2019-08-31 16:30:31 |
| 17543 | 8814 | 2 | 2019-08-31 16:49:43 |
| 17544 | 8810 | 1 | 2019-08-31 17:02:08 |
| 17545 | 8811 | 2 | 2019-08-31 17:05:42 |
| 17546 | 8812 | 1 | 2019-08-31 17:07:23 |
| 17547 | 8813 | 2 | 2019-08-31 17:49:22 |
| 17548 | 8795 | 1 | 2019-09-01 10:48:38 |
| 17549 | 8796 | 1 | 2019-09-01 11:01:14 |
| 17550 | 8795 | 2 | 2019-09-01 12:03:16 |
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;