Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 326–350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 326 | 286 | 3 | 2015-04-19 13:39:07 |
| 327 | 286 | 2 | 2015-04-19 14:08:11 |
| 328 | 305 | 3 | 2015-04-20 10:26:47 |
| 329 | 315 | 2 | 2015-04-21 17:08:24 |
| 330 | 316 | 2 | 2015-04-21 17:19:40 |
| 331 | 317 | 3 | 2015-04-23 09:13:09 |
| 332 | 317 | 1 | 2015-04-23 10:19:17 |
| 333 | 317 | 3 | 2015-04-23 11:32:11 |
| 334 | 319 | 2 | 2015-04-24 13:30:59 |
| 335 | 322 | 2 | 2015-04-24 16:26:03 |
| 336 | 323 | 1 | 2015-04-24 16:28:55 |
| 337 | 325 | 1 | 2015-04-24 16:29:30 |
| 338 | 326 | 1 | 2015-04-24 16:33:40 |
| 339 | 324 | 1 | 2015-04-24 16:41:09 |
| 340 | 322 | 1 | 2015-04-24 17:24:12 |
| 341 | 298 | 2 | 2015-04-25 10:08:45 |
| 342 | 299 | 2 | 2015-04-25 10:09:59 |
| 343 | 298 | 1 | 2015-04-25 10:39:03 |
| 344 | 9 | 1 | 2015-04-25 10:57:21 |
| 345 | 36 | 1 | 2015-04-25 10:59:16 |
| 346 | 16 | 1 | 2015-04-25 10:59:27 |
| 347 | 31 | 1 | 2015-04-25 10:59:53 |
| 348 | 28 | 1 | 2015-04-25 11:00:05 |
| 349 | 15 | 1 | 2015-04-25 11:00:38 |
| 350 | 49 | 1 | 2015-04-25 11:00:59 |
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;