Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,101–5,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5101 | 2551 | 1 | 2016-07-31 14:36:57 |
| 5102 | 2552 | 1 | 2016-07-31 14:40:27 |
| 5103 | 2553 | 2 | 2016-07-31 14:51:08 |
| 5104 | 2550 | 2 | 2016-07-31 15:10:46 |
| 5105 | 2552 | 2 | 2016-07-31 15:29:53 |
| 5106 | 2554 | 2 | 2016-07-31 15:53:47 |
| 5107 | 2551 | 2 | 2016-07-31 16:10:14 |
| 5108 | 2557 | 2 | 2016-07-31 17:00:48 |
| 5109 | 2558 | 2 | 2016-07-31 17:08:06 |
| 5110 | 2557 | 3 | 2016-07-31 17:35:02 |
| 5111 | 2543 | 2 | 2016-08-01 11:21:07 |
| 5112 | 2544 | 2 | 2016-08-01 11:23:46 |
| 5113 | 2543 | 1 | 2016-08-01 12:30:20 |
| 5114 | 2544 | 1 | 2016-08-01 12:48:11 |
| 5115 | 2543 | 3 | 2016-08-01 12:59:22 |
| 5116 | 2544 | 3 | 2016-08-01 13:50:04 |
| 5117 | 2547 | 1 | 2016-08-02 10:03:19 |
| 5118 | 2583 | 3 | 2016-08-02 14:00:59 |
| 5119 | 2569 | 3 | 2016-08-02 15:32:23 |
| 5120 | 2568 | 3 | 2016-08-02 15:34:13 |
| 5121 | 2568 | 1 | 2016-08-02 17:02:48 |
| 5122 | 2569 | 1 | 2016-08-02 17:08:01 |
| 5123 | 2541 | 1 | 2016-08-03 09:40:36 |
| 5124 | 2541 | 3 | 2016-08-03 10:08:48 |
| 5125 | 2532 | 2 | 2016-08-04 11:50:07 |
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;