Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,751–14,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14751 | 7429 | 1 | 2019-02-19 10:58:16 |
| 14752 | 7412 | 1 | 2019-02-19 10:58:52 |
| 14753 | 7426 | 1 | 2019-02-19 10:59:49 |
| 14754 | 7407 | 1 | 2019-02-19 11:00:47 |
| 14755 | 7438 | 1 | 2019-02-19 11:02:45 |
| 14756 | 7442 | 1 | 2019-02-19 11:03:15 |
| 14757 | 7433 | 1 | 2019-02-19 11:03:35 |
| 14758 | 7439 | 2 | 2019-02-19 11:04:47 |
| 14759 | 7414 | 1 | 2019-02-19 11:05:59 |
| 14760 | 7401 | 1 | 2019-02-19 11:06:34 |
| 14761 | 7390 | 1 | 2019-02-19 11:07:17 |
| 14762 | 7422 | 1 | 2019-02-19 11:07:46 |
| 14763 | 7398 | 1 | 2019-02-19 11:09:00 |
| 14764 | 7408 | 1 | 2019-02-19 11:09:03 |
| 14765 | 7428 | 1 | 2019-02-19 11:09:35 |
| 14766 | 7423 | 1 | 2019-02-19 11:10:13 |
| 14767 | 7399 | 1 | 2019-02-19 11:10:57 |
| 14768 | 7394 | 1 | 2019-02-19 11:11:07 |
| 14769 | 7391 | 1 | 2019-02-19 11:11:10 |
| 14770 | 7416 | 1 | 2019-02-19 11:11:15 |
| 14771 | 7430 | 1 | 2019-02-19 11:11:43 |
| 14772 | 7419 | 1 | 2019-02-19 11:13:25 |
| 14773 | 7434 | 2 | 2019-02-19 11:18:49 |
| 14774 | 7436 | 1 | 2019-02-19 11:19:55 |
| 14775 | 7409 | 2 | 2019-02-19 11:21:58 |
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;