Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 526–550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 526 | 311 | 2 | 2015-04-26 09:23:53 |
| 527 | 313 | 2 | 2015-04-26 09:24:30 |
| 528 | 310 | 2 | 2015-04-26 09:24:47 |
| 529 | 312 | 2 | 2015-04-26 09:26:37 |
| 530 | 311 | 3 | 2015-04-26 09:50:51 |
| 531 | 314 | 3 | 2015-04-26 10:02:31 |
| 532 | 260 | 1 | 2015-04-26 10:26:57 |
| 533 | 313 | 3 | 2015-04-26 10:27:40 |
| 534 | 312 | 3 | 2015-04-26 10:40:05 |
| 535 | 261 | 1 | 2015-04-26 10:41:01 |
| 536 | 310 | 3 | 2015-04-26 10:51:43 |
| 537 | 306 | 1 | 2015-04-26 11:03:55 |
| 538 | 307 | 1 | 2015-04-26 11:05:46 |
| 539 | 291 | 3 | 2015-04-26 11:23:31 |
| 540 | 306 | 2 | 2015-04-26 11:44:58 |
| 541 | 307 | 2 | 2015-04-26 11:46:46 |
| 542 | 327 | 2 | 2015-04-26 12:24:14 |
| 543 | 291 | 1 | 2015-04-26 12:32:06 |
| 544 | 302 | 3 | 2015-04-26 13:03:29 |
| 545 | 304 | 3 | 2015-04-26 13:12:06 |
| 546 | 303 | 1 | 2015-04-26 13:14:46 |
| 547 | 331 | 2 | 2015-04-26 13:31:39 |
| 548 | 304 | 2 | 2015-04-26 13:37:10 |
| 549 | 291 | 2 | 2015-04-26 13:45:26 |
| 550 | 331 | 1 | 2015-04-26 13:57:26 |
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;