Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,351–11,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11351 | 5823 | 1 | 2018-05-27 11:24:07 |
| 11352 | 5824 | 1 | 2018-05-27 11:30:44 |
| 11353 | 5824 | 2 | 2018-05-27 12:47:53 |
| 11354 | 5823 | 2 | 2018-05-27 12:57:40 |
| 11355 | 5830 | 3 | 2018-05-28 10:37:36 |
| 11356 | 5829 | 3 | 2018-05-28 10:39:30 |
| 11357 | 5829 | 2 | 2018-05-28 11:11:20 |
| 11358 | 5521 | 2 | 2018-05-28 11:56:32 |
| 11359 | 5830 | 2 | 2018-05-28 12:01:21 |
| 11360 | 5831 | 2 | 2018-05-28 12:27:00 |
| 11361 | 5831 | 3 | 2018-05-28 13:07:03 |
| 11362 | 5831 | 2 | 2018-05-28 14:02:09 |
| 11363 | 5869 | 3 | 2018-05-30 09:53:13 |
| 11364 | 5868 | 2 | 2018-05-30 09:54:30 |
| 11365 | 5797 | 2 | 2018-05-30 11:14:36 |
| 11366 | 5798 | 2 | 2018-05-30 11:16:49 |
| 11367 | 5870 | 2 | 2018-05-30 11:52:13 |
| 11368 | 5871 | 1 | 2018-05-30 11:56:35 |
| 11369 | 5870 | 1 | 2018-05-30 13:00:55 |
| 11370 | 5871 | 2 | 2018-05-30 13:11:16 |
| 11371 | 5871 | 3 | 2018-05-30 13:59:07 |
| 11372 | 5739 | 2 | 2018-05-31 10:05:52 |
| 11373 | 5872 | 2 | 2018-05-31 10:11:47 |
| 11374 | 5738 | 3 | 2018-05-31 10:19:53 |
| 11375 | 5738 | 1 | 2018-05-31 10:57:49 |
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;