Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,326–11,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11326 | 5816 | 3 | 2018-05-24 15:34:06 |
| 11327 | 5815 | 2 | 2018-05-24 16:22:31 |
| 11328 | 5816 | 2 | 2018-05-24 16:48:11 |
| 11329 | 5809 | 1 | 2018-05-24 16:59:20 |
| 11330 | 5809 | 3 | 2018-05-24 17:27:56 |
| 11331 | 5787 | 3 | 2018-05-25 10:20:00 |
| 11332 | 5787 | 1 | 2018-05-25 11:37:55 |
| 11333 | 5773 | 1 | 2018-05-25 12:13:18 |
| 11334 | 5774 | 1 | 2018-05-25 12:13:26 |
| 11335 | 5787 | 3 | 2018-05-25 12:51:12 |
| 11336 | 5774 | 2 | 2018-05-25 13:03:22 |
| 11337 | 5773 | 2 | 2018-05-25 13:05:27 |
| 11338 | 5805 | 2 | 2018-05-25 13:25:06 |
| 11339 | 5803 | 2 | 2018-05-25 13:27:30 |
| 11340 | 5806 | 1 | 2018-05-25 13:27:36 |
| 11341 | 5804 | 2 | 2018-05-25 13:31:41 |
| 11342 | 5818 | 3 | 2018-05-25 15:11:01 |
| 11343 | 5819 | 3 | 2018-05-26 11:06:34 |
| 11344 | 5820 | 3 | 2018-05-26 11:16:47 |
| 11345 | 5686 | 2 | 2018-05-26 11:21:35 |
| 11346 | 5686 | 3 | 2018-05-26 11:50:53 |
| 11347 | 5821 | 1 | 2018-05-26 12:14:01 |
| 11348 | 5820 | 1 | 2018-05-26 12:21:58 |
| 11349 | 5821 | 2 | 2018-05-26 13:40:36 |
| 11350 | 5821 | 3 | 2018-05-26 14:31:00 |
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;