Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,751–10,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10751 | 5566 | 3 | 2018-04-14 11:35:24 |
| 10752 | 5564 | 3 | 2018-04-14 11:41:10 |
| 10753 | 5567 | 3 | 2018-04-14 12:18:17 |
| 10754 | 5565 | 3 | 2018-04-14 12:30:32 |
| 10755 | 5566 | 1 | 2018-04-14 12:42:50 |
| 10756 | 5564 | 1 | 2018-04-14 12:59:22 |
| 10757 | 5567 | 1 | 2018-04-14 13:32:42 |
| 10758 | 5565 | 1 | 2018-04-14 13:35:36 |
| 10759 | 5544 | 2 | 2018-04-15 12:07:16 |
| 10760 | 5544 | 3 | 2018-04-15 13:21:28 |
| 10761 | 5544 | 1 | 2018-04-15 14:30:41 |
| 10762 | 5572 | 2 | 2018-04-15 14:46:36 |
| 10763 | 5523 | 3 | 2018-04-15 15:56:18 |
| 10764 | 5523 | 1 | 2018-04-15 17:05:26 |
| 10765 | 5501 | 2 | 2018-04-16 09:38:26 |
| 10766 | 5501 | 1 | 2018-04-16 10:54:58 |
| 10767 | 5501 | 3 | 2018-04-16 12:29:29 |
| 10768 | 5522 | 2 | 2018-04-16 14:50:03 |
| 10769 | 5372 | 2 | 2018-04-16 16:40:19 |
| 10770 | 5371 | 1 | 2018-04-16 16:41:05 |
| 10771 | 5557 | 2 | 2018-04-17 13:09:44 |
| 10772 | 5557 | 3 | 2018-04-17 13:36:57 |
| 10773 | 5562 | 2 | 2018-04-18 09:46:04 |
| 10774 | 5563 | 2 | 2018-04-18 09:47:09 |
| 10775 | 5563 | 3 | 2018-04-18 10:43:11 |
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;