Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,001–5,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5001 | 2535 | 3 | 2016-07-21 17:03:54 |
| 5002 | 2538 | 2 | 2016-07-22 11:41:06 |
| 5003 | 2537 | 3 | 2016-07-22 11:47:21 |
| 5004 | 2538 | 3 | 2016-07-22 12:32:30 |
| 5005 | 2519 | 1 | 2016-07-22 13:08:17 |
| 5006 | 2540 | 2 | 2016-07-22 13:35:22 |
| 5007 | 2539 | 3 | 2016-07-22 13:46:22 |
| 5008 | 2540 | 3 | 2016-07-22 14:16:35 |
| 5009 | 2519 | 3 | 2016-07-22 14:39:58 |
| 5010 | 2519 | 1 | 2016-07-22 15:47:32 |
| 5011 | 2519 | 2 | 2016-07-22 16:42:24 |
| 5012 | 2548 | 2 | 2016-07-23 14:45:24 |
| 5013 | 2549 | 2 | 2016-07-23 14:56:53 |
| 5014 | 2549 | 3 | 2016-07-23 15:44:04 |
| 5015 | 2548 | 3 | 2016-07-23 16:20:20 |
| 5016 | 2450 | 2 | 2016-07-24 10:07:39 |
| 5017 | 2450 | 3 | 2016-07-24 11:12:43 |
| 5018 | 2522 | 1 | 2016-07-24 11:15:11 |
| 5019 | 2522 | 3 | 2016-07-24 12:48:01 |
| 5020 | 2522 | 1 | 2016-07-24 14:07:02 |
| 5021 | 2545 | 1 | 2016-07-25 10:56:53 |
| 5022 | 2546 | 2 | 2016-07-25 11:03:36 |
| 5023 | 2457 | 2 | 2016-07-25 11:49:26 |
| 5024 | 2545 | 2 | 2016-07-25 12:16:00 |
| 5025 | 2457 | 3 | 2016-07-25 13:04:50 |
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;