Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,351–10,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10351 | 5310 | 2 | 2018-03-06 13:05:41 |
| 10352 | 5312 | 1 | 2018-03-06 13:10:27 |
| 10353 | 5310 | 3 | 2018-03-06 13:35:24 |
| 10354 | 5315 | 2 | 2018-03-06 13:51:33 |
| 10355 | 5310 | 1 | 2018-03-06 14:25:56 |
| 10356 | 5311 | 3 | 2018-03-06 14:30:22 |
| 10357 | 5311 | 1 | 2018-03-06 15:40:03 |
| 10358 | 5347 | 2 | 2018-03-07 11:16:53 |
| 10359 | 5348 | 3 | 2018-03-07 11:29:00 |
| 10360 | 5347 | 1 | 2018-03-07 12:06:29 |
| 10361 | 5348 | 1 | 2018-03-07 12:18:58 |
| 10362 | 5347 | 3 | 2018-03-07 12:42:43 |
| 10363 | 5348 | 2 | 2018-03-07 13:29:37 |
| 10364 | 5348 | 1 | 2018-03-07 14:59:37 |
| 10365 | 5349 | 3 | 2018-03-08 11:36:40 |
| 10366 | 5355 | 1 | 2018-03-09 12:38:35 |
| 10367 | 5354 | 1 | 2018-03-09 12:41:50 |
| 10368 | 5353 | 1 | 2018-03-09 12:46:08 |
| 10369 | 5356 | 1 | 2018-03-09 12:47:32 |
| 10370 | 5358 | 2 | 2018-03-10 11:04:57 |
| 10371 | 5345 | 2 | 2018-03-10 11:30:28 |
| 10372 | 5346 | 2 | 2018-03-10 11:35:11 |
| 10373 | 5344 | 2 | 2018-03-10 11:35:44 |
| 10374 | 5345 | 3 | 2018-03-10 12:20:56 |
| 10375 | 5346 | 3 | 2018-03-10 12:25:05 |
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;