Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,176–9,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9176 | 4110 | 2 | 2017-10-26 12:41:06 |
| 9177 | 4109 | 2 | 2017-10-26 12:42:06 |
| 9178 | 4130 | 2 | 2017-10-26 12:42:06 |
| 9179 | 4119 | 2 | 2017-10-26 12:42:16 |
| 9180 | 4122 | 2 | 2017-10-26 12:42:25 |
| 9181 | 4129 | 2 | 2017-10-26 12:43:07 |
| 9182 | 4127 | 2 | 2017-10-26 12:43:15 |
| 9183 | 4112 | 2 | 2017-10-26 12:44:01 |
| 9184 | 4133 | 2 | 2017-10-26 12:44:19 |
| 9185 | 4120 | 2 | 2017-10-26 12:45:02 |
| 9186 | 4116 | 2 | 2017-10-26 12:45:13 |
| 9187 | 4136 | 2 | 2017-10-26 12:45:29 |
| 9188 | 4128 | 2 | 2017-10-26 12:47:56 |
| 9189 | 4104 | 2 | 2017-10-26 12:48:12 |
| 9190 | 4135 | 2 | 2017-10-26 12:48:36 |
| 9191 | 4118 | 2 | 2017-10-26 12:48:39 |
| 9192 | 4123 | 2 | 2017-10-26 12:49:17 |
| 9193 | 4125 | 2 | 2017-10-26 12:50:30 |
| 9194 | 4107 | 2 | 2017-10-26 12:51:00 |
| 9195 | 4132 | 2 | 2017-10-26 12:52:31 |
| 9196 | 4115 | 2 | 2017-10-26 12:53:49 |
| 9197 | 4121 | 2 | 2017-10-26 12:53:55 |
| 9198 | 4138 | 2 | 2017-10-26 12:54:03 |
| 9199 | 4137 | 2 | 2017-10-26 12:54:24 |
| 9200 | 4117 | 1 | 2017-10-26 13:07:50 |
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;