Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,351–17,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17351 | 8780 | 2 | 2019-08-18 11:38:36 |
| 17352 | 8770 | 3 | 2019-08-18 11:53:07 |
| 17353 | 8772 | 2 | 2019-08-18 12:09:46 |
| 17354 | 8773 | 3 | 2019-08-18 12:12:00 |
| 17355 | 8771 | 3 | 2019-08-18 12:12:22 |
| 17356 | 8780 | 1 | 2019-08-18 12:50:53 |
| 17357 | 8779 | 2 | 2019-08-18 14:08:12 |
| 17358 | 8779 | 1 | 2019-08-18 15:27:18 |
| 17359 | 8779 | 3 | 2019-08-18 16:33:15 |
| 17360 | 8783 | 1 | 2019-08-19 10:54:24 |
| 17361 | 8785 | 3 | 2019-08-19 13:13:15 |
| 17362 | 8784 | 3 | 2019-08-19 13:27:02 |
| 17363 | 8784 | 2 | 2019-08-19 14:02:08 |
| 17364 | 8785 | 2 | 2019-08-19 14:27:37 |
| 17365 | 8575 | 2 | 2019-08-21 09:46:10 |
| 17366 | 8574 | 2 | 2019-08-21 09:53:13 |
| 17367 | 8761 | 1 | 2019-08-21 10:21:40 |
| 17368 | 8574 | 1 | 2019-08-21 10:50:12 |
| 17369 | 8761 | 2 | 2019-08-21 10:50:51 |
| 17370 | 8575 | 1 | 2019-08-21 10:52:42 |
| 17371 | 8759 | 2 | 2019-08-21 11:12:03 |
| 17372 | 8761 | 3 | 2019-08-21 11:33:07 |
| 17373 | 8776 | 1 | 2019-08-21 11:49:31 |
| 17374 | 8759 | 3 | 2019-08-21 12:28:14 |
| 17375 | 8794 | 2 | 2019-08-22 14:50:20 |
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;