Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,351–13,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13351 | 6533 | 2 | 2018-10-05 14:36:47 |
| 13352 | 6540 | 2 | 2018-10-05 14:40:19 |
| 13353 | 6548 | 2 | 2018-10-05 14:43:58 |
| 13354 | 6528 | 2 | 2018-10-05 14:49:37 |
| 13355 | 6550 | 2 | 2018-10-05 14:55:50 |
| 13356 | 6850 | 3 | 2018-10-06 09:32:38 |
| 13357 | 6851 | 3 | 2018-10-06 09:38:32 |
| 13358 | 6853 | 2 | 2018-10-06 10:50:41 |
| 13359 | 6852 | 2 | 2018-10-06 11:04:13 |
| 13360 | 6852 | 3 | 2018-10-06 11:44:20 |
| 13361 | 6853 | 1 | 2018-10-06 12:11:41 |
| 13362 | 6853 | 3 | 2018-10-06 13:35:43 |
| 13363 | 6763 | 2 | 2018-10-06 15:32:54 |
| 13364 | 6763 | 3 | 2018-10-06 16:38:47 |
| 13365 | 6858 | 2 | 2018-10-07 12:14:56 |
| 13366 | 6860 | 2 | 2018-10-07 12:16:37 |
| 13367 | 6859 | 2 | 2018-10-07 12:18:59 |
| 13368 | 6859 | 1 | 2018-10-07 13:13:52 |
| 13369 | 6860 | 1 | 2018-10-07 13:17:23 |
| 13370 | 6858 | 1 | 2018-10-07 13:27:31 |
| 13371 | 6862 | 1 | 2018-10-07 14:50:52 |
| 13372 | 6861 | 1 | 2018-10-07 14:52:49 |
| 13373 | 6862 | 3 | 2018-10-07 15:34:44 |
| 13374 | 6829 | 2 | 2018-10-07 16:14:25 |
| 13375 | 6830 | 2 | 2018-10-07 16:21:08 |
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;