Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 126–150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 126 | 206 | 2 | 2015-03-27 10:54:01 |
| 127 | 207 | 2 | 2015-03-27 10:55:21 |
| 128 | 205 | 3 | 2015-03-27 11:17:47 |
| 129 | 206 | 3 | 2015-03-27 11:46:02 |
| 130 | 207 | 3 | 2015-03-27 11:46:16 |
| 131 | 205 | 1 | 2015-03-27 11:58:28 |
| 132 | 209 | 3 | 2015-03-27 12:14:49 |
| 133 | 208 | 3 | 2015-03-27 12:17:43 |
| 134 | 207 | 1 | 2015-03-27 12:32:10 |
| 135 | 208 | 2 | 2015-03-27 12:51:08 |
| 136 | 205 | 3 | 2015-03-27 12:53:58 |
| 137 | 209 | 2 | 2015-03-27 12:59:13 |
| 138 | 206 | 1 | 2015-03-27 13:05:08 |
| 139 | 208 | 1 | 2015-03-27 13:19:04 |
| 140 | 211 | 2 | 2015-03-27 13:26:47 |
| 141 | 210 | 2 | 2015-03-27 13:28:11 |
| 142 | 206 | 3 | 2015-03-27 13:38:02 |
| 143 | 207 | 3 | 2015-03-27 13:59:52 |
| 144 | 209 | 1 | 2015-03-27 14:17:29 |
| 145 | 208 | 2 | 2015-03-27 14:29:52 |
| 146 | 209 | 2 | 2015-03-27 14:59:24 |
| 147 | 213 | 2 | 2015-03-29 12:08:22 |
| 148 | 212 | 2 | 2015-03-29 12:10:46 |
| 149 | 212 | 3 | 2015-03-29 12:41:40 |
| 150 | 213 | 3 | 2015-03-29 12:45:37 |
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;