Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 551–575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 551 | 302 | 2 | 2015-04-26 14:05:01 |
| 552 | 304 | 1 | 2015-04-26 14:41:48 |
| 553 | 302 | 1 | 2015-04-26 14:42:09 |
| 554 | 331 | 3 | 2015-04-26 15:08:42 |
| 555 | 331 | 1 | 2015-04-26 15:59:23 |
| 556 | 228 | 2 | 2015-04-27 11:08:25 |
| 557 | 296 | 3 | 2015-04-27 11:15:08 |
| 558 | 227 | 2 | 2015-04-27 11:17:54 |
| 559 | 297 | 2 | 2015-04-27 11:24:09 |
| 560 | 227 | 3 | 2015-04-27 11:44:12 |
| 561 | 297 | 3 | 2015-04-27 11:58:45 |
| 562 | 228 | 3 | 2015-04-27 12:10:27 |
| 563 | 296 | 2 | 2015-04-27 12:21:12 |
| 564 | 297 | 1 | 2015-04-27 12:30:09 |
| 565 | 342 | 3 | 2015-04-29 11:32:01 |
| 566 | 341 | 3 | 2015-04-29 11:33:15 |
| 567 | 341 | 1 | 2015-04-29 12:20:02 |
| 568 | 348 | 3 | 2015-04-29 12:25:22 |
| 569 | 342 | 1 | 2015-04-29 12:41:33 |
| 570 | 348 | 1 | 2015-04-29 13:15:30 |
| 571 | 354 | 3 | 2015-04-30 16:32:43 |
| 572 | 355 | 3 | 2015-04-30 16:33:31 |
| 573 | 358 | 2 | 2015-05-01 10:27:31 |
| 574 | 359 | 2 | 2015-05-01 10:29:47 |
| 575 | 360 | 2 | 2015-05-01 10:30:19 |
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;