Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,126–14,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14126 | 6814 | 2 | 2018-12-09 12:49:00 |
| 14127 | 6813 | 2 | 2018-12-09 12:50:27 |
| 14128 | 6815 | 2 | 2018-12-09 12:51:32 |
| 14129 | 6824 | 2 | 2018-12-09 12:51:53 |
| 14130 | 6804 | 2 | 2018-12-09 12:52:13 |
| 14131 | 6793 | 2 | 2018-12-09 12:52:42 |
| 14132 | 6795 | 2 | 2018-12-09 12:52:42 |
| 14133 | 6798 | 2 | 2018-12-09 12:53:15 |
| 14134 | 6791 | 2 | 2018-12-09 12:53:20 |
| 14135 | 6810 | 2 | 2018-12-09 12:54:35 |
| 14136 | 6817 | 2 | 2018-12-09 12:54:35 |
| 14137 | 6818 | 2 | 2018-12-09 12:54:48 |
| 14138 | 6807 | 2 | 2018-12-09 12:55:45 |
| 14139 | 6797 | 2 | 2018-12-09 12:55:46 |
| 14140 | 6826 | 2 | 2018-12-09 12:56:13 |
| 14141 | 6816 | 2 | 2018-12-09 12:56:21 |
| 14142 | 6803 | 2 | 2018-12-09 12:56:39 |
| 14143 | 6794 | 2 | 2018-12-09 12:57:04 |
| 14144 | 6825 | 2 | 2018-12-09 12:57:45 |
| 14145 | 6823 | 2 | 2018-12-09 12:58:30 |
| 14146 | 6812 | 2 | 2018-12-09 12:59:10 |
| 14147 | 6802 | 2 | 2018-12-09 12:59:28 |
| 14148 | 6801 | 2 | 2018-12-09 12:59:38 |
| 14149 | 6820 | 2 | 2018-12-09 13:00:19 |
| 14150 | 6828 | 2 | 2018-12-09 13:00:36 |
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;