Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,076–13,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13076 | 6714 | 1 | 2018-09-16 13:39:29 |
| 13077 | 6713 | 1 | 2018-09-16 13:52:31 |
| 13078 | 6715 | 2 | 2018-09-16 14:00:35 |
| 13079 | 6719 | 2 | 2018-09-16 15:17:07 |
| 13080 | 6718 | 2 | 2018-09-16 15:27:01 |
| 13081 | 6719 | 3 | 2018-09-16 16:10:56 |
| 13082 | 6718 | 3 | 2018-09-16 17:00:26 |
| 13083 | 6720 | 2 | 2018-09-17 10:19:07 |
| 13084 | 6722 | 2 | 2018-09-17 11:25:10 |
| 13085 | 6723 | 2 | 2018-09-17 11:25:52 |
| 13086 | 6721 | 1 | 2018-09-17 11:26:33 |
| 13087 | 6724 | 1 | 2018-09-17 11:34:19 |
| 13088 | 6726 | 2 | 2018-09-17 11:34:28 |
| 13089 | 6725 | 2 | 2018-09-17 11:36:18 |
| 13090 | 6722 | 1 | 2018-09-17 12:05:32 |
| 13091 | 6725 | 3 | 2018-09-17 12:17:03 |
| 13092 | 6722 | 3 | 2018-09-17 12:31:24 |
| 13093 | 6726 | 3 | 2018-09-17 12:33:19 |
| 13094 | 6723 | 1 | 2018-09-17 12:34:30 |
| 13095 | 6725 | 2 | 2018-09-17 13:21:13 |
| 13096 | 6723 | 3 | 2018-09-17 13:48:07 |
| 13097 | 6726 | 2 | 2018-09-17 13:53:26 |
| 13098 | 6687 | 2 | 2018-09-18 11:14:07 |
| 13099 | 6686 | 2 | 2018-09-18 11:17:46 |
| 13100 | 6708 | 3 | 2018-09-18 11:53:48 |
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;