Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,626–6,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6626 | 3104 | 2 | 2017-02-24 11:25:35 |
| 6627 | 3118 | 2 | 2017-02-24 11:26:21 |
| 6628 | 3112 | 2 | 2017-02-24 11:26:31 |
| 6629 | 3122 | 2 | 2017-02-24 11:26:36 |
| 6630 | 3097 | 2 | 2017-02-24 11:26:45 |
| 6631 | 3101 | 2 | 2017-02-24 11:26:47 |
| 6632 | 3115 | 2 | 2017-02-24 11:28:34 |
| 6633 | 3091 | 2 | 2017-02-24 11:28:41 |
| 6634 | 3114 | 2 | 2017-02-24 11:30:18 |
| 6635 | 3132 | 2 | 2017-02-24 11:31:53 |
| 6636 | 3121 | 2 | 2017-02-24 11:32:56 |
| 6637 | 3127 | 2 | 2017-02-24 11:33:34 |
| 6638 | 3136 | 2 | 2017-02-24 11:33:45 |
| 6639 | 3105 | 3 | 2017-02-24 11:42:08 |
| 6640 | 3099 | 3 | 2017-02-24 11:45:00 |
| 6641 | 3110 | 3 | 2017-02-24 11:50:31 |
| 6642 | 3084 | 3 | 2017-02-24 11:56:35 |
| 6643 | 3087 | 3 | 2017-02-24 11:57:33 |
| 6644 | 3124 | 3 | 2017-02-24 11:58:41 |
| 6645 | 3129 | 3 | 2017-02-24 11:58:57 |
| 6646 | 3104 | 3 | 2017-02-24 11:59:42 |
| 6647 | 3117 | 3 | 2017-02-24 12:00:43 |
| 6648 | 3097 | 3 | 2017-02-24 12:00:49 |
| 6649 | 3096 | 3 | 2017-02-24 12:02:48 |
| 6650 | 3128 | 3 | 2017-02-24 12:04:12 |
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;