Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,301–6,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6301 | 3322 | 3 | 2016-12-29 11:47:54 |
| 6302 | 3324 | 3 | 2016-12-29 11:48:30 |
| 6303 | 3323 | 2 | 2016-12-29 11:55:34 |
| 6304 | 3322 | 1 | 2016-12-29 12:38:23 |
| 6305 | 3323 | 3 | 2016-12-29 12:44:18 |
| 6306 | 3324 | 2 | 2016-12-29 13:07:51 |
| 6307 | 3323 | 2 | 2016-12-29 13:47:41 |
| 6308 | 3324 | 1 | 2016-12-29 13:52:08 |
| 6309 | 3330 | 1 | 2016-12-30 11:57:16 |
| 6310 | 3331 | 1 | 2016-12-30 11:59:20 |
| 6311 | 3330 | 3 | 2016-12-30 12:27:04 |
| 6312 | 3331 | 3 | 2016-12-30 13:04:54 |
| 6313 | 3330 | 1 | 2016-12-30 13:52:09 |
| 6314 | 3331 | 1 | 2016-12-30 13:59:20 |
| 6315 | 3332 | 2 | 2016-12-30 14:55:13 |
| 6316 | 3327 | 2 | 2016-12-31 13:05:49 |
| 6317 | 3325 | 3 | 2016-12-31 13:06:10 |
| 6318 | 3328 | 2 | 2016-12-31 13:12:48 |
| 6319 | 3329 | 2 | 2016-12-31 13:13:47 |
| 6320 | 3325 | 2 | 2016-12-31 14:28:05 |
| 6321 | 3325 | 3 | 2016-12-31 15:17:21 |
| 6322 | 3339 | 2 | 2017-01-02 14:45:56 |
| 6323 | 3339 | 3 | 2017-01-02 16:13:02 |
| 6324 | 3339 | 1 | 2017-01-02 16:45:32 |
| 6325 | 3248 | 3 | 2017-01-05 09:42:56 |
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;