Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 576–600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 576 | 360 | 3 | 2015-05-01 11:36:34 |
| 577 | 420 | 2 | 2015-05-01 11:39:48 |
| 578 | 421 | 3 | 2015-05-01 11:43:38 |
| 579 | 357 | 2 | 2015-05-01 11:51:53 |
| 580 | 358 | 3 | 2015-05-01 11:54:08 |
| 581 | 359 | 3 | 2015-05-01 11:58:16 |
| 582 | 356 | 2 | 2015-05-01 11:59:23 |
| 583 | 360 | 2 | 2015-05-01 12:04:39 |
| 584 | 420 | 3 | 2015-05-01 12:23:10 |
| 585 | 421 | 2 | 2015-05-01 12:29:53 |
| 586 | 358 | 2 | 2015-05-01 12:47:43 |
| 587 | 359 | 2 | 2015-05-01 13:23:17 |
| 588 | 309 | 2 | 2015-05-01 13:44:23 |
| 589 | 308 | 2 | 2015-05-01 13:46:34 |
| 590 | 421 | 3 | 2015-05-01 14:03:39 |
| 591 | 309 | 1 | 2015-05-01 14:27:40 |
| 592 | 308 | 1 | 2015-05-01 14:48:47 |
| 593 | 421 | 2 | 2015-05-01 15:13:04 |
| 594 | 422 | 2 | 2015-05-01 15:52:25 |
| 595 | 338 | 2 | 2015-05-02 11:28:32 |
| 596 | 337 | 2 | 2015-05-02 11:34:37 |
| 597 | 336 | 2 | 2015-05-02 11:36:23 |
| 598 | 337 | 3 | 2015-05-02 12:53:13 |
| 599 | 338 | 3 | 2015-05-02 13:03:00 |
| 600 | 336 | 3 | 2015-05-02 13:08: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;