Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,151–6,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6151 | 3239 | 2 | 2016-12-19 15:21:06 |
| 6152 | 3239 | 1 | 2016-12-19 16:25:39 |
| 6153 | 3176 | 2 | 2016-12-21 11:56:25 |
| 6154 | 3175 | 2 | 2016-12-21 11:59:04 |
| 6155 | 3174 | 2 | 2016-12-21 12:08:04 |
| 6156 | 3175 | 3 | 2016-12-21 13:21:29 |
| 6157 | 3242 | 3 | 2016-12-23 09:39:00 |
| 6158 | 3243 | 3 | 2016-12-23 09:49:17 |
| 6159 | 3242 | 1 | 2016-12-23 10:47:41 |
| 6160 | 3243 | 1 | 2016-12-23 11:06:57 |
| 6161 | 3245 | 3 | 2016-12-23 14:33:20 |
| 6162 | 3246 | 3 | 2016-12-23 14:38:38 |
| 6163 | 3247 | 3 | 2016-12-23 14:43:38 |
| 6164 | 3244 | 3 | 2016-12-23 14:44:20 |
| 6165 | 3251 | 2 | 2016-12-24 10:39:26 |
| 6166 | 3252 | 2 | 2016-12-24 10:40:51 |
| 6167 | 3149 | 2 | 2016-12-24 12:26:50 |
| 6168 | 3149 | 1 | 2016-12-24 13:32:47 |
| 6169 | 3307 | 1 | 2016-12-25 12:34:32 |
| 6170 | 3304 | 1 | 2016-12-25 12:35:36 |
| 6171 | 3305 | 1 | 2016-12-25 12:43:19 |
| 6172 | 3303 | 2 | 2016-12-25 12:44:13 |
| 6173 | 3306 | 1 | 2016-12-25 12:46:28 |
| 6174 | 3303 | 3 | 2016-12-25 13:11:18 |
| 6175 | 3153 | 1 | 2016-12-25 13:36:36 |
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;