Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,101–4,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4101 | 2098 | 1 | 2016-05-02 13:18:40 |
| 4102 | 2096 | 1 | 2016-05-02 13:35:01 |
| 4103 | 2097 | 1 | 2016-05-02 13:40:42 |
| 4104 | 2134 | 1 | 2016-05-03 09:33:28 |
| 4105 | 2133 | 2 | 2016-05-03 09:35:41 |
| 4106 | 2134 | 2 | 2016-05-03 10:47:46 |
| 4107 | 2133 | 3 | 2016-05-03 10:57:59 |
| 4108 | 2133 | 1 | 2016-05-03 11:30:53 |
| 4109 | 2135 | 2 | 2016-05-03 14:04:13 |
| 4110 | 2135 | 1 | 2016-05-03 14:31:54 |
| 4111 | 2086 | 2 | 2016-05-04 09:51:17 |
| 4112 | 2086 | 1 | 2016-05-04 10:38:47 |
| 4113 | 2138 | 2 | 2016-05-04 10:57:20 |
| 4114 | 2137 | 2 | 2016-05-04 11:01:14 |
| 4115 | 2086 | 2 | 2016-05-04 11:38:01 |
| 4116 | 2139 | 1 | 2016-05-04 13:04:27 |
| 4117 | 2143 | 3 | 2016-05-06 14:07:47 |
| 4118 | 2143 | 1 | 2016-05-06 14:50:04 |
| 4119 | 2144 | 2 | 2016-05-06 16:15:26 |
| 4120 | 2109 | 2 | 2016-05-07 12:44:02 |
| 4121 | 2108 | 2 | 2016-05-07 12:44:22 |
| 4122 | 2110 | 2 | 2016-05-07 12:48:32 |
| 4123 | 2108 | 1 | 2016-05-07 13:22:46 |
| 4124 | 2145 | 2 | 2016-05-07 13:50:44 |
| 4125 | 2111 | 2 | 2016-05-07 14:20:27 |
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;