Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,276–7,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7276 | 3819 | 2 | 2017-04-21 16:01:50 |
| 7277 | 3634 | 3 | 2017-04-21 16:02:19 |
| 7278 | 3635 | 3 | 2017-04-21 16:15:51 |
| 7279 | 3636 | 3 | 2017-04-21 16:40:49 |
| 7280 | 3825 | 3 | 2017-04-22 09:49:42 |
| 7281 | 3824 | 3 | 2017-04-22 09:52:58 |
| 7282 | 3814 | 1 | 2017-04-22 09:54:50 |
| 7283 | 3817 | 2 | 2017-04-22 10:34:30 |
| 7284 | 3815 | 2 | 2017-04-22 10:37:57 |
| 7285 | 3818 | 2 | 2017-04-22 10:38:24 |
| 7286 | 3816 | 2 | 2017-04-22 10:38:59 |
| 7287 | 3825 | 2 | 2017-04-22 10:52:58 |
| 7288 | 3824 | 2 | 2017-04-22 11:12:20 |
| 7289 | 3815 | 3 | 2017-04-22 11:20:54 |
| 7290 | 3816 | 3 | 2017-04-22 11:35:08 |
| 7291 | 3817 | 3 | 2017-04-22 11:42:17 |
| 7292 | 3769 | 2 | 2017-04-22 11:44:48 |
| 7293 | 3768 | 2 | 2017-04-22 11:46:36 |
| 7294 | 3770 | 2 | 2017-04-22 11:51:09 |
| 7295 | 3767 | 2 | 2017-04-22 11:56:56 |
| 7296 | 3818 | 3 | 2017-04-22 11:58:57 |
| 7297 | 3817 | 2 | 2017-04-22 12:28:00 |
| 7298 | 3767 | 3 | 2017-04-22 12:42:04 |
| 7299 | 3769 | 3 | 2017-04-22 12:48:33 |
| 7300 | 3768 | 3 | 2017-04-22 12:49:09 |
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;