Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,101–6,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6101 | 3169 | 2 | 2016-12-13 16:44:22 |
| 6102 | 3171 | 2 | 2016-12-13 16:47:51 |
| 6103 | 3168 | 2 | 2016-12-13 16:51:27 |
| 6104 | 3169 | 3 | 2016-12-13 17:28:29 |
| 6105 | 3171 | 3 | 2016-12-13 17:33:51 |
| 6106 | 3158 | 1 | 2016-12-13 17:37:43 |
| 6107 | 3170 | 3 | 2016-12-13 17:43:12 |
| 6108 | 3168 | 3 | 2016-12-13 17:46:44 |
| 6109 | 3173 | 2 | 2016-12-14 10:48:48 |
| 6110 | 3172 | 1 | 2016-12-14 10:53:50 |
| 6111 | 3173 | 3 | 2016-12-14 11:49:17 |
| 6112 | 3172 | 2 | 2016-12-14 11:54:14 |
| 6113 | 3177 | 1 | 2016-12-15 09:10:02 |
| 6114 | 3178 | 2 | 2016-12-15 09:14:38 |
| 6115 | 3163 | 3 | 2016-12-15 09:33:02 |
| 6116 | 3161 | 3 | 2016-12-15 09:35:09 |
| 6117 | 3162 | 3 | 2016-12-15 09:43:25 |
| 6118 | 3163 | 1 | 2016-12-15 10:07:38 |
| 6119 | 3178 | 1 | 2016-12-15 10:13:58 |
| 6120 | 3161 | 2 | 2016-12-15 10:22:27 |
| 6121 | 3178 | 2 | 2016-12-15 10:53:44 |
| 6122 | 3161 | 3 | 2016-12-15 10:59:18 |
| 6123 | 3162 | 2 | 2016-12-15 11:12:17 |
| 6124 | 3141 | 2 | 2016-12-15 11:33:26 |
| 6125 | 3139 | 2 | 2016-12-15 11:34:14 |
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;