Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,576–5,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5576 | 2853 | 1 | 2016-09-28 13:35:39 |
| 5577 | 2849 | 3 | 2016-09-28 13:39:44 |
| 5578 | 2827 | 3 | 2016-09-29 12:33:46 |
| 5579 | 2807 | 3 | 2016-10-01 10:30:34 |
| 5580 | 2808 | 3 | 2016-10-01 10:39:37 |
| 5581 | 2807 | 2 | 2016-10-01 10:57:22 |
| 5582 | 2808 | 2 | 2016-10-01 11:07:13 |
| 5583 | 2808 | 3 | 2016-10-01 12:25:21 |
| 5584 | 2807 | 3 | 2016-10-01 12:28:43 |
| 5585 | 2806 | 2 | 2016-10-02 12:03:24 |
| 5586 | 2806 | 3 | 2016-10-02 13:30:30 |
| 5587 | 2806 | 2 | 2016-10-02 14:37:31 |
| 5588 | 2855 | 2 | 2016-10-03 11:10:14 |
| 5589 | 2855 | 1 | 2016-10-03 12:07:54 |
| 5590 | 2855 | 2 | 2016-10-03 13:36:47 |
| 5591 | 2866 | 2 | 2016-10-05 11:35:15 |
| 5592 | 2869 | 2 | 2016-10-05 11:35:25 |
| 5593 | 2868 | 1 | 2016-10-05 11:38:41 |
| 5594 | 2867 | 2 | 2016-10-05 11:38:44 |
| 5595 | 2854 | 3 | 2016-10-05 12:08:11 |
| 5596 | 2869 | 3 | 2016-10-05 12:26:55 |
| 5597 | 2866 | 3 | 2016-10-05 12:33:37 |
| 5598 | 2867 | 3 | 2016-10-05 12:53:18 |
| 5599 | 2868 | 3 | 2016-10-05 13:11:00 |
| 5600 | 2854 | 1 | 2016-10-05 13:43:37 |
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;