Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,326–10,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10326 | 5336 | 1 | 2018-03-01 13:30:12 |
| 10327 | 5335 | 1 | 2018-03-01 13:58:12 |
| 10328 | 5277 | 3 | 2018-03-02 10:15:45 |
| 10329 | 5278 | 3 | 2018-03-02 10:20:43 |
| 10330 | 5279 | 3 | 2018-03-02 10:21:16 |
| 10331 | 5276 | 3 | 2018-03-02 10:23:32 |
| 10332 | 5273 | 2 | 2018-03-02 11:11:15 |
| 10333 | 5274 | 2 | 2018-03-02 11:12:50 |
| 10334 | 5273 | 3 | 2018-03-02 12:09:13 |
| 10335 | 5274 | 3 | 2018-03-02 12:45:09 |
| 10336 | 5273 | 2 | 2018-03-02 13:01:21 |
| 10337 | 5339 | 2 | 2018-03-03 15:57:28 |
| 10338 | 5339 | 1 | 2018-03-03 17:02:02 |
| 10339 | 5329 | 3 | 2018-03-04 09:22:35 |
| 10340 | 5331 | 3 | 2018-03-04 09:32:25 |
| 10341 | 5332 | 3 | 2018-03-04 09:35:05 |
| 10342 | 5330 | 3 | 2018-03-04 09:35:10 |
| 10343 | 5330 | 2 | 2018-03-04 11:10:22 |
| 10344 | 5330 | 3 | 2018-03-04 12:00:25 |
| 10345 | 5301 | 2 | 2018-03-05 14:34:46 |
| 10346 | 5301 | 3 | 2018-03-05 15:07:55 |
| 10347 | 5301 | 1 | 2018-03-05 16:40:42 |
| 10348 | 5315 | 2 | 2018-03-06 11:32:04 |
| 10349 | 5315 | 3 | 2018-03-06 12:28:04 |
| 10350 | 5311 | 2 | 2018-03-06 12:58:33 |
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;