Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,101–8,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8101 | 4167 | 3 | 2017-07-04 13:10:06 |
| 8102 | 4167 | 2 | 2017-07-04 14:20:31 |
| 8103 | 4168 | 2 | 2017-07-04 14:39:43 |
| 8104 | 4168 | 3 | 2017-07-04 15:26:40 |
| 8105 | 4058 | 2 | 2017-07-05 10:04:19 |
| 8106 | 4145 | 2 | 2017-07-05 10:51:02 |
| 8107 | 4144 | 2 | 2017-07-05 10:53:20 |
| 8108 | 4147 | 2 | 2017-07-05 10:59:07 |
| 8109 | 4146 | 2 | 2017-07-05 10:59:26 |
| 8110 | 4058 | 3 | 2017-07-05 11:05:19 |
| 8111 | 4174 | 2 | 2017-07-05 11:19:55 |
| 8112 | 4058 | 1 | 2017-07-05 11:43:22 |
| 8113 | 4144 | 3 | 2017-07-05 11:58:54 |
| 8114 | 4147 | 3 | 2017-07-05 11:59:57 |
| 8115 | 4170 | 2 | 2017-07-05 12:04:09 |
| 8116 | 4169 | 2 | 2017-07-05 12:11:40 |
| 8117 | 4145 | 3 | 2017-07-05 12:23:32 |
| 8118 | 4146 | 3 | 2017-07-05 12:25:07 |
| 8119 | 4147 | 1 | 2017-07-05 12:39:41 |
| 8120 | 4145 | 2 | 2017-07-05 13:10:51 |
| 8121 | 4058 | 3 | 2017-07-05 13:11:14 |
| 8122 | 4146 | 2 | 2017-07-05 13:18:54 |
| 8123 | 4144 | 2 | 2017-07-05 13:21:43 |
| 8124 | 4169 | 1 | 2017-07-05 13:39:35 |
| 8125 | 4175 | 2 | 2017-07-05 14:04:45 |
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;