Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,051–3,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3051 | 1227 | 1 | 2015-12-08 17:40:29 |
| 3052 | 1569 | 1 | 2015-12-09 09:34:37 |
| 3053 | 1571 | 1 | 2015-12-09 09:38:08 |
| 3054 | 1570 | 1 | 2015-12-09 09:40:11 |
| 3055 | 1572 | 1 | 2015-12-09 09:41:11 |
| 3056 | 1568 | 1 | 2015-12-09 09:47:53 |
| 3057 | 1569 | 3 | 2015-12-09 10:04:45 |
| 3058 | 1573 | 2 | 2015-12-09 10:09:35 |
| 3059 | 1572 | 3 | 2015-12-09 10:20:22 |
| 3060 | 1570 | 3 | 2015-12-09 10:23:11 |
| 3061 | 1568 | 3 | 2015-12-09 10:31:26 |
| 3062 | 1571 | 3 | 2015-12-09 10:40:03 |
| 3063 | 1573 | 1 | 2015-12-09 11:42:04 |
| 3064 | 1577 | 2 | 2015-12-09 13:43:57 |
| 3065 | 1576 | 2 | 2015-12-09 13:45:39 |
| 3066 | 1575 | 2 | 2015-12-09 13:59:43 |
| 3067 | 1576 | 3 | 2015-12-09 14:33:10 |
| 3068 | 1575 | 3 | 2015-12-09 14:34:19 |
| 3069 | 1576 | 1 | 2015-12-09 15:07:34 |
| 3070 | 1575 | 1 | 2015-12-09 15:18:46 |
| 3071 | 1576 | 3 | 2015-12-09 15:35:15 |
| 3072 | 1575 | 3 | 2015-12-09 16:46:28 |
| 3073 | 1578 | 3 | 2015-12-11 12:43:17 |
| 3074 | 1578 | 2 | 2015-12-11 13:16:33 |
| 3075 | 1578 | 3 | 2015-12-11 14:40:40 |
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;