Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,376–12,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12376 | 6435 | 3 | 2018-08-12 16:44:45 |
| 12377 | 6436 | 3 | 2018-08-12 17:00:06 |
| 12378 | 6434 | 2 | 2018-08-13 09:47:27 |
| 12379 | 6434 | 3 | 2018-08-13 10:17:44 |
| 12380 | 6422 | 2 | 2018-08-13 10:37:44 |
| 12381 | 6419 | 2 | 2018-08-13 10:39:21 |
| 12382 | 6418 | 2 | 2018-08-13 10:42:12 |
| 12383 | 6421 | 2 | 2018-08-13 10:43:17 |
| 12384 | 6420 | 2 | 2018-08-13 10:44:07 |
| 12385 | 6418 | 3 | 2018-08-13 11:16:50 |
| 12386 | 6419 | 3 | 2018-08-13 11:24:46 |
| 12387 | 6422 | 3 | 2018-08-13 11:34:00 |
| 12388 | 6421 | 3 | 2018-08-13 11:40:27 |
| 12389 | 6434 | 1 | 2018-08-13 11:42:28 |
| 12390 | 6465 | 3 | 2018-08-13 11:56:47 |
| 12391 | 6464 | 3 | 2018-08-13 11:57:32 |
| 12392 | 6420 | 3 | 2018-08-13 11:59:50 |
| 12393 | 6422 | 2 | 2018-08-13 12:33:35 |
| 12394 | 6421 | 2 | 2018-08-13 12:37:36 |
| 12395 | 6418 | 2 | 2018-08-13 12:49:11 |
| 12396 | 6464 | 1 | 2018-08-13 12:57:39 |
| 12397 | 6419 | 2 | 2018-08-13 12:59:42 |
| 12398 | 6465 | 1 | 2018-08-13 13:23:00 |
| 12399 | 6420 | 2 | 2018-08-13 13:23:18 |
| 12400 | 6418 | 3 | 2018-08-13 13:24:36 |
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;