Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,801–8,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8801 | 4584 | 3 | 2017-09-13 11:53:05 |
| 8802 | 4585 | 2 | 2017-09-13 12:06:42 |
| 8803 | 4583 | 2 | 2017-09-13 13:00:35 |
| 8804 | 4582 | 2 | 2017-09-13 13:01:19 |
| 8805 | 4586 | 1 | 2017-09-13 17:17:20 |
| 8806 | 4587 | 1 | 2017-09-13 17:17:29 |
| 8807 | 4589 | 3 | 2017-09-15 10:22:50 |
| 8808 | 4588 | 3 | 2017-09-15 10:27:44 |
| 8809 | 4555 | 2 | 2017-09-15 14:26:55 |
| 8810 | 4556 | 2 | 2017-09-15 14:29:47 |
| 8811 | 4558 | 2 | 2017-09-15 14:30:50 |
| 8812 | 4557 | 2 | 2017-09-15 14:35:45 |
| 8813 | 4554 | 2 | 2017-09-15 14:38:29 |
| 8814 | 4556 | 3 | 2017-09-15 15:10:43 |
| 8815 | 4557 | 3 | 2017-09-15 15:35:40 |
| 8816 | 4554 | 3 | 2017-09-15 15:37:34 |
| 8817 | 4558 | 3 | 2017-09-15 15:46:53 |
| 8818 | 4555 | 3 | 2017-09-15 15:58:40 |
| 8819 | 4580 | 2 | 2017-09-16 10:14:23 |
| 8820 | 4577 | 2 | 2017-09-16 10:25:15 |
| 8821 | 4578 | 2 | 2017-09-16 10:25:33 |
| 8822 | 4579 | 2 | 2017-09-16 10:25:49 |
| 8823 | 4579 | 3 | 2017-09-16 11:12:06 |
| 8824 | 4580 | 3 | 2017-09-16 11:21:22 |
| 8825 | 4577 | 3 | 2017-09-16 11:48:16 |
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;