Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,201–14,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14201 | 7210 | 1 | 2018-12-11 14:28:56 |
| 14202 | 7257 | 3 | 2018-12-12 10:36:24 |
| 14203 | 7256 | 2 | 2018-12-12 10:49:14 |
| 14204 | 7257 | 1 | 2018-12-12 11:10:38 |
| 14205 | 7259 | 2 | 2018-12-12 12:12:56 |
| 14206 | 7258 | 2 | 2018-12-12 12:20:52 |
| 14207 | 7256 | 1 | 2018-12-12 12:21:10 |
| 14208 | 7230 | 3 | 2018-12-13 12:39:22 |
| 14209 | 7229 | 3 | 2018-12-13 12:41:23 |
| 14210 | 7228 | 2 | 2018-12-13 12:48:49 |
| 14211 | 7227 | 3 | 2018-12-13 12:51:50 |
| 14212 | 7226 | 3 | 2018-12-13 12:52:11 |
| 14213 | 7230 | 2 | 2018-12-13 13:09:02 |
| 14214 | 7229 | 2 | 2018-12-13 14:01:47 |
| 14215 | 7230 | 1 | 2018-12-13 14:05:55 |
| 14216 | 7226 | 2 | 2018-12-13 14:07:55 |
| 14217 | 7227 | 2 | 2018-12-13 14:15:55 |
| 14218 | 7229 | 1 | 2018-12-13 14:30:48 |
| 14219 | 7226 | 1 | 2018-12-13 14:34:59 |
| 14220 | 7230 | 2 | 2018-12-13 15:04:06 |
| 14221 | 7226 | 2 | 2018-12-13 15:13:49 |
| 14222 | 7229 | 2 | 2018-12-13 15:27:28 |
| 14223 | 7227 | 1 | 2018-12-13 15:40:44 |
| 14224 | 7227 | 2 | 2018-12-13 16:21:37 |
| 14225 | 7269 | 3 | 2018-12-14 11:05:28 |
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;