Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,026–13,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13026 | 6614 | 2 | 2018-09-05 11:29:48 |
| 13027 | 6615 | 2 | 2018-09-05 11:33:41 |
| 13028 | 6617 | 1 | 2018-09-05 11:35:29 |
| 13029 | 6616 | 3 | 2018-09-05 11:47:26 |
| 13030 | 6618 | 2 | 2018-09-05 11:49:15 |
| 13031 | 6617 | 2 | 2018-09-05 12:21:39 |
| 13032 | 6615 | 3 | 2018-09-05 12:51:24 |
| 13033 | 6614 | 3 | 2018-09-05 12:53:12 |
| 13034 | 6618 | 1 | 2018-09-05 13:17:50 |
| 13035 | 6617 | 3 | 2018-09-05 13:20:12 |
| 13036 | 6615 | 1 | 2018-09-05 13:48:30 |
| 13037 | 6614 | 1 | 2018-09-05 14:28:21 |
| 13038 | 6615 | 2 | 2018-09-05 14:41:36 |
| 13039 | 6614 | 2 | 2018-09-05 15:14:06 |
| 13040 | 6619 | 2 | 2018-09-06 14:36:50 |
| 13041 | 6620 | 2 | 2018-09-06 14:46:39 |
| 13042 | 6685 | 1 | 2018-09-10 09:49:49 |
| 13043 | 6688 | 1 | 2018-09-11 11:46:01 |
| 13044 | 6689 | 1 | 2018-09-11 11:52:32 |
| 13045 | 6688 | 3 | 2018-09-11 12:24:29 |
| 13046 | 6689 | 3 | 2018-09-11 12:36:08 |
| 13047 | 6587 | 2 | 2018-09-11 12:48:06 |
| 13048 | 6688 | 1 | 2018-09-11 13:28:24 |
| 13049 | 6689 | 1 | 2018-09-11 13:44:34 |
| 13050 | 6587 | 3 | 2018-09-11 14:01:05 |
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;