Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,826–14,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14826 | 7402 | 2 | 2019-02-19 12:20:58 |
| 14827 | 7391 | 2 | 2019-02-19 12:22:59 |
| 14828 | 7407 | 2 | 2019-02-19 12:23:30 |
| 14829 | 7404 | 2 | 2019-02-19 12:27:03 |
| 14830 | 7436 | 2 | 2019-02-19 12:27:21 |
| 14831 | 7423 | 2 | 2019-02-19 12:30:04 |
| 14832 | 7438 | 2 | 2019-02-19 12:30:46 |
| 14833 | 7426 | 2 | 2019-02-19 12:33:11 |
| 14834 | 7464 | 1 | 2019-02-19 12:33:47 |
| 14835 | 7656 | 2 | 2019-02-19 12:39:21 |
| 14836 | 7398 | 2 | 2019-02-19 12:42:58 |
| 14837 | 7441 | 2 | 2019-02-19 13:04:22 |
| 14838 | 7601 | 2 | 2019-02-19 13:12:10 |
| 14839 | 7464 | 3 | 2019-02-19 13:16:42 |
| 14840 | 7645 | 2 | 2019-02-20 09:18:46 |
| 14841 | 7474 | 1 | 2019-02-21 11:55:12 |
| 14842 | 7474 | 2 | 2019-02-21 12:42:42 |
| 14843 | 7474 | 3 | 2019-02-21 13:17:29 |
| 14844 | 7474 | 2 | 2019-02-21 14:21:23 |
| 14845 | 7712 | 1 | 2019-02-22 11:39:01 |
| 14846 | 7712 | 2 | 2019-02-22 12:22:22 |
| 14847 | 7712 | 3 | 2019-02-22 13:04:33 |
| 14848 | 7718 | 1 | 2019-02-22 13:55:36 |
| 14849 | 7712 | 1 | 2019-02-22 13:59:49 |
| 14850 | 7718 | 2 | 2019-02-22 14:44:52 |
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;