Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,726–10,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10726 | 5338 | 2 | 2018-04-12 15:17:23 |
| 10727 | 5337 | 3 | 2018-04-12 15:42:15 |
| 10728 | 5556 | 1 | 2018-04-12 15:51:08 |
| 10729 | 5338 | 3 | 2018-04-12 16:30:41 |
| 10730 | 5555 | 1 | 2018-04-12 16:31:28 |
| 10731 | 5556 | 3 | 2018-04-12 17:14:01 |
| 10732 | 5555 | 3 | 2018-04-12 17:47:41 |
| 10733 | 5559 | 2 | 2018-04-13 10:26:05 |
| 10734 | 5558 | 2 | 2018-04-13 10:37:57 |
| 10735 | 5560 | 2 | 2018-04-13 10:42:24 |
| 10736 | 5559 | 3 | 2018-04-13 11:01:45 |
| 10737 | 5560 | 3 | 2018-04-13 11:44:07 |
| 10738 | 5558 | 3 | 2018-04-13 12:04:55 |
| 10739 | 5559 | 2 | 2018-04-13 12:12:51 |
| 10740 | 5560 | 2 | 2018-04-13 12:58:40 |
| 10741 | 5558 | 2 | 2018-04-13 13:39:20 |
| 10742 | 5549 | 2 | 2018-04-13 16:54:19 |
| 10743 | 5551 | 2 | 2018-04-13 16:57:43 |
| 10744 | 5550 | 2 | 2018-04-13 17:01:49 |
| 10745 | 5564 | 2 | 2018-04-14 10:53:31 |
| 10746 | 5565 | 2 | 2018-04-14 10:55:53 |
| 10747 | 5566 | 2 | 2018-04-14 10:59:51 |
| 10748 | 5567 | 2 | 2018-04-14 11:02:49 |
| 10749 | 5568 | 2 | 2018-04-14 11:04:02 |
| 10750 | 5568 | 1 | 2018-04-14 11:32:17 |
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;