Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,251–11,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11251 | 5788 | 2 | 2018-05-17 11:17:45 |
| 11252 | 5789 | 2 | 2018-05-17 11:30:34 |
| 11253 | 5791 | 2 | 2018-05-17 11:30:56 |
| 11254 | 5790 | 2 | 2018-05-17 11:32:01 |
| 11255 | 5788 | 1 | 2018-05-17 12:22:19 |
| 11256 | 5790 | 1 | 2018-05-17 13:01:04 |
| 11257 | 5789 | 1 | 2018-05-17 13:02:16 |
| 11258 | 5792 | 2 | 2018-05-17 14:02:59 |
| 11259 | 5792 | 1 | 2018-05-17 15:34:31 |
| 11260 | 5767 | 2 | 2018-05-18 10:39:46 |
| 11261 | 5766 | 2 | 2018-05-18 10:42:12 |
| 11262 | 5764 | 2 | 2018-05-18 10:42:28 |
| 11263 | 5765 | 2 | 2018-05-18 10:45:26 |
| 11264 | 5755 | 3 | 2018-05-18 12:40:50 |
| 11265 | 5754 | 3 | 2018-05-18 12:53:36 |
| 11266 | 5755 | 2 | 2018-05-18 13:11:27 |
| 11267 | 5754 | 1 | 2018-05-18 14:18:06 |
| 11268 | 5801 | 3 | 2018-05-19 11:01:08 |
| 11269 | 5802 | 2 | 2018-05-19 15:24:46 |
| 11270 | 5678 | 2 | 2018-05-19 15:56:46 |
| 11271 | 5679 | 3 | 2018-05-19 15:59:14 |
| 11272 | 5681 | 3 | 2018-05-19 16:03:09 |
| 11273 | 5682 | 3 | 2018-05-19 16:07:29 |
| 11274 | 5680 | 3 | 2018-05-19 16:12:33 |
| 11275 | 5679 | 2 | 2018-05-19 16:35:32 |
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;