Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,351–12,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12351 | 6447 | 3 | 2018-08-10 16:16:29 |
| 12352 | 6447 | 1 | 2018-08-10 17:45:00 |
| 12353 | 6409 | 3 | 2018-08-11 10:55:40 |
| 12354 | 6408 | 2 | 2018-08-11 11:06:13 |
| 12355 | 6453 | 2 | 2018-08-11 11:52:05 |
| 12356 | 6408 | 1 | 2018-08-11 12:00:08 |
| 12357 | 6409 | 1 | 2018-08-11 12:03:10 |
| 12358 | 6453 | 1 | 2018-08-11 13:09:33 |
| 12359 | 6461 | 2 | 2018-08-12 10:30:43 |
| 12360 | 6460 | 2 | 2018-08-12 10:31:29 |
| 12361 | 6339 | 2 | 2018-08-12 11:25:48 |
| 12362 | 6450 | 2 | 2018-08-12 13:41:09 |
| 12363 | 6449 | 1 | 2018-08-12 13:51:50 |
| 12364 | 6444 | 2 | 2018-08-12 15:07:23 |
| 12365 | 6446 | 2 | 2018-08-12 15:08:25 |
| 12366 | 6450 | 1 | 2018-08-12 15:11:13 |
| 12367 | 6443 | 2 | 2018-08-12 15:17:20 |
| 12368 | 6445 | 2 | 2018-08-12 15:19:30 |
| 12369 | 6446 | 3 | 2018-08-12 15:39:33 |
| 12370 | 6436 | 2 | 2018-08-12 15:42:50 |
| 12371 | 6444 | 3 | 2018-08-12 15:47:23 |
| 12372 | 6435 | 2 | 2018-08-12 15:56:00 |
| 12373 | 6450 | 2 | 2018-08-12 15:59:35 |
| 12374 | 6443 | 3 | 2018-08-12 16:08:49 |
| 12375 | 6445 | 3 | 2018-08-12 16:10:58 |
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;