Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,026–5,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5026 | 2457 | 2 | 2016-07-25 13:46:13 |
| 5027 | 2527 | 1 | 2016-07-26 14:36:02 |
| 5028 | 2523 | 1 | 2016-07-26 14:38:06 |
| 5029 | 2524 | 1 | 2016-07-26 14:41:41 |
| 5030 | 2525 | 1 | 2016-07-26 14:47:23 |
| 5031 | 2526 | 1 | 2016-07-26 14:50:59 |
| 5032 | 2527 | 2 | 2016-07-26 15:20:10 |
| 5033 | 2526 | 2 | 2016-07-26 15:36:40 |
| 5034 | 2525 | 2 | 2016-07-26 15:39:55 |
| 5035 | 2523 | 2 | 2016-07-26 15:41:45 |
| 5036 | 2561 | 2 | 2016-07-26 15:52:00 |
| 5037 | 2524 | 2 | 2016-07-26 15:59:37 |
| 5038 | 2526 | 3 | 2016-07-26 16:05:18 |
| 5039 | 2527 | 3 | 2016-07-26 16:11:50 |
| 5040 | 2523 | 3 | 2016-07-26 16:42:49 |
| 5041 | 2525 | 3 | 2016-07-26 16:48:05 |
| 5042 | 2561 | 3 | 2016-07-26 17:09:25 |
| 5043 | 2524 | 3 | 2016-07-26 17:29:03 |
| 5044 | 2562 | 2 | 2016-07-27 10:07:16 |
| 5045 | 2562 | 3 | 2016-07-27 10:34:15 |
| 5046 | 2563 | 2 | 2016-07-27 11:01:55 |
| 5047 | 2562 | 1 | 2016-07-27 11:56:36 |
| 5048 | 2555 | 3 | 2016-07-27 12:00:03 |
| 5049 | 2556 | 3 | 2016-07-27 12:07:18 |
| 5050 | 2562 | 2 | 2016-07-27 12:26: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;