Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,251–9,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9251 | 4123 | 3 | 2017-10-26 15:24:14 |
| 9252 | 4104 | 3 | 2017-10-26 15:32:39 |
| 9253 | 4138 | 3 | 2017-10-26 15:34:10 |
| 9254 | 4810 | 2 | 2017-10-28 10:13:30 |
| 9255 | 4788 | 2 | 2017-10-28 10:48:44 |
| 9256 | 4789 | 2 | 2017-10-28 10:49:44 |
| 9257 | 4793 | 2 | 2017-10-28 10:55:51 |
| 9258 | 4790 | 2 | 2017-10-28 10:56:16 |
| 9259 | 4791 | 2 | 2017-10-28 10:58:25 |
| 9260 | 4787 | 2 | 2017-10-28 10:59:48 |
| 9261 | 4792 | 2 | 2017-10-28 11:02:18 |
| 9262 | 4810 | 3 | 2017-10-28 11:09:40 |
| 9263 | 4793 | 3 | 2017-10-28 11:28:59 |
| 9264 | 4789 | 1 | 2017-10-28 11:44:36 |
| 9265 | 4787 | 1 | 2017-10-28 11:50:29 |
| 9266 | 4791 | 3 | 2017-10-28 11:51:54 |
| 9267 | 4790 | 3 | 2017-10-28 11:52:07 |
| 9268 | 4788 | 1 | 2017-10-28 12:10:18 |
| 9269 | 4792 | 3 | 2017-10-28 12:19:56 |
| 9270 | 4810 | 2 | 2017-10-28 12:39:40 |
| 9271 | 4749 | 1 | 2017-10-28 15:00:14 |
| 9272 | 4830 | 2 | 2017-10-30 10:30:42 |
| 9273 | 4829 | 2 | 2017-10-30 10:35:57 |
| 9274 | 4828 | 2 | 2017-10-30 10:39:00 |
| 9275 | 4831 | 2 | 2017-10-30 10:44:56 |
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;