Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,501–13,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13501 | 6158 | 2 | 2018-10-25 10:17:45 |
| 13502 | 6157 | 2 | 2018-10-25 10:18:13 |
| 13503 | 6126 | 2 | 2018-10-25 10:18:27 |
| 13504 | 6151 | 2 | 2018-10-25 10:18:32 |
| 13505 | 6136 | 2 | 2018-10-25 10:18:42 |
| 13506 | 6132 | 2 | 2018-10-25 10:18:56 |
| 13507 | 6138 | 2 | 2018-10-25 10:19:19 |
| 13508 | 6120 | 2 | 2018-10-25 10:19:24 |
| 13509 | 6129 | 2 | 2018-10-25 10:20:02 |
| 13510 | 6123 | 2 | 2018-10-25 10:20:22 |
| 13511 | 6142 | 2 | 2018-10-25 10:20:54 |
| 13512 | 6154 | 2 | 2018-10-25 10:21:44 |
| 13513 | 6131 | 2 | 2018-10-25 10:22:02 |
| 13514 | 6161 | 2 | 2018-10-25 10:22:09 |
| 13515 | 6146 | 2 | 2018-10-25 10:22:12 |
| 13516 | 6145 | 2 | 2018-10-25 10:23:05 |
| 13517 | 6128 | 2 | 2018-10-25 10:23:33 |
| 13518 | 6147 | 2 | 2018-10-25 10:23:55 |
| 13519 | 6135 | 2 | 2018-10-25 10:24:08 |
| 13520 | 6121 | 2 | 2018-10-25 10:24:30 |
| 13521 | 6134 | 2 | 2018-10-25 10:24:35 |
| 13522 | 6144 | 2 | 2018-10-25 10:25:36 |
| 13523 | 6162 | 2 | 2018-10-25 10:25:47 |
| 13524 | 6165 | 2 | 2018-10-25 10:25:48 |
| 13525 | 6137 | 2 | 2018-10-25 10:28:00 |
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;