Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,826–8,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8826 | 4578 | 3 | 2017-09-16 11:50:46 |
| 8827 | 4638 | 2 | 2017-09-17 10:15:38 |
| 8828 | 4637 | 1 | 2017-09-17 10:20:59 |
| 8829 | 4643 | 2 | 2017-09-17 12:33:48 |
| 8830 | 4640 | 3 | 2017-09-17 12:35:02 |
| 8831 | 4642 | 2 | 2017-09-17 12:36:33 |
| 8832 | 4639 | 2 | 2017-09-17 12:39:14 |
| 8833 | 4641 | 1 | 2017-09-17 12:45:29 |
| 8834 | 4640 | 1 | 2017-09-17 13:07:47 |
| 8835 | 4640 | 3 | 2017-09-17 13:37:33 |
| 8836 | 4641 | 2 | 2017-09-17 13:43:00 |
| 8837 | 4639 | 3 | 2017-09-17 13:59:39 |
| 8838 | 4643 | 3 | 2017-09-17 14:03:50 |
| 8839 | 4642 | 1 | 2017-09-17 14:08:07 |
| 8840 | 4640 | 1 | 2017-09-17 14:29:32 |
| 8841 | 4641 | 3 | 2017-09-17 14:56:33 |
| 8842 | 4566 | 2 | 2017-09-18 15:24:10 |
| 8843 | 4565 | 2 | 2017-09-18 15:26:21 |
| 8844 | 4565 | 3 | 2017-09-18 16:17:16 |
| 8845 | 4565 | 1 | 2017-09-18 16:45:11 |
| 8846 | 4566 | 3 | 2017-09-18 16:57:54 |
| 8847 | 4646 | 2 | 2017-09-19 14:40:53 |
| 8848 | 4644 | 2 | 2017-09-19 14:43:58 |
| 8849 | 4645 | 2 | 2017-09-19 14:44:47 |
| 8850 | 4646 | 3 | 2017-09-19 15:08:40 |
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;