Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,201–12,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12201 | 6306 | 1 | 2018-08-02 17:01:23 |
| 12202 | 6329 | 3 | 2018-08-02 17:02:50 |
| 12203 | 6306 | 3 | 2018-08-02 17:34:31 |
| 12204 | 6328 | 3 | 2018-08-02 17:48:39 |
| 12205 | 6346 | 3 | 2018-08-03 11:17:11 |
| 12206 | 6349 | 3 | 2018-08-03 11:22:40 |
| 12207 | 6348 | 3 | 2018-08-03 11:23:18 |
| 12208 | 6347 | 3 | 2018-08-03 11:25:02 |
| 12209 | 6344 | 1 | 2018-08-04 12:11:36 |
| 12210 | 6343 | 2 | 2018-08-04 12:16:17 |
| 12211 | 6392 | 3 | 2018-08-04 13:22:20 |
| 12212 | 6393 | 3 | 2018-08-04 13:22:49 |
| 12213 | 6390 | 2 | 2018-08-04 13:25:28 |
| 12214 | 6391 | 3 | 2018-08-04 13:30:27 |
| 12215 | 6391 | 2 | 2018-08-04 14:33:25 |
| 12216 | 6392 | 2 | 2018-08-04 14:36:13 |
| 12217 | 6393 | 1 | 2018-08-04 14:39:53 |
| 12218 | 6394 | 2 | 2018-08-04 17:09:35 |
| 12219 | 6395 | 2 | 2018-08-04 17:10:42 |
| 12220 | 6395 | 1 | 2018-08-04 17:41:23 |
| 12221 | 6396 | 2 | 2018-08-05 11:19:25 |
| 12222 | 6398 | 1 | 2018-08-05 13:08:50 |
| 12223 | 6400 | 2 | 2018-08-05 13:10:51 |
| 12224 | 6397 | 2 | 2018-08-05 13:13:09 |
| 12225 | 6399 | 2 | 2018-08-05 13:20:46 |
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;