Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 151–175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 151 | 217 | 2 | 2015-03-30 11:34:45 |
| 152 | 218 | 2 | 2015-03-30 11:40:43 |
| 153 | 217 | 3 | 2015-03-30 12:12:11 |
| 154 | 218 | 3 | 2015-03-30 12:27:16 |
| 155 | 218 | 1 | 2015-03-30 13:35:48 |
| 156 | 217 | 1 | 2015-03-30 13:47:24 |
| 157 | 108 | 2 | 2015-03-31 09:32:04 |
| 158 | 109 | 2 | 2015-03-31 09:33:32 |
| 159 | 171 | 1 | 2015-03-31 14:22:22 |
| 160 | 170 | 2 | 2015-03-31 14:28:44 |
| 161 | 170 | 1 | 2015-03-31 15:56:01 |
| 162 | 221 | 3 | 2015-04-01 10:10:56 |
| 163 | 223 | 3 | 2015-04-01 14:28:33 |
| 164 | 226 | 3 | 2015-04-01 14:28:47 |
| 165 | 225 | 1 | 2015-04-01 14:36:27 |
| 166 | 224 | 3 | 2015-04-01 14:38:13 |
| 167 | 223 | 2 | 2015-04-01 15:03:28 |
| 168 | 224 | 2 | 2015-04-01 15:06:32 |
| 169 | 225 | 2 | 2015-04-01 15:30:45 |
| 170 | 226 | 2 | 2015-04-01 15:33:40 |
| 171 | 224 | 1 | 2015-04-01 15:40:14 |
| 172 | 226 | 1 | 2015-04-01 16:03:26 |
| 173 | 223 | 1 | 2015-04-01 16:30:28 |
| 174 | 230 | 3 | 2015-04-02 15:47:19 |
| 175 | 236 | 1 | 2015-04-04 09:50:01 |
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;