Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,726–14,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14726 | 7437 | 1 | 2019-02-19 10:30:53 |
| 14727 | 7439 | 1 | 2019-02-19 10:33:55 |
| 14728 | 7389 | 1 | 2019-02-19 10:37:12 |
| 14729 | 7411 | 1 | 2019-02-19 10:37:41 |
| 14730 | 7392 | 1 | 2019-02-19 10:37:52 |
| 14731 | 7434 | 1 | 2019-02-19 10:37:55 |
| 14732 | 7421 | 1 | 2019-02-19 10:38:39 |
| 14733 | 7440 | 1 | 2019-02-19 10:42:59 |
| 14734 | 7427 | 1 | 2019-02-19 10:43:51 |
| 14735 | 7402 | 1 | 2019-02-19 10:45:06 |
| 14736 | 7656 | 2 | 2019-02-19 10:45:08 |
| 14737 | 7395 | 1 | 2019-02-19 10:45:31 |
| 14738 | 7397 | 1 | 2019-02-19 10:48:50 |
| 14739 | 7425 | 1 | 2019-02-19 10:49:07 |
| 14740 | 7413 | 1 | 2019-02-19 10:50:05 |
| 14741 | 7417 | 1 | 2019-02-19 10:52:46 |
| 14742 | 7443 | 1 | 2019-02-19 10:53:01 |
| 14743 | 7420 | 1 | 2019-02-19 10:53:03 |
| 14744 | 7424 | 1 | 2019-02-19 10:53:17 |
| 14745 | 7418 | 1 | 2019-02-19 10:53:31 |
| 14746 | 7400 | 1 | 2019-02-19 10:54:25 |
| 14747 | 7403 | 1 | 2019-02-19 10:55:03 |
| 14748 | 7415 | 1 | 2019-02-19 10:55:10 |
| 14749 | 7406 | 1 | 2019-02-19 10:55:46 |
| 14750 | 7435 | 1 | 2019-02-19 10:57:18 |
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;