Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,451–14,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14451 | 7353 | 3 | 2019-01-09 14:30:45 |
| 14452 | 7379 | 1 | 2019-01-10 11:17:41 |
| 14453 | 7379 | 2 | 2019-01-10 11:56:54 |
| 14454 | 7382 | 2 | 2019-01-12 10:19:48 |
| 14455 | 7385 | 2 | 2019-01-12 10:53:29 |
| 14456 | 7386 | 1 | 2019-01-12 11:04:53 |
| 14457 | 7254 | 1 | 2019-01-12 11:05:01 |
| 14458 | 7382 | 3 | 2019-01-12 11:05:56 |
| 14459 | 7255 | 1 | 2019-01-12 11:06:48 |
| 14460 | 7387 | 1 | 2019-01-12 11:09:24 |
| 14461 | 7385 | 1 | 2019-01-12 11:37:20 |
| 14462 | 7255 | 2 | 2019-01-12 11:40:03 |
| 14463 | 7254 | 2 | 2019-01-12 12:20:02 |
| 14464 | 7386 | 2 | 2019-01-12 12:24:51 |
| 14465 | 7255 | 3 | 2019-01-12 12:28:43 |
| 14466 | 7387 | 2 | 2019-01-12 12:41:52 |
| 14467 | 7386 | 1 | 2019-01-12 12:53:19 |
| 14468 | 7387 | 1 | 2019-01-12 13:16:46 |
| 14469 | 7254 | 3 | 2019-01-12 13:34:15 |
| 14470 | 7386 | 2 | 2019-01-12 13:56:39 |
| 14471 | 7387 | 2 | 2019-01-12 14:24:09 |
| 14472 | 7444 | 1 | 2019-01-14 13:51:59 |
| 14473 | 7445 | 1 | 2019-01-14 14:08:09 |
| 14474 | 7444 | 3 | 2019-01-14 14:29:17 |
| 14475 | 7445 | 3 | 2019-01-14 15:26:02 |
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;