Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,726–13,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13726 | 7038 | 3 | 2018-11-11 09:33:15 |
| 13727 | 7009 | 1 | 2018-11-11 11:07:24 |
| 13728 | 7010 | 1 | 2018-11-11 11:12:47 |
| 13729 | 7007 | 1 | 2018-11-11 11:13:42 |
| 13730 | 7008 | 2 | 2018-11-11 11:21:39 |
| 13731 | 7010 | 3 | 2018-11-11 11:54:18 |
| 13732 | 7007 | 3 | 2018-11-11 12:03:49 |
| 13733 | 7042 | 2 | 2018-11-11 12:23:54 |
| 13734 | 7009 | 3 | 2018-11-11 12:31:18 |
| 13735 | 7007 | 2 | 2018-11-11 12:46:55 |
| 13736 | 7033 | 1 | 2018-11-11 13:06:24 |
| 13737 | 7030 | 2 | 2018-11-11 13:11:05 |
| 13738 | 7018 | 1 | 2018-11-11 13:12:25 |
| 13739 | 7031 | 2 | 2018-11-11 13:12:25 |
| 13740 | 7032 | 1 | 2018-11-11 13:16:49 |
| 13741 | 7010 | 2 | 2018-11-11 13:28:11 |
| 13742 | 7033 | 3 | 2018-11-11 13:32:59 |
| 13743 | 7009 | 2 | 2018-11-11 14:02:51 |
| 13744 | 7032 | 2 | 2018-11-11 14:05:21 |
| 13745 | 7033 | 2 | 2018-11-11 14:08:55 |
| 13746 | 7007 | 3 | 2018-11-11 14:10:01 |
| 13747 | 7018 | 3 | 2018-11-11 14:44:09 |
| 13748 | 7010 | 3 | 2018-11-11 14:50:48 |
| 13749 | 7032 | 3 | 2018-11-11 14:56:37 |
| 13750 | 7009 | 3 | 2018-11-11 15:11:57 |
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;