Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,626–15,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15626 | 7842 | 1 | 2019-04-15 12:27:59 |
| 15627 | 7862 | 1 | 2019-04-15 12:28:01 |
| 15628 | 7870 | 1 | 2019-04-15 12:28:09 |
| 15629 | 7840 | 1 | 2019-04-15 12:28:18 |
| 15630 | 7852 | 1 | 2019-04-15 12:28:49 |
| 15631 | 7834 | 1 | 2019-04-15 12:28:54 |
| 15632 | 7847 | 1 | 2019-04-15 12:29:38 |
| 15633 | 7857 | 1 | 2019-04-15 12:29:57 |
| 15634 | 7874 | 1 | 2019-04-15 12:30:59 |
| 15635 | 7856 | 1 | 2019-04-15 12:31:13 |
| 15636 | 7855 | 1 | 2019-04-15 12:32:02 |
| 15637 | 7863 | 1 | 2019-04-15 12:32:02 |
| 15638 | 7873 | 1 | 2019-04-15 12:32:52 |
| 15639 | 7848 | 2 | 2019-04-15 12:47:22 |
| 15640 | 7860 | 2 | 2019-04-15 12:47:23 |
| 15641 | 7844 | 2 | 2019-04-15 12:47:47 |
| 15642 | 7871 | 2 | 2019-04-15 12:53:51 |
| 15643 | 7841 | 2 | 2019-04-15 12:54:08 |
| 15644 | 7827 | 2 | 2019-04-15 12:54:39 |
| 15645 | 7834 | 2 | 2019-04-15 12:55:18 |
| 15646 | 7852 | 2 | 2019-04-15 12:55:23 |
| 15647 | 7853 | 2 | 2019-04-15 12:55:25 |
| 15648 | 7835 | 2 | 2019-04-15 12:57:32 |
| 15649 | 7874 | 2 | 2019-04-15 12:59:37 |
| 15650 | 7825 | 2 | 2019-04-15 12:59:41 |
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;