Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,026–18,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18026 | 9325 | 1 | 2019-10-28 14:26:15 |
| 18027 | 9318 | 3 | 2019-10-28 14:31:17 |
| 18028 | 9121 | 2 | 2019-10-28 14:46:32 |
| 18029 | 9173 | 3 | 2019-10-28 14:47:45 |
| 18030 | 9325 | 3 | 2019-10-28 15:05:00 |
| 18031 | 9319 | 3 | 2019-10-28 15:17:09 |
| 18032 | 9325 | 2 | 2019-10-28 15:33:54 |
| 18033 | 9121 | 3 | 2019-10-28 16:07:17 |
| 18034 | 9121 | 2 | 2019-10-28 17:27:50 |
| 18035 | 9320 | 2 | 2019-10-29 10:09:20 |
| 18036 | 9321 | 2 | 2019-10-29 10:11:50 |
| 18037 | 9312 | 2 | 2019-10-29 10:48:37 |
| 18038 | 9311 | 2 | 2019-10-29 10:51:22 |
| 18039 | 9320 | 1 | 2019-10-29 11:20:06 |
| 18040 | 9321 | 1 | 2019-10-29 11:29:07 |
| 18041 | 9312 | 3 | 2019-10-29 11:29:38 |
| 18042 | 9329 | 3 | 2019-10-29 11:48:38 |
| 18043 | 9330 | 3 | 2019-10-29 11:53:36 |
| 18044 | 9326 | 2 | 2019-10-29 11:55:55 |
| 18045 | 9327 | 2 | 2019-10-29 12:00:53 |
| 18046 | 9311 | 1 | 2019-10-29 12:21:01 |
| 18047 | 9330 | 2 | 2019-10-29 12:25:57 |
| 18048 | 9326 | 1 | 2019-10-29 12:47:48 |
| 18049 | 9330 | 1 | 2019-10-29 13:07:50 |
| 18050 | 9329 | 2 | 2019-10-29 13:12:27 |
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;