Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,276–11,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11276 | 5681 | 2 | 2018-05-19 16:35:42 |
| 11277 | 5682 | 2 | 2018-05-19 17:10:34 |
| 11278 | 5678 | 3 | 2018-05-19 17:21:14 |
| 11279 | 5680 | 2 | 2018-05-19 17:46:09 |
| 11280 | 5652 | 2 | 2018-05-20 14:45:04 |
| 11281 | 5794 | 2 | 2018-05-21 13:03:14 |
| 11282 | 5793 | 2 | 2018-05-21 13:18:21 |
| 11283 | 5794 | 3 | 2018-05-21 13:34:59 |
| 11284 | 5793 | 3 | 2018-05-21 14:23:33 |
| 11285 | 5807 | 2 | 2018-05-21 15:41:40 |
| 11286 | 5808 | 2 | 2018-05-21 15:45:20 |
| 11287 | 5807 | 3 | 2018-05-21 16:56:42 |
| 11288 | 5808 | 3 | 2018-05-21 17:20:43 |
| 11289 | 5577 | 1 | 2018-05-22 11:02:53 |
| 11290 | 5576 | 2 | 2018-05-22 11:13:08 |
| 11291 | 5574 | 3 | 2018-05-22 11:14:17 |
| 11292 | 5575 | 2 | 2018-05-22 11:14:46 |
| 11293 | 5575 | 3 | 2018-05-22 11:51:33 |
| 11294 | 5577 | 3 | 2018-05-22 12:08:32 |
| 11295 | 5576 | 3 | 2018-05-22 12:20:47 |
| 11296 | 5577 | 1 | 2018-05-22 13:33:48 |
| 11297 | 5577 | 3 | 2018-05-22 14:34:25 |
| 11298 | 5770 | 2 | 2018-05-23 11:00:39 |
| 11299 | 5772 | 2 | 2018-05-23 11:04:15 |
| 11300 | 5769 | 1 | 2018-05-23 11:11:45 |
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;