Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,501–11,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11501 | 6024 | 3 | 2018-06-15 12:30:39 |
| 11502 | 6023 | 3 | 2018-06-15 12:38:03 |
| 11503 | 6047 | 1 | 2018-06-15 13:07:33 |
| 11504 | 6049 | 1 | 2018-06-15 13:25:32 |
| 11505 | 6033 | 1 | 2018-06-15 13:32:41 |
| 11506 | 6034 | 1 | 2018-06-15 13:34:52 |
| 11507 | 6035 | 1 | 2018-06-15 13:39:51 |
| 11508 | 6032 | 1 | 2018-06-15 13:41:46 |
| 11509 | 6036 | 2 | 2018-06-15 13:42:11 |
| 11510 | 6049 | 3 | 2018-06-15 13:53:49 |
| 11511 | 6032 | 2 | 2018-06-15 14:26:46 |
| 11512 | 6035 | 2 | 2018-06-15 14:41:11 |
| 11513 | 6034 | 2 | 2018-06-15 14:57:39 |
| 11514 | 6032 | 1 | 2018-06-15 15:05:53 |
| 11515 | 6033 | 2 | 2018-06-15 15:07:46 |
| 11516 | 6034 | 1 | 2018-06-15 15:32:29 |
| 11517 | 6035 | 1 | 2018-06-15 16:07:25 |
| 11518 | 6033 | 1 | 2018-06-15 16:34:57 |
| 11519 | 5937 | 2 | 2018-06-16 11:36:57 |
| 11520 | 5938 | 2 | 2018-06-16 11:39:21 |
| 11521 | 5937 | 1 | 2018-06-16 13:01:05 |
| 11522 | 5938 | 1 | 2018-06-16 13:03:59 |
| 11523 | 6027 | 2 | 2018-06-17 11:38:03 |
| 11524 | 6026 | 2 | 2018-06-17 11:38:29 |
| 11525 | 6027 | 3 | 2018-06-17 12:36: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;