Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,651–14,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14651 | 7604 | 2 | 2019-02-17 10:06:52 |
| 14652 | 7602 | 2 | 2019-02-17 10:09:13 |
| 14653 | 7603 | 1 | 2019-02-17 10:47:23 |
| 14654 | 7602 | 3 | 2019-02-17 11:20:34 |
| 14655 | 7604 | 1 | 2019-02-17 11:26:57 |
| 14656 | 7603 | 2 | 2019-02-17 11:35:01 |
| 14657 | 7604 | 2 | 2019-02-17 11:55:15 |
| 14658 | 7603 | 1 | 2019-02-17 12:22:53 |
| 14659 | 7604 | 1 | 2019-02-17 12:51:56 |
| 14660 | 7658 | 2 | 2019-02-18 10:47:21 |
| 14661 | 7657 | 2 | 2019-02-18 10:54:42 |
| 14662 | 7657 | 1 | 2019-02-18 11:22:45 |
| 14663 | 7658 | 1 | 2019-02-18 12:11:32 |
| 14664 | 7657 | 2 | 2019-02-18 12:31:07 |
| 14665 | 7658 | 2 | 2019-02-18 13:22:24 |
| 14666 | 7395 | 2 | 2019-02-19 09:46:13 |
| 14667 | 7398 | 2 | 2019-02-19 09:47:27 |
| 14668 | 7414 | 2 | 2019-02-19 09:48:28 |
| 14669 | 7402 | 2 | 2019-02-19 09:48:50 |
| 14670 | 7399 | 2 | 2019-02-19 09:48:54 |
| 14671 | 7430 | 2 | 2019-02-19 09:49:03 |
| 14672 | 7391 | 2 | 2019-02-19 09:49:22 |
| 14673 | 7425 | 2 | 2019-02-19 09:49:40 |
| 14674 | 7409 | 2 | 2019-02-19 09:50:10 |
| 14675 | 7411 | 2 | 2019-02-19 09:50:21 |
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;