Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,726–17,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17726 | 9118 | 3 | 2019-09-28 09:56:58 |
| 17727 | 9117 | 3 | 2019-09-28 10:01:20 |
| 17728 | 9118 | 1 | 2019-09-28 10:34:32 |
| 17729 | 9117 | 1 | 2019-09-28 10:39:39 |
| 17730 | 9118 | 2 | 2019-09-28 11:13:21 |
| 17731 | 9117 | 2 | 2019-09-28 11:58:29 |
| 17732 | 9120 | 2 | 2019-09-29 09:17:57 |
| 17733 | 9119 | 2 | 2019-09-29 09:21:50 |
| 17734 | 9119 | 3 | 2019-09-29 09:47:30 |
| 17735 | 9120 | 1 | 2019-09-29 09:48:37 |
| 17736 | 8869 | 2 | 2019-09-30 09:39:27 |
| 17737 | 8869 | 3 | 2019-09-30 10:10:16 |
| 17738 | 8875 | 2 | 2019-09-30 11:26:04 |
| 17739 | 8876 | 2 | 2019-09-30 11:27:25 |
| 17740 | 9124 | 1 | 2019-10-03 09:16:56 |
| 17741 | 9123 | 2 | 2019-10-03 09:17:30 |
| 17742 | 9125 | 3 | 2019-10-03 09:23:54 |
| 17743 | 9122 | 2 | 2019-10-03 09:27:15 |
| 17744 | 9104 | 3 | 2019-10-03 09:31:29 |
| 17745 | 9105 | 3 | 2019-10-03 09:36:39 |
| 17746 | 9106 | 2 | 2019-10-03 09:43:55 |
| 17747 | 9020 | 3 | 2019-10-03 09:54:35 |
| 17748 | 9022 | 3 | 2019-10-03 09:56:19 |
| 17749 | 9019 | 3 | 2019-10-03 09:57:10 |
| 17750 | 9021 | 3 | 2019-10-03 10:01:14 |
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;