Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,101–16,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16101 | 8267 | 2 | 2019-05-24 14:28:52 |
| 16102 | 8046 | 3 | 2019-05-24 14:33:29 |
| 16103 | 8272 | 3 | 2019-05-24 15:45:57 |
| 16104 | 8271 | 3 | 2019-05-24 15:52:12 |
| 16105 | 8163 | 3 | 2019-05-24 16:36:12 |
| 16106 | 8271 | 1 | 2019-05-24 16:59:56 |
| 16107 | 8272 | 1 | 2019-05-24 17:13:27 |
| 16108 | 8271 | 3 | 2019-05-24 17:34:00 |
| 16109 | 8163 | 1 | 2019-05-24 17:45:29 |
| 16110 | 8177 | 1 | 2019-05-25 10:30:17 |
| 16111 | 8178 | 1 | 2019-05-25 10:35:53 |
| 16112 | 8178 | 3 | 2019-05-25 11:01:57 |
| 16113 | 8177 | 3 | 2019-05-25 11:57:59 |
| 16114 | 8259 | 2 | 2019-05-26 12:37:54 |
| 16115 | 8260 | 2 | 2019-05-26 12:44:48 |
| 16116 | 8261 | 2 | 2019-05-26 12:51:47 |
| 16117 | 8262 | 2 | 2019-05-26 12:51:54 |
| 16118 | 8261 | 1 | 2019-05-26 13:29:43 |
| 16119 | 8262 | 1 | 2019-05-26 13:30:18 |
| 16120 | 8260 | 1 | 2019-05-26 13:44:28 |
| 16121 | 8259 | 1 | 2019-05-26 13:51:49 |
| 16122 | 8262 | 2 | 2019-05-26 14:00:08 |
| 16123 | 8261 | 2 | 2019-05-26 14:12:38 |
| 16124 | 8260 | 2 | 2019-05-26 14:34:25 |
| 16125 | 8256 | 2 | 2019-05-26 15:08:32 |
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;