Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,151–17,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17151 | 8709 | 3 | 2019-08-05 13:41:21 |
| 17152 | 8696 | 1 | 2019-08-05 13:43:31 |
| 17153 | 8697 | 2 | 2019-08-05 13:50:21 |
| 17154 | 8697 | 1 | 2019-08-05 14:34:32 |
| 17155 | 8696 | 2 | 2019-08-05 14:35:31 |
| 17156 | 8709 | 1 | 2019-08-05 14:52:51 |
| 17157 | 8696 | 3 | 2019-08-05 15:44:06 |
| 17158 | 8652 | 2 | 2019-08-06 09:28:57 |
| 17159 | 8653 | 2 | 2019-08-06 09:35:13 |
| 17160 | 8712 | 1 | 2019-08-06 09:48:43 |
| 17161 | 8713 | 2 | 2019-08-06 09:56:01 |
| 17162 | 8653 | 1 | 2019-08-06 10:20:45 |
| 17163 | 8652 | 1 | 2019-08-06 10:24:20 |
| 17164 | 8712 | 3 | 2019-08-06 10:26:32 |
| 17165 | 8713 | 1 | 2019-08-06 11:08:55 |
| 17166 | 8590 | 2 | 2019-08-06 12:07:25 |
| 17167 | 8592 | 3 | 2019-08-06 12:11:39 |
| 17168 | 8593 | 3 | 2019-08-06 12:15:37 |
| 17169 | 8591 | 3 | 2019-08-06 12:20:16 |
| 17170 | 8713 | 3 | 2019-08-06 12:33:02 |
| 17171 | 8590 | 1 | 2019-08-06 12:57:00 |
| 17172 | 8715 | 3 | 2019-08-06 13:13:46 |
| 17173 | 8716 | 2 | 2019-08-06 13:15:54 |
| 17174 | 8714 | 2 | 2019-08-06 13:20:56 |
| 17175 | 8715 | 1 | 2019-08-06 13:55:51 |
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;