Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,151–4,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4151 | 2242 | 3 | 2016-05-12 14:53:24 |
| 4152 | 2243 | 2 | 2016-05-12 14:54:27 |
| 4153 | 2244 | 3 | 2016-05-12 14:58:36 |
| 4154 | 2241 | 3 | 2016-05-12 15:01:44 |
| 4155 | 2241 | 1 | 2016-05-12 15:40:45 |
| 4156 | 2248 | 3 | 2016-05-12 15:42:57 |
| 4157 | 2242 | 1 | 2016-05-12 15:43:54 |
| 4158 | 2244 | 1 | 2016-05-12 16:20:06 |
| 4159 | 2243 | 3 | 2016-05-12 16:27:38 |
| 4160 | 2248 | 1 | 2016-05-12 16:40:43 |
| 4161 | 2241 | 2 | 2016-05-12 16:43:41 |
| 4162 | 2242 | 2 | 2016-05-12 17:02:20 |
| 4163 | 2249 | 1 | 2016-05-13 10:52:47 |
| 4164 | 2250 | 1 | 2016-05-13 10:56:51 |
| 4165 | 2250 | 3 | 2016-05-13 11:34:02 |
| 4166 | 2249 | 2 | 2016-05-13 12:12:34 |
| 4167 | 2251 | 3 | 2016-05-13 12:46:50 |
| 4168 | 2252 | 3 | 2016-05-13 12:57:11 |
| 4169 | 2252 | 2 | 2016-05-13 13:47:53 |
| 4170 | 2252 | 1 | 2016-05-13 14:14:45 |
| 4171 | 2252 | 2 | 2016-05-13 14:46:06 |
| 4172 | 2256 | 2 | 2016-05-14 12:22:00 |
| 4173 | 2256 | 3 | 2016-05-14 12:58:01 |
| 4174 | 2257 | 2 | 2016-05-14 13:08:47 |
| 4175 | 2256 | 2 | 2016-05-14 13:45:19 |
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;