Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,551–5,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5551 | 2789 | 1 | 2016-09-24 15:17:27 |
| 5552 | 2843 | 1 | 2016-09-24 15:23:21 |
| 5553 | 2844 | 1 | 2016-09-24 15:26:41 |
| 5554 | 2789 | 3 | 2016-09-24 15:43:29 |
| 5555 | 2841 | 3 | 2016-09-24 15:43:31 |
| 5556 | 2844 | 3 | 2016-09-24 15:51:56 |
| 5557 | 2843 | 3 | 2016-09-24 16:00:39 |
| 5558 | 2840 | 2 | 2016-09-24 16:06:49 |
| 5559 | 2851 | 2 | 2016-09-27 10:09:46 |
| 5560 | 2851 | 3 | 2016-09-27 11:13:14 |
| 5561 | 2848 | 1 | 2016-09-28 10:53:43 |
| 5562 | 2850 | 1 | 2016-09-28 10:54:53 |
| 5563 | 2849 | 1 | 2016-09-28 10:55:49 |
| 5564 | 2832 | 3 | 2016-09-28 11:09:17 |
| 5565 | 2853 | 2 | 2016-09-28 11:12:21 |
| 5566 | 2850 | 2 | 2016-09-28 11:21:12 |
| 5567 | 2831 | 3 | 2016-09-28 11:21:22 |
| 5568 | 2852 | 2 | 2016-09-28 11:21:36 |
| 5569 | 2832 | 1 | 2016-09-28 11:47:44 |
| 5570 | 2850 | 3 | 2016-09-28 11:53:38 |
| 5571 | 2849 | 2 | 2016-09-28 12:07:33 |
| 5572 | 2848 | 2 | 2016-09-28 12:09:22 |
| 5573 | 2853 | 3 | 2016-09-28 12:34:07 |
| 5574 | 2831 | 1 | 2016-09-28 12:35:03 |
| 5575 | 2848 | 3 | 2016-09-28 13:12:08 |
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;