Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,301–12,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12301 | 6426 | 2 | 2018-08-09 13:56:37 |
| 12302 | 6427 | 2 | 2018-08-09 14:01:04 |
| 12303 | 6430 | 2 | 2018-08-09 14:03:31 |
| 12304 | 6433 | 1 | 2018-08-09 14:24:25 |
| 12305 | 6428 | 3 | 2018-08-09 14:26:00 |
| 12306 | 6432 | 1 | 2018-08-09 14:26:55 |
| 12307 | 6426 | 3 | 2018-08-09 14:26:59 |
| 12308 | 6429 | 2 | 2018-08-09 14:36:57 |
| 12309 | 6425 | 3 | 2018-08-09 14:37:34 |
| 12310 | 6430 | 1 | 2018-08-09 15:03:53 |
| 12311 | 6427 | 3 | 2018-08-09 15:09:47 |
| 12312 | 6431 | 1 | 2018-08-09 15:26:33 |
| 12313 | 6432 | 2 | 2018-08-09 15:30:37 |
| 12314 | 6433 | 2 | 2018-08-09 15:44:02 |
| 12315 | 6429 | 3 | 2018-08-09 15:44:52 |
| 12316 | 6430 | 2 | 2018-08-09 15:55:57 |
| 12317 | 6431 | 2 | 2018-08-09 16:52:20 |
| 12318 | 5602 | 2 | 2018-08-10 11:14:16 |
| 12319 | 5609 | 2 | 2018-08-10 11:14:47 |
| 12320 | 5605 | 2 | 2018-08-10 11:15:56 |
| 12321 | 5623 | 2 | 2018-08-10 11:16:26 |
| 12322 | 5629 | 2 | 2018-08-10 11:16:32 |
| 12323 | 5592 | 2 | 2018-08-10 11:16:39 |
| 12324 | 5620 | 2 | 2018-08-10 11:16:48 |
| 12325 | 5611 | 2 | 2018-08-10 11:17:11 |
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;