Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,251–8,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8251 | 4275 | 2 | 2017-07-18 13:54:07 |
| 8252 | 4280 | 1 | 2017-07-18 16:45:16 |
| 8253 | 4281 | 1 | 2017-07-18 16:48:09 |
| 8254 | 4282 | 3 | 2017-07-18 16:49:24 |
| 8255 | 4280 | 3 | 2017-07-18 17:37:49 |
| 8256 | 4181 | 2 | 2017-07-19 11:04:40 |
| 8257 | 4246 | 2 | 2017-07-19 11:31:59 |
| 8258 | 4247 | 2 | 2017-07-19 11:33:16 |
| 8259 | 4245 | 2 | 2017-07-19 11:35:06 |
| 8260 | 4294 | 2 | 2017-07-20 15:01:30 |
| 8261 | 4294 | 1 | 2017-07-20 16:24:02 |
| 8262 | 4290 | 1 | 2017-07-21 09:49:05 |
| 8263 | 4291 | 2 | 2017-07-21 09:50:38 |
| 8264 | 4289 | 2 | 2017-07-21 09:51:09 |
| 8265 | 4293 | 2 | 2017-07-21 09:53:38 |
| 8266 | 4292 | 2 | 2017-07-21 09:55:45 |
| 8267 | 4293 | 1 | 2017-07-21 10:36:19 |
| 8268 | 4291 | 1 | 2017-07-21 10:37:00 |
| 8269 | 4292 | 1 | 2017-07-21 10:48:36 |
| 8270 | 4289 | 1 | 2017-07-21 10:59:27 |
| 8271 | 4291 | 3 | 2017-07-21 11:26:58 |
| 8272 | 4293 | 3 | 2017-07-21 11:52:00 |
| 8273 | 4289 | 3 | 2017-07-21 12:04:48 |
| 8274 | 4292 | 3 | 2017-07-21 12:19:31 |
| 8275 | 4265 | 1 | 2017-07-22 12:34:27 |
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;