Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,226–3,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3226 | 1672 | 1 | 2016-01-02 10:47:05 |
| 3227 | 1673 | 2 | 2016-01-03 10:06:37 |
| 3228 | 1584 | 1 | 2016-01-03 12:40:30 |
| 3229 | 1583 | 1 | 2016-01-03 12:45:38 |
| 3230 | 1526 | 2 | 2016-01-04 09:50:15 |
| 3231 | 1525 | 2 | 2016-01-04 09:51:42 |
| 3232 | 1526 | 3 | 2016-01-04 11:13:18 |
| 3233 | 1644 | 1 | 2016-01-05 10:20:06 |
| 3234 | 1646 | 1 | 2016-01-05 10:25:36 |
| 3235 | 1648 | 1 | 2016-01-05 10:27:07 |
| 3236 | 1645 | 2 | 2016-01-05 10:33:14 |
| 3237 | 1647 | 3 | 2016-01-05 10:34:29 |
| 3238 | 1648 | 2 | 2016-01-05 10:59:31 |
| 3239 | 1644 | 2 | 2016-01-05 11:03:29 |
| 3240 | 1681 | 1 | 2016-01-05 11:21:13 |
| 3241 | 1682 | 1 | 2016-01-05 11:22:45 |
| 3242 | 1645 | 1 | 2016-01-05 11:30:01 |
| 3243 | 1646 | 2 | 2016-01-05 11:33:50 |
| 3244 | 1647 | 2 | 2016-01-05 11:56:23 |
| 3245 | 1681 | 2 | 2016-01-05 12:23:34 |
| 3246 | 1647 | 1 | 2016-01-05 12:33:28 |
| 3247 | 1682 | 2 | 2016-01-05 12:53:37 |
| 3248 | 1676 | 2 | 2016-01-05 16:33:07 |
| 3249 | 1675 | 3 | 2016-01-05 16:33:57 |
| 3250 | 1677 | 3 | 2016-01-05 16:39:12 |
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;