Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 176–200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 176 | 235 | 1 | 2015-04-04 09:50:09 |
| 177 | 231 | 3 | 2015-04-04 10:00:50 |
| 178 | 232 | 3 | 2015-04-04 10:08:11 |
| 179 | 222 | 3 | 2015-04-04 10:30:32 |
| 180 | 232 | 1 | 2015-04-04 10:42:13 |
| 181 | 231 | 1 | 2015-04-04 10:46:41 |
| 182 | 232 | 3 | 2015-04-04 11:11:45 |
| 183 | 222 | 1 | 2015-04-04 11:34:46 |
| 184 | 231 | 3 | 2015-04-04 11:42:41 |
| 185 | 222 | 2 | 2015-04-04 12:42:08 |
| 186 | 239 | 1 | 2015-04-04 14:35:14 |
| 187 | 237 | 1 | 2015-04-04 14:38:47 |
| 188 | 238 | 1 | 2015-04-04 14:44:21 |
| 189 | 237 | 3 | 2015-04-04 15:18:36 |
| 190 | 239 | 3 | 2015-04-04 15:41:28 |
| 191 | 238 | 3 | 2015-04-04 15:48:05 |
| 192 | 241 | 1 | 2015-04-05 09:41:17 |
| 193 | 242 | 3 | 2015-04-05 09:45:00 |
| 194 | 244 | 1 | 2015-04-05 10:00:47 |
| 195 | 243 | 2 | 2015-04-05 10:03:12 |
| 196 | 245 | 2 | 2015-04-05 10:07:20 |
| 197 | 246 | 2 | 2015-04-05 10:11:00 |
| 198 | 245 | 1 | 2015-04-05 10:36:39 |
| 199 | 242 | 2 | 2015-04-05 11:03:10 |
| 200 | 246 | 1 | 2015-04-05 11:04:14 |
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;