Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,826–10,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10826 | 5584 | 2 | 2018-04-23 11:07:41 |
| 10827 | 5584 | 3 | 2018-04-23 11:41:55 |
| 10828 | 5584 | 2 | 2018-04-23 12:41:36 |
| 10829 | 5587 | 2 | 2018-04-23 15:48:17 |
| 10830 | 5587 | 3 | 2018-04-23 16:15:18 |
| 10831 | 5587 | 1 | 2018-04-23 17:12:47 |
| 10832 | 5636 | 2 | 2018-04-25 11:25:07 |
| 10833 | 5637 | 2 | 2018-04-25 11:31:46 |
| 10834 | 5636 | 3 | 2018-04-25 11:59:34 |
| 10835 | 5637 | 1 | 2018-04-25 12:47:29 |
| 10836 | 5646 | 1 | 2018-04-25 13:06:26 |
| 10837 | 5636 | 1 | 2018-04-25 13:15:34 |
| 10838 | 5645 | 1 | 2018-04-25 13:21:23 |
| 10839 | 5645 | 2 | 2018-04-25 14:07:35 |
| 10840 | 5646 | 2 | 2018-04-25 14:37:31 |
| 10841 | 5650 | 2 | 2018-04-25 14:53:08 |
| 10842 | 5649 | 2 | 2018-04-25 14:54:24 |
| 10843 | 5648 | 2 | 2018-04-25 14:55:11 |
| 10844 | 5647 | 2 | 2018-04-25 14:55:34 |
| 10845 | 5651 | 2 | 2018-04-25 15:00:14 |
| 10846 | 5650 | 3 | 2018-04-25 15:21:51 |
| 10847 | 5645 | 1 | 2018-04-25 15:32:36 |
| 10848 | 5648 | 3 | 2018-04-25 15:54:24 |
| 10849 | 5649 | 3 | 2018-04-25 16:06:48 |
| 10850 | 5646 | 1 | 2018-04-25 16:11:49 |
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;