Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,401–7,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7401 | 3865 | 2 | 2017-04-30 14:07:13 |
| 7402 | 3866 | 1 | 2017-04-30 14:43:15 |
| 7403 | 3865 | 1 | 2017-04-30 15:06:37 |
| 7404 | 3866 | 2 | 2017-04-30 15:39:10 |
| 7405 | 3865 | 2 | 2017-04-30 16:29:42 |
| 7406 | 3830 | 1 | 2017-05-01 14:16:17 |
| 7407 | 3829 | 1 | 2017-05-01 14:18:10 |
| 7408 | 3777 | 1 | 2017-05-01 14:22:14 |
| 7409 | 3778 | 2 | 2017-05-01 14:27:37 |
| 7410 | 3829 | 2 | 2017-05-01 14:56:42 |
| 7411 | 3777 | 3 | 2017-05-01 15:13:29 |
| 7412 | 3778 | 3 | 2017-05-01 15:17:07 |
| 7413 | 3830 | 2 | 2017-05-01 15:27:10 |
| 7414 | 3830 | 3 | 2017-05-01 16:04:31 |
| 7415 | 3829 | 3 | 2017-05-01 16:25:50 |
| 7416 | 3830 | 2 | 2017-05-01 17:31:22 |
| 7417 | 3829 | 2 | 2017-05-01 17:42:35 |
| 7418 | 3878 | 3 | 2017-05-02 10:04:06 |
| 7419 | 3877 | 3 | 2017-05-02 10:13:45 |
| 7420 | 3878 | 1 | 2017-05-02 10:33:53 |
| 7421 | 3879 | 1 | 2017-05-02 10:40:56 |
| 7422 | 3877 | 1 | 2017-05-02 11:28:31 |
| 7423 | 3878 | 2 | 2017-05-02 12:01:31 |
| 7424 | 3879 | 3 | 2017-05-02 12:01:37 |
| 7425 | 3877 | 2 | 2017-05-02 12:30:05 |
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;