Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,526–13,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13526 | 6159 | 2 | 2018-10-25 10:28:31 |
| 13527 | 6160 | 2 | 2018-10-25 10:28:48 |
| 13528 | 6141 | 2 | 2018-10-25 10:29:53 |
| 13529 | 6155 | 2 | 2018-10-25 10:30:37 |
| 13530 | 6163 | 2 | 2018-10-25 10:30:40 |
| 13531 | 6164 | 2 | 2018-10-25 10:30:57 |
| 13532 | 6122 | 1 | 2018-10-25 10:43:24 |
| 13533 | 6152 | 1 | 2018-10-25 10:44:02 |
| 13534 | 6131 | 1 | 2018-10-25 10:49:29 |
| 13535 | 6138 | 1 | 2018-10-25 10:50:29 |
| 13536 | 6145 | 1 | 2018-10-25 10:53:38 |
| 13537 | 6134 | 1 | 2018-10-25 11:00:46 |
| 13538 | 6139 | 1 | 2018-10-25 11:05:00 |
| 13539 | 6161 | 1 | 2018-10-25 11:05:07 |
| 13540 | 6125 | 1 | 2018-10-25 11:05:22 |
| 13541 | 6124 | 1 | 2018-10-25 11:07:21 |
| 13542 | 6154 | 1 | 2018-10-25 11:08:05 |
| 13543 | 6151 | 1 | 2018-10-25 11:09:50 |
| 13544 | 6164 | 1 | 2018-10-25 11:10:26 |
| 13545 | 6137 | 1 | 2018-10-25 11:12:35 |
| 13546 | 6142 | 1 | 2018-10-25 11:16:13 |
| 13547 | 6140 | 1 | 2018-10-25 11:17:32 |
| 13548 | 6146 | 1 | 2018-10-25 11:20:41 |
| 13549 | 6127 | 1 | 2018-10-25 11:22:46 |
| 13550 | 6130 | 1 | 2018-10-25 11:23:22 |
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;