Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,201–10,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10201 | 5282 | 2 | 2018-02-14 10:20:46 |
| 10202 | 5281 | 3 | 2018-02-14 10:23:49 |
| 10203 | 5281 | 1 | 2018-02-14 11:45:48 |
| 10204 | 5281 | 3 | 2018-02-14 13:02:24 |
| 10205 | 5242 | 3 | 2018-02-15 09:43:08 |
| 10206 | 5243 | 3 | 2018-02-15 09:49:43 |
| 10207 | 5250 | 2 | 2018-02-15 10:32:23 |
| 10208 | 5251 | 2 | 2018-02-15 10:38:08 |
| 10209 | 5243 | 1 | 2018-02-15 10:38:09 |
| 10210 | 5242 | 1 | 2018-02-15 11:03:42 |
| 10211 | 5251 | 3 | 2018-02-15 12:13:12 |
| 10212 | 5251 | 2 | 2018-02-15 12:42:09 |
| 10213 | 5283 | 1 | 2018-02-15 13:42:52 |
| 10214 | 5286 | 1 | 2018-02-15 13:43:26 |
| 10215 | 5284 | 1 | 2018-02-15 13:50:05 |
| 10216 | 5285 | 1 | 2018-02-15 13:53:16 |
| 10217 | 5283 | 2 | 2018-02-15 14:13:33 |
| 10218 | 5285 | 2 | 2018-02-15 14:22:56 |
| 10219 | 5284 | 2 | 2018-02-15 15:11:53 |
| 10220 | 5286 | 2 | 2018-02-15 15:15:47 |
| 10221 | 5275 | 2 | 2018-02-16 09:41:09 |
| 10222 | 5288 | 1 | 2018-02-16 14:11:58 |
| 10223 | 5287 | 1 | 2018-02-16 14:20:26 |
| 10224 | 5288 | 3 | 2018-02-16 15:12:31 |
| 10225 | 5288 | 1 | 2018-02-16 15:40:35 |
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;