Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,201–9,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9201 | 4112 | 1 | 2017-10-26 13:14:36 |
| 9202 | 4128 | 1 | 2017-10-26 13:26:35 |
| 9203 | 4121 | 1 | 2017-10-26 13:26:53 |
| 9204 | 4116 | 1 | 2017-10-26 13:32:46 |
| 9205 | 4110 | 1 | 2017-10-26 13:33:47 |
| 9206 | 4113 | 1 | 2017-10-26 13:34:54 |
| 9207 | 4122 | 1 | 2017-10-26 13:35:44 |
| 9208 | 4118 | 1 | 2017-10-26 13:38:02 |
| 9209 | 4135 | 1 | 2017-10-26 13:39:39 |
| 9210 | 4137 | 1 | 2017-10-26 13:44:24 |
| 9211 | 4120 | 1 | 2017-10-26 13:47:20 |
| 9212 | 4106 | 1 | 2017-10-26 13:47:27 |
| 9213 | 4109 | 1 | 2017-10-26 13:50:09 |
| 9214 | 4133 | 1 | 2017-10-26 13:51:09 |
| 9215 | 4125 | 1 | 2017-10-26 13:54:35 |
| 9216 | 4136 | 1 | 2017-10-26 13:59:39 |
| 9217 | 4119 | 1 | 2017-10-26 13:59:46 |
| 9218 | 4128 | 3 | 2017-10-26 14:03:12 |
| 9219 | 4115 | 1 | 2017-10-26 14:06:41 |
| 9220 | 4123 | 1 | 2017-10-26 14:06:50 |
| 9221 | 4138 | 1 | 2017-10-26 14:10:38 |
| 9222 | 4129 | 1 | 2017-10-26 14:11:19 |
| 9223 | 4130 | 1 | 2017-10-26 14:11:34 |
| 9224 | 4127 | 1 | 2017-10-26 14:11:47 |
| 9225 | 4104 | 1 | 2017-10-26 14:18:09 |
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;