Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,401–9,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9401 | 4440 | 3 | 2017-11-06 15:24:41 |
| 9402 | 4430 | 3 | 2017-11-06 15:26:08 |
| 9403 | 4453 | 3 | 2017-11-06 15:29:28 |
| 9404 | 4449 | 3 | 2017-11-06 15:31:39 |
| 9405 | 4462 | 3 | 2017-11-06 15:32:54 |
| 9406 | 4842 | 1 | 2017-11-07 11:48:39 |
| 9407 | 4843 | 1 | 2017-11-07 11:55:05 |
| 9408 | 4842 | 3 | 2017-11-07 12:43:01 |
| 9409 | 4843 | 3 | 2017-11-07 13:29:24 |
| 9410 | 4846 | 2 | 2017-11-10 09:38:29 |
| 9411 | 4827 | 2 | 2017-11-11 10:56:10 |
| 9412 | 4747 | 1 | 2017-11-11 11:04:59 |
| 9413 | 4746 | 1 | 2017-11-11 11:13:07 |
| 9414 | 4747 | 3 | 2017-11-11 11:30:38 |
| 9415 | 4746 | 3 | 2017-11-11 12:31:10 |
| 9416 | 4847 | 2 | 2017-11-12 10:27:14 |
| 9417 | 4848 | 2 | 2017-11-12 10:36:23 |
| 9418 | 4841 | 1 | 2017-11-12 10:58:17 |
| 9419 | 4849 | 3 | 2017-11-13 10:24:41 |
| 9420 | 4850 | 3 | 2017-11-13 10:27:09 |
| 9421 | 4845 | 1 | 2017-11-13 10:57:38 |
| 9422 | 4844 | 1 | 2017-11-13 11:07:06 |
| 9423 | 4849 | 2 | 2017-11-13 11:18:20 |
| 9424 | 4850 | 1 | 2017-11-13 11:24:26 |
| 9425 | 4845 | 3 | 2017-11-13 11:49:17 |
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;