Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,151–16,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16151 | 8293 | 3 | 2019-05-28 15:19:18 |
| 16152 | 8226 | 1 | 2019-05-28 15:20:07 |
| 16153 | 8292 | 3 | 2019-05-28 15:20:40 |
| 16154 | 8254 | 2 | 2019-05-28 15:48:34 |
| 16155 | 8204 | 2 | 2019-05-28 16:38:31 |
| 16156 | 8203 | 2 | 2019-05-28 16:48:08 |
| 16157 | 8280 | 2 | 2019-05-30 09:19:09 |
| 16158 | 8281 | 3 | 2019-05-30 09:20:21 |
| 16159 | 8297 | 2 | 2019-05-30 09:55:01 |
| 16160 | 8280 | 3 | 2019-05-30 09:55:04 |
| 16161 | 8281 | 2 | 2019-05-30 10:13:55 |
| 16162 | 8297 | 3 | 2019-05-30 10:30:04 |
| 16163 | 8297 | 2 | 2019-05-30 11:03:40 |
| 16164 | 8281 | 3 | 2019-05-30 11:23:31 |
| 16165 | 8282 | 1 | 2019-05-31 09:32:33 |
| 16166 | 8301 | 2 | 2019-05-31 10:52:57 |
| 16167 | 8000 | 2 | 2019-05-31 12:05:06 |
| 16168 | 8006 | 2 | 2019-05-31 12:06:18 |
| 16169 | 8003 | 2 | 2019-05-31 12:07:04 |
| 16170 | 8008 | 2 | 2019-05-31 12:07:57 |
| 16171 | 8018 | 2 | 2019-05-31 12:09:13 |
| 16172 | 8017 | 2 | 2019-05-31 12:09:20 |
| 16173 | 7999 | 2 | 2019-05-31 12:09:23 |
| 16174 | 8010 | 2 | 2019-05-31 12:09:36 |
| 16175 | 8005 | 2 | 2019-05-31 12:10:00 |
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;