Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,301–16,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16301 | 8011 | 3 | 2019-05-31 15:10:06 |
| 16302 | 8007 | 3 | 2019-05-31 15:10:13 |
| 16303 | 8018 | 3 | 2019-05-31 15:11:07 |
| 16304 | 8002 | 2 | 2019-05-31 15:12:00 |
| 16305 | 8009 | 2 | 2019-05-31 15:14:17 |
| 16306 | 8027 | 3 | 2019-05-31 15:16:24 |
| 16307 | 8299 | 1 | 2019-05-31 15:18:37 |
| 16308 | 8020 | 2 | 2019-05-31 15:24:12 |
| 16309 | 8010 | 3 | 2019-05-31 15:27:06 |
| 16310 | 8013 | 3 | 2019-05-31 15:29:49 |
| 16311 | 8030 | 3 | 2019-05-31 15:30:10 |
| 16312 | 8033 | 3 | 2019-05-31 15:30:29 |
| 16313 | 7999 | 3 | 2019-05-31 15:34:39 |
| 16314 | 8029 | 3 | 2019-05-31 15:37:02 |
| 16315 | 8031 | 3 | 2019-05-31 15:44:27 |
| 16316 | 8032 | 3 | 2019-05-31 15:45:54 |
| 16317 | 8001 | 3 | 2019-05-31 15:46:28 |
| 16318 | 8015 | 3 | 2019-05-31 15:52:38 |
| 16319 | 8014 | 3 | 2019-05-31 15:54:00 |
| 16320 | 8024 | 3 | 2019-05-31 15:54:42 |
| 16321 | 8025 | 3 | 2019-05-31 15:56:02 |
| 16322 | 8028 | 3 | 2019-05-31 15:56:41 |
| 16323 | 8009 | 3 | 2019-05-31 16:08:25 |
| 16324 | 8020 | 3 | 2019-05-31 16:10:50 |
| 16325 | 8002 | 3 | 2019-05-31 16:21:00 |
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;