Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,576–16,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16576 | 8412 | 2 | 2019-06-25 10:33:35 |
| 16577 | 8413 | 3 | 2019-06-25 11:05:07 |
| 16578 | 8432 | 3 | 2019-06-25 11:08:03 |
| 16579 | 8430 | 3 | 2019-06-25 11:10:38 |
| 16580 | 8283 | 2 | 2019-06-25 11:14:24 |
| 16581 | 8414 | 3 | 2019-06-25 11:18:06 |
| 16582 | 8431 | 3 | 2019-06-25 11:18:50 |
| 16583 | 8432 | 1 | 2019-06-25 12:06:27 |
| 16584 | 8431 | 1 | 2019-06-25 12:09:58 |
| 16585 | 8413 | 1 | 2019-06-25 12:18:39 |
| 16586 | 8430 | 1 | 2019-06-25 12:21:10 |
| 16587 | 8414 | 1 | 2019-06-25 12:51:50 |
| 16588 | 8413 | 2 | 2019-06-25 13:02:04 |
| 16589 | 8414 | 2 | 2019-06-25 13:35:28 |
| 16590 | 8435 | 1 | 2019-06-26 14:54:46 |
| 16591 | 8425 | 2 | 2019-06-27 11:53:13 |
| 16592 | 8424 | 2 | 2019-06-27 12:00:41 |
| 16593 | 8423 | 2 | 2019-06-27 12:01:49 |
| 16594 | 8426 | 2 | 2019-06-27 12:08:46 |
| 16595 | 8425 | 3 | 2019-06-27 12:24:55 |
| 16596 | 8423 | 3 | 2019-06-27 12:50:35 |
| 16597 | 8424 | 3 | 2019-06-27 13:22:21 |
| 16598 | 8425 | 1 | 2019-06-27 13:25:35 |
| 16599 | 8426 | 3 | 2019-06-27 13:40:41 |
| 16600 | 8423 | 1 | 2019-06-27 13:43: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;