Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,151–12,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12151 | 6220 | 2 | 2018-07-29 12:55:49 |
| 12152 | 6279 | 3 | 2018-07-29 13:14:38 |
| 12153 | 6278 | 3 | 2018-07-29 13:16:41 |
| 12154 | 6316 | 2 | 2018-07-30 12:19:01 |
| 12155 | 6317 | 2 | 2018-07-30 12:20:26 |
| 12156 | 6224 | 1 | 2018-07-30 13:33:20 |
| 12157 | 6316 | 1 | 2018-07-30 13:36:38 |
| 12158 | 6317 | 3 | 2018-07-30 13:47:10 |
| 12159 | 6224 | 3 | 2018-07-30 14:14:16 |
| 12160 | 6317 | 1 | 2018-07-30 14:29:57 |
| 12161 | 6224 | 2 | 2018-07-30 15:25:59 |
| 12162 | 6321 | 1 | 2018-07-30 15:46:28 |
| 12163 | 6318 | 1 | 2018-07-30 15:51:23 |
| 12164 | 6319 | 1 | 2018-07-30 15:51:44 |
| 12165 | 6322 | 1 | 2018-07-30 15:52:01 |
| 12166 | 6320 | 1 | 2018-07-30 15:54:37 |
| 12167 | 6324 | 1 | 2018-07-31 09:50:31 |
| 12168 | 6325 | 2 | 2018-07-31 09:54:39 |
| 12169 | 6326 | 1 | 2018-07-31 09:54:59 |
| 12170 | 6323 | 1 | 2018-07-31 09:55:37 |
| 12171 | 6324 | 3 | 2018-07-31 10:20:48 |
| 12172 | 6326 | 3 | 2018-07-31 10:57:25 |
| 12173 | 6302 | 2 | 2018-07-31 11:02:00 |
| 12174 | 6325 | 3 | 2018-07-31 11:12:13 |
| 12175 | 6323 | 3 | 2018-07-31 11:17:30 |
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;