Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,676–6,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6676 | 3103 | 3 | 2017-02-24 12:28:13 |
| 6677 | 3133 | 3 | 2017-02-24 12:30:00 |
| 6678 | 3108 | 3 | 2017-02-24 12:31:24 |
| 6679 | 3131 | 3 | 2017-02-24 12:34:34 |
| 6680 | 3134 | 3 | 2017-02-24 12:36:59 |
| 6681 | 3120 | 3 | 2017-02-24 12:42:40 |
| 6682 | 3113 | 3 | 2017-02-24 12:43:12 |
| 6683 | 3121 | 3 | 2017-02-24 12:44:27 |
| 6684 | 3125 | 3 | 2017-02-24 12:45:20 |
| 6685 | 3126 | 3 | 2017-02-24 12:45:28 |
| 6686 | 3090 | 3 | 2017-02-24 12:47:23 |
| 6687 | 3115 | 3 | 2017-02-24 12:48:34 |
| 6688 | 3083 | 3 | 2017-02-24 12:50:11 |
| 6689 | 3123 | 3 | 2017-02-24 12:50:18 |
| 6690 | 3107 | 3 | 2017-02-24 12:52:20 |
| 6691 | 3085 | 3 | 2017-02-24 12:52:37 |
| 6692 | 3106 | 3 | 2017-02-24 12:53:18 |
| 6693 | 3089 | 3 | 2017-02-24 12:57:59 |
| 6694 | 3136 | 3 | 2017-02-24 12:59:32 |
| 6695 | 3499 | 2 | 2017-02-24 13:31:34 |
| 6696 | 3499 | 3 | 2017-02-24 14:24:34 |
| 6697 | 3560 | 2 | 2017-02-26 10:54:26 |
| 6698 | 3560 | 3 | 2017-02-26 12:09:47 |
| 6699 | 3520 | 1 | 2017-02-26 13:16:43 |
| 6700 | 3519 | 1 | 2017-02-26 13:20:25 |
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;