Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,351–5,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5351 | 2750 | 3 | 2016-08-29 11:43:52 |
| 5352 | 2754 | 2 | 2016-08-29 11:48:33 |
| 5353 | 2753 | 2 | 2016-08-29 11:48:53 |
| 5354 | 2754 | 3 | 2016-08-29 12:32:35 |
| 5355 | 2753 | 1 | 2016-08-29 12:51:16 |
| 5356 | 2750 | 1 | 2016-08-29 12:59:16 |
| 5357 | 2665 | 2 | 2016-08-29 15:16:41 |
| 5358 | 2666 | 2 | 2016-08-29 15:24:00 |
| 5359 | 2666 | 3 | 2016-08-29 16:18:36 |
| 5360 | 2665 | 3 | 2016-08-29 16:39:44 |
| 5361 | 2681 | 1 | 2016-08-30 09:17:15 |
| 5362 | 2681 | 2 | 2016-08-30 10:45:28 |
| 5363 | 2766 | 2 | 2016-08-31 13:39:30 |
| 5364 | 2768 | 2 | 2016-08-31 13:55:58 |
| 5365 | 2767 | 2 | 2016-08-31 13:56:05 |
| 5366 | 2766 | 3 | 2016-08-31 14:40:39 |
| 5367 | 2768 | 1 | 2016-08-31 14:55:44 |
| 5368 | 2767 | 1 | 2016-08-31 15:28:45 |
| 5369 | 2768 | 2 | 2016-08-31 16:14:43 |
| 5370 | 2767 | 3 | 2016-08-31 16:19:42 |
| 5371 | 2769 | 2 | 2016-09-01 09:54:53 |
| 5372 | 2769 | 3 | 2016-09-01 10:35:15 |
| 5373 | 2774 | 1 | 2016-09-01 11:09:49 |
| 5374 | 2775 | 3 | 2016-09-01 11:12:03 |
| 5375 | 2776 | 1 | 2016-09-01 11:18:56 |
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;