Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,301–9,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9301 | 4821 | 1 | 2017-11-04 12:08:31 |
| 9302 | 4820 | 1 | 2017-11-04 12:11:26 |
| 9303 | 4819 | 3 | 2017-11-04 12:13:09 |
| 9304 | 4815 | 2 | 2017-11-04 12:18:44 |
| 9305 | 4786 | 2 | 2017-11-04 12:35:24 |
| 9306 | 4785 | 2 | 2017-11-04 12:37:28 |
| 9307 | 4820 | 2 | 2017-11-04 12:59:33 |
| 9308 | 4815 | 3 | 2017-11-04 13:04:33 |
| 9309 | 4821 | 2 | 2017-11-04 13:21:38 |
| 9310 | 4785 | 3 | 2017-11-04 13:29:06 |
| 9311 | 4816 | 1 | 2017-11-04 13:37:43 |
| 9312 | 4820 | 3 | 2017-11-04 13:45:05 |
| 9313 | 4786 | 3 | 2017-11-04 14:08:16 |
| 9314 | 4785 | 2 | 2017-11-04 14:32:00 |
| 9315 | 4786 | 2 | 2017-11-04 15:04:40 |
| 9316 | 4785 | 3 | 2017-11-04 15:49:47 |
| 9317 | 4786 | 3 | 2017-11-04 16:18:25 |
| 9318 | 4422 | 2 | 2017-11-06 13:48:05 |
| 9319 | 4437 | 2 | 2017-11-06 13:48:56 |
| 9320 | 4452 | 2 | 2017-11-06 13:49:04 |
| 9321 | 4428 | 2 | 2017-11-06 13:49:25 |
| 9322 | 4425 | 2 | 2017-11-06 13:49:37 |
| 9323 | 4423 | 2 | 2017-11-06 13:50:33 |
| 9324 | 4448 | 2 | 2017-11-06 13:50:36 |
| 9325 | 4445 | 2 | 2017-11-06 13:50:45 |
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;