Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,176–3,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3176 | 1635 | 2 | 2015-12-26 09:21:33 |
| 3177 | 1635 | 1 | 2015-12-26 10:30:53 |
| 3178 | 1632 | 3 | 2015-12-26 10:38:35 |
| 3179 | 1631 | 3 | 2015-12-26 10:47:28 |
| 3180 | 1635 | 3 | 2015-12-26 11:22:01 |
| 3181 | 1637 | 3 | 2015-12-26 12:37:55 |
| 3182 | 1639 | 3 | 2015-12-26 12:40:37 |
| 3183 | 1638 | 3 | 2015-12-26 12:42:10 |
| 3184 | 1640 | 3 | 2015-12-26 12:51:40 |
| 3185 | 1637 | 2 | 2015-12-26 13:16:18 |
| 3186 | 1636 | 1 | 2015-12-26 13:47:28 |
| 3187 | 1639 | 2 | 2015-12-26 13:55:18 |
| 3188 | 1640 | 2 | 2015-12-26 14:03:36 |
| 3189 | 1638 | 2 | 2015-12-26 14:04:02 |
| 3190 | 1641 | 2 | 2015-12-27 10:59:28 |
| 3191 | 1642 | 2 | 2015-12-27 11:01:40 |
| 3192 | 1641 | 1 | 2015-12-27 11:30:36 |
| 3193 | 1643 | 3 | 2015-12-27 11:36:43 |
| 3194 | 1642 | 1 | 2015-12-27 11:44:41 |
| 3195 | 1641 | 3 | 2015-12-27 12:10:45 |
| 3196 | 1642 | 3 | 2015-12-27 12:19:30 |
| 3197 | 1641 | 1 | 2015-12-27 13:41:30 |
| 3198 | 1642 | 1 | 2015-12-27 13:51:30 |
| 3199 | 1649 | 3 | 2015-12-28 12:55:13 |
| 3200 | 1650 | 3 | 2015-12-28 12:56: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;