Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,201–5,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5201 | 2593 | 2 | 2016-08-13 14:48:09 |
| 5202 | 2638 | 1 | 2016-08-14 09:09:00 |
| 5203 | 2635 | 3 | 2016-08-14 09:10:57 |
| 5204 | 2634 | 3 | 2016-08-14 09:16:17 |
| 5205 | 2636 | 3 | 2016-08-14 09:18:14 |
| 5206 | 2637 | 3 | 2016-08-14 09:21:29 |
| 5207 | 2636 | 2 | 2016-08-14 09:44:39 |
| 5208 | 2638 | 2 | 2016-08-14 09:51:25 |
| 5209 | 2635 | 2 | 2016-08-14 10:09:59 |
| 5210 | 2638 | 3 | 2016-08-14 10:29:46 |
| 5211 | 2634 | 2 | 2016-08-14 10:35:55 |
| 5212 | 2637 | 2 | 2016-08-14 10:46:32 |
| 5213 | 2636 | 1 | 2016-08-14 11:03:45 |
| 5214 | 2639 | 2 | 2016-08-14 11:13:50 |
| 5215 | 2640 | 2 | 2016-08-14 11:15:13 |
| 5216 | 2638 | 1 | 2016-08-14 11:18:12 |
| 5217 | 2641 | 3 | 2016-08-14 11:23:46 |
| 5218 | 2642 | 2 | 2016-08-14 11:25:40 |
| 5219 | 2635 | 1 | 2016-08-14 11:39:27 |
| 5220 | 2634 | 1 | 2016-08-14 12:04:34 |
| 5221 | 2637 | 1 | 2016-08-14 12:05:29 |
| 5222 | 2590 | 3 | 2016-08-14 14:36:38 |
| 5223 | 2589 | 3 | 2016-08-14 14:42:23 |
| 5224 | 2591 | 3 | 2016-08-14 14:47:43 |
| 5225 | 2647 | 2 | 2016-08-15 13:57:17 |
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;