Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,251–14,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14251 | 7282 | 2 | 2018-12-16 16:57:39 |
| 14252 | 7253 | 3 | 2018-12-16 17:36:16 |
| 14253 | 7282 | 3 | 2018-12-16 17:47:24 |
| 14254 | 7198 | 2 | 2018-12-18 09:53:27 |
| 14255 | 7283 | 2 | 2018-12-18 10:14:03 |
| 14256 | 7198 | 3 | 2018-12-18 10:25:56 |
| 14257 | 7283 | 3 | 2018-12-18 11:27:21 |
| 14258 | 7247 | 2 | 2018-12-18 11:28:09 |
| 14259 | 7283 | 1 | 2018-12-18 12:53:26 |
| 14260 | 7177 | 3 | 2018-12-18 14:29:14 |
| 14261 | 7176 | 2 | 2018-12-18 14:29:58 |
| 14262 | 7285 | 3 | 2018-12-19 09:26:58 |
| 14263 | 7286 | 3 | 2018-12-19 09:29:50 |
| 14264 | 7279 | 2 | 2018-12-19 12:48:57 |
| 14265 | 7279 | 1 | 2018-12-19 13:31:23 |
| 14266 | 7289 | 1 | 2018-12-19 14:24:16 |
| 14267 | 7289 | 3 | 2018-12-19 15:00:04 |
| 14268 | 7291 | 2 | 2018-12-20 09:48:56 |
| 14269 | 7290 | 2 | 2018-12-20 09:54:43 |
| 14270 | 7280 | 2 | 2018-12-20 10:54:36 |
| 14271 | 7280 | 3 | 2018-12-20 12:19:01 |
| 14272 | 7280 | 1 | 2018-12-20 13:03:55 |
| 14273 | 7337 | 1 | 2018-12-22 10:26:54 |
| 14274 | 7336 | 1 | 2018-12-22 10:27:09 |
| 14275 | 7339 | 1 | 2018-12-22 10:30:01 |
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;