Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,176–12,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12176 | 6302 | 3 | 2018-07-31 11:43:46 |
| 12177 | 6324 | 1 | 2018-07-31 11:52:35 |
| 12178 | 6304 | 2 | 2018-07-31 11:56:01 |
| 12179 | 6305 | 2 | 2018-07-31 11:59:43 |
| 12180 | 6326 | 1 | 2018-07-31 12:29:52 |
| 12181 | 6323 | 1 | 2018-07-31 12:32:04 |
| 12182 | 6325 | 2 | 2018-07-31 12:36:34 |
| 12183 | 6327 | 2 | 2018-07-31 13:12:19 |
| 12184 | 6327 | 1 | 2018-07-31 14:06:57 |
| 12185 | 6338 | 3 | 2018-08-02 11:18:26 |
| 12186 | 6340 | 3 | 2018-08-02 12:02:05 |
| 12187 | 6341 | 3 | 2018-08-02 12:02:56 |
| 12188 | 6342 | 3 | 2018-08-02 12:10:07 |
| 12189 | 6341 | 1 | 2018-08-02 12:40:04 |
| 12190 | 6342 | 2 | 2018-08-02 12:41:31 |
| 12191 | 6338 | 2 | 2018-08-02 12:45:22 |
| 12192 | 6341 | 2 | 2018-08-02 13:49:34 |
| 12193 | 6341 | 3 | 2018-08-02 14:30:48 |
| 12194 | 6306 | 2 | 2018-08-02 16:05:35 |
| 12195 | 6329 | 2 | 2018-08-02 16:10:31 |
| 12196 | 6330 | 2 | 2018-08-02 16:10:51 |
| 12197 | 6331 | 2 | 2018-08-02 16:12:45 |
| 12198 | 6328 | 2 | 2018-08-02 16:38:34 |
| 12199 | 6330 | 3 | 2018-08-02 16:47:46 |
| 12200 | 6331 | 3 | 2018-08-02 17:00:35 |
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;