Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,376–8,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8376 | 4324 | 1 | 2017-08-05 11:11:43 |
| 8377 | 4324 | 3 | 2017-08-05 11:52:34 |
| 8378 | 4348 | 3 | 2017-08-05 15:06:41 |
| 8379 | 4349 | 3 | 2017-08-05 15:13:13 |
| 8380 | 4348 | 2 | 2017-08-05 15:36:35 |
| 8381 | 4349 | 2 | 2017-08-05 16:21:31 |
| 8382 | 4004 | 1 | 2017-08-06 09:36:18 |
| 8383 | 4350 | 3 | 2017-08-06 10:40:35 |
| 8384 | 4004 | 3 | 2017-08-06 10:58:20 |
| 8385 | 4352 | 1 | 2017-08-06 11:23:22 |
| 8386 | 4351 | 2 | 2017-08-06 11:27:29 |
| 8387 | 4004 | 1 | 2017-08-06 11:28:46 |
| 8388 | 4350 | 2 | 2017-08-06 12:04:49 |
| 8389 | 4352 | 3 | 2017-08-06 12:25:23 |
| 8390 | 4325 | 2 | 2017-08-06 12:32:58 |
| 8391 | 4326 | 2 | 2017-08-06 12:36:23 |
| 8392 | 4327 | 2 | 2017-08-06 12:36:52 |
| 8393 | 4350 | 1 | 2017-08-06 12:41:23 |
| 8394 | 4351 | 1 | 2017-08-06 12:47:25 |
| 8395 | 4325 | 3 | 2017-08-06 13:00:33 |
| 8396 | 4326 | 3 | 2017-08-06 13:03:27 |
| 8397 | 4351 | 2 | 2017-08-06 13:40:25 |
| 8398 | 4327 | 3 | 2017-08-06 13:44:51 |
| 8399 | 4326 | 2 | 2017-08-06 13:53:04 |
| 8400 | 4325 | 2 | 2017-08-06 13:55:32 |
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;