Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,651–8,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8651 | 4526 | 3 | 2017-08-30 09:56:12 |
| 8652 | 4526 | 2 | 2017-08-30 10:21:43 |
| 8653 | 4523 | 1 | 2017-08-30 10:27:00 |
| 8654 | 4525 | 3 | 2017-08-30 12:10:55 |
| 8655 | 4399 | 1 | 2017-09-01 10:34:46 |
| 8656 | 4396 | 2 | 2017-09-01 10:36:05 |
| 8657 | 4397 | 2 | 2017-09-01 10:37:03 |
| 8658 | 4398 | 2 | 2017-09-01 10:41:55 |
| 8659 | 4396 | 3 | 2017-09-01 11:26:36 |
| 8660 | 4397 | 3 | 2017-09-01 11:51:20 |
| 8661 | 4396 | 1 | 2017-09-01 11:52:46 |
| 8662 | 4399 | 3 | 2017-09-01 12:01:21 |
| 8663 | 4398 | 3 | 2017-09-01 12:02:16 |
| 8664 | 4524 | 2 | 2017-09-01 12:16:20 |
| 8665 | 4396 | 3 | 2017-09-01 12:25:08 |
| 8666 | 4398 | 1 | 2017-09-01 12:42:04 |
| 8667 | 4397 | 1 | 2017-09-01 12:56:14 |
| 8668 | 4399 | 2 | 2017-09-01 13:00:16 |
| 8669 | 4396 | 1 | 2017-09-01 13:21:52 |
| 8670 | 4398 | 3 | 2017-09-01 13:25:22 |
| 8671 | 4397 | 3 | 2017-09-01 14:00:57 |
| 8672 | 4398 | 1 | 2017-09-01 14:40:04 |
| 8673 | 4397 | 1 | 2017-09-01 15:00:20 |
| 8674 | 4378 | 1 | 2017-09-01 16:01:46 |
| 8675 | 4378 | 2 | 2017-09-01 16:33:29 |
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;