Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,626–14,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14626 | 7644 | 2 | 2019-02-13 12:52:11 |
| 14627 | 7586 | 3 | 2019-02-14 10:28:08 |
| 14628 | 7448 | 2 | 2019-02-14 10:44:27 |
| 14629 | 7448 | 3 | 2019-02-14 11:53:33 |
| 14630 | 7593 | 2 | 2019-02-15 15:28:36 |
| 14631 | 7592 | 2 | 2019-02-15 15:32:58 |
| 14632 | 7592 | 3 | 2019-02-15 16:21:32 |
| 14633 | 7593 | 3 | 2019-02-15 16:32:20 |
| 14634 | 7593 | 1 | 2019-02-15 17:13:27 |
| 14635 | 7592 | 1 | 2019-02-15 17:34:53 |
| 14636 | 7651 | 3 | 2019-02-16 10:43:53 |
| 14637 | 7651 | 1 | 2019-02-16 11:27:30 |
| 14638 | 7653 | 1 | 2019-02-16 12:03:55 |
| 14639 | 7652 | 1 | 2019-02-16 12:06:19 |
| 14640 | 7651 | 2 | 2019-02-16 12:37:23 |
| 14641 | 7652 | 2 | 2019-02-16 12:43:55 |
| 14642 | 7652 | 3 | 2019-02-16 13:24:18 |
| 14643 | 7653 | 2 | 2019-02-16 13:32:51 |
| 14644 | 7653 | 3 | 2019-02-16 14:28:36 |
| 14645 | 7578 | 1 | 2019-02-16 14:55:26 |
| 14646 | 7578 | 3 | 2019-02-16 15:32:53 |
| 14647 | 7655 | 2 | 2019-02-16 15:37:51 |
| 14648 | 7654 | 2 | 2019-02-16 15:39:43 |
| 14649 | 7578 | 1 | 2019-02-16 16:29:25 |
| 14650 | 7603 | 2 | 2019-02-17 09:57:31 |
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;