Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,101–10,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10101 | 5221 | 1 | 2018-01-23 11:28:32 |
| 10102 | 5220 | 1 | 2018-01-23 11:44:31 |
| 10103 | 5229 | 3 | 2018-01-24 13:39:48 |
| 10104 | 5231 | 2 | 2018-01-26 11:12:53 |
| 10105 | 5230 | 2 | 2018-01-26 11:14:26 |
| 10106 | 5227 | 2 | 2018-01-26 12:39:03 |
| 10107 | 5226 | 2 | 2018-01-26 12:39:27 |
| 10108 | 5228 | 2 | 2018-01-26 12:47:42 |
| 10109 | 5226 | 3 | 2018-01-26 13:05:53 |
| 10110 | 5233 | 2 | 2018-01-26 13:13:12 |
| 10111 | 5234 | 2 | 2018-01-26 13:23:21 |
| 10112 | 5227 | 3 | 2018-01-26 13:25:15 |
| 10113 | 5228 | 3 | 2018-01-26 14:04:57 |
| 10114 | 5218 | 1 | 2018-01-28 15:07:24 |
| 10115 | 5219 | 1 | 2018-01-28 15:08:56 |
| 10116 | 5239 | 2 | 2018-01-29 10:10:40 |
| 10117 | 5240 | 2 | 2018-01-29 10:13:08 |
| 10118 | 5238 | 3 | 2018-01-29 10:17:39 |
| 10119 | 5238 | 1 | 2018-01-29 10:58:47 |
| 10120 | 5239 | 3 | 2018-01-29 11:28:43 |
| 10121 | 5240 | 3 | 2018-01-29 11:46:00 |
| 10122 | 5239 | 2 | 2018-01-29 12:14:51 |
| 10123 | 5238 | 3 | 2018-01-29 12:16:50 |
| 10124 | 5240 | 2 | 2018-01-29 12:44:15 |
| 10125 | 5235 | 3 | 2018-01-29 14:18:42 |
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;