Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,001–6,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6001 | 3030 | 3 | 2016-11-23 10:45:43 |
| 6002 | 3030 | 2 | 2016-11-23 11:30:12 |
| 6003 | 3029 | 3 | 2016-11-23 11:44:25 |
| 6004 | 3028 | 3 | 2016-11-23 11:50:26 |
| 6005 | 3029 | 2 | 2016-11-23 13:13:38 |
| 6006 | 3028 | 2 | 2016-11-23 13:18:58 |
| 6007 | 3049 | 2 | 2016-11-24 10:33:43 |
| 6008 | 3050 | 2 | 2016-11-24 10:38:31 |
| 6009 | 3051 | 2 | 2016-11-24 10:39:53 |
| 6010 | 3052 | 1 | 2016-11-24 11:34:21 |
| 6011 | 3052 | 2 | 2016-11-24 12:16:41 |
| 6012 | 3052 | 1 | 2016-11-24 13:02:32 |
| 6013 | 3012 | 2 | 2016-11-24 14:46:23 |
| 6014 | 3053 | 2 | 2016-11-25 10:24:37 |
| 6015 | 3054 | 2 | 2016-11-25 10:27:33 |
| 6016 | 3053 | 3 | 2016-11-25 11:29:02 |
| 6017 | 3054 | 3 | 2016-11-25 11:35:51 |
| 6018 | 3054 | 2 | 2016-11-25 12:13:19 |
| 6019 | 3053 | 2 | 2016-11-25 12:38:16 |
| 6020 | 3060 | 2 | 2016-11-25 14:51:30 |
| 6021 | 3059 | 2 | 2016-11-25 14:54:05 |
| 6022 | 3059 | 1 | 2016-11-25 15:46:37 |
| 6023 | 3059 | 2 | 2016-11-25 16:46:03 |
| 6024 | 2949 | 2 | 2016-11-26 11:08:03 |
| 6025 | 2947 | 2 | 2016-11-26 11:10:03 |
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;