Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,226–9,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9226 | 4106 | 3 | 2017-10-26 14:20:02 |
| 9227 | 4122 | 3 | 2017-10-26 14:20:33 |
| 9228 | 4116 | 3 | 2017-10-26 14:22:40 |
| 9229 | 4107 | 1 | 2017-10-26 14:25:27 |
| 9230 | 4132 | 1 | 2017-10-26 14:26:03 |
| 9231 | 4118 | 3 | 2017-10-26 14:26:21 |
| 9232 | 4125 | 3 | 2017-10-26 14:31:50 |
| 9233 | 4110 | 3 | 2017-10-26 14:32:37 |
| 9234 | 4115 | 3 | 2017-10-26 14:34:07 |
| 9235 | 4113 | 3 | 2017-10-26 14:35:45 |
| 9236 | 4117 | 3 | 2017-10-26 14:37:01 |
| 9237 | 4112 | 3 | 2017-10-26 14:37:56 |
| 9238 | 4136 | 3 | 2017-10-26 14:38:31 |
| 9239 | 4133 | 3 | 2017-10-26 14:40:56 |
| 9240 | 4109 | 3 | 2017-10-26 14:42:56 |
| 9241 | 4135 | 3 | 2017-10-26 14:47:13 |
| 9242 | 4137 | 3 | 2017-10-26 14:48:42 |
| 9243 | 4107 | 3 | 2017-10-26 14:51:32 |
| 9244 | 4121 | 3 | 2017-10-26 14:56:42 |
| 9245 | 4129 | 3 | 2017-10-26 14:57:43 |
| 9246 | 4132 | 3 | 2017-10-26 14:59:57 |
| 9247 | 4119 | 3 | 2017-10-26 15:00:51 |
| 9248 | 4120 | 3 | 2017-10-26 15:03:40 |
| 9249 | 4127 | 3 | 2017-10-26 15:05:34 |
| 9250 | 4130 | 3 | 2017-10-26 15:09:47 |
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;