Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,701–8,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8701 | 4543 | 2 | 2017-09-04 16:45:21 |
| 8702 | 4543 | 1 | 2017-09-04 17:17:33 |
| 8703 | 4542 | 3 | 2017-09-04 17:33:21 |
| 8704 | 4468 | 1 | 2017-09-05 09:40:32 |
| 8705 | 4467 | 1 | 2017-09-05 09:47:27 |
| 8706 | 4468 | 2 | 2017-09-05 10:19:40 |
| 8707 | 4467 | 2 | 2017-09-05 11:07:15 |
| 8708 | 4502 | 3 | 2017-09-05 14:09:05 |
| 8709 | 4502 | 1 | 2017-09-05 15:24:50 |
| 8710 | 4549 | 3 | 2017-09-06 11:58:16 |
| 8711 | 4549 | 1 | 2017-09-06 13:15:34 |
| 8712 | 4551 | 2 | 2017-09-06 13:47:27 |
| 8713 | 4552 | 2 | 2017-09-06 13:49:43 |
| 8714 | 4549 | 3 | 2017-09-06 13:51:16 |
| 8715 | 4550 | 2 | 2017-09-06 14:01:41 |
| 8716 | 4550 | 3 | 2017-09-06 14:42:08 |
| 8717 | 4541 | 2 | 2017-09-06 14:48:37 |
| 8718 | 4540 | 2 | 2017-09-06 14:49:40 |
| 8719 | 4551 | 3 | 2017-09-06 15:02:59 |
| 8720 | 4552 | 3 | 2017-09-06 15:11:15 |
| 8721 | 4548 | 1 | 2017-09-06 15:23:19 |
| 8722 | 4547 | 1 | 2017-09-06 15:34:42 |
| 8723 | 4545 | 1 | 2017-09-06 15:35:08 |
| 8724 | 4546 | 1 | 2017-09-06 15:37:34 |
| 8725 | 4552 | 1 | 2017-09-06 15:39:31 |
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;