Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,701–14,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14701 | 7413 | 2 | 2019-02-19 09:57:11 |
| 14702 | 7417 | 2 | 2019-02-19 09:58:14 |
| 14703 | 7422 | 2 | 2019-02-19 09:58:26 |
| 14704 | 7407 | 2 | 2019-02-19 09:58:31 |
| 14705 | 7441 | 2 | 2019-02-19 09:58:37 |
| 14706 | 7443 | 2 | 2019-02-19 09:58:39 |
| 14707 | 7394 | 2 | 2019-02-19 09:59:07 |
| 14708 | 7390 | 2 | 2019-02-19 09:59:20 |
| 14709 | 7393 | 2 | 2019-02-19 10:00:38 |
| 14710 | 7405 | 2 | 2019-02-19 10:00:42 |
| 14711 | 7423 | 2 | 2019-02-19 10:01:05 |
| 14712 | 7397 | 2 | 2019-02-19 10:01:41 |
| 14713 | 7396 | 2 | 2019-02-19 10:01:58 |
| 14714 | 7440 | 2 | 2019-02-19 10:02:18 |
| 14715 | 7437 | 2 | 2019-02-19 10:02:24 |
| 14716 | 7412 | 2 | 2019-02-19 10:02:34 |
| 14717 | 7428 | 2 | 2019-02-19 10:03:58 |
| 14718 | 7433 | 2 | 2019-02-19 10:03:58 |
| 14719 | 7421 | 2 | 2019-02-19 10:04:05 |
| 14720 | 7434 | 2 | 2019-02-19 10:06:47 |
| 14721 | 7409 | 1 | 2019-02-19 10:24:40 |
| 14722 | 7464 | 1 | 2019-02-19 10:24:57 |
| 14723 | 7431 | 1 | 2019-02-19 10:26:45 |
| 14724 | 7465 | 2 | 2019-02-19 10:27:28 |
| 14725 | 7393 | 1 | 2019-02-19 10:29:19 |
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;