Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,726–6,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6726 | 3512 | 2 | 2017-03-02 11:43:19 |
| 6727 | 3511 | 2 | 2017-03-02 11:51:06 |
| 6728 | 3583 | 1 | 2017-03-03 10:39:37 |
| 6729 | 3586 | 1 | 2017-03-03 10:43:35 |
| 6730 | 3585 | 1 | 2017-03-03 10:48:15 |
| 6731 | 3584 | 1 | 2017-03-03 10:51:24 |
| 6732 | 3585 | 3 | 2017-03-03 11:20:40 |
| 6733 | 3584 | 3 | 2017-03-03 11:41:37 |
| 6734 | 3585 | 2 | 2017-03-03 12:03:56 |
| 6735 | 3586 | 3 | 2017-03-03 12:10:54 |
| 6736 | 3583 | 3 | 2017-03-03 12:14:01 |
| 6737 | 3584 | 2 | 2017-03-03 12:17:11 |
| 6738 | 3583 | 2 | 2017-03-03 13:02:48 |
| 6739 | 3586 | 2 | 2017-03-03 13:37:17 |
| 6740 | 3556 | 2 | 2017-03-03 15:54:35 |
| 6741 | 3556 | 1 | 2017-03-03 16:33:20 |
| 6742 | 3591 | 3 | 2017-03-04 10:34:46 |
| 6743 | 3591 | 1 | 2017-03-04 11:44:27 |
| 6744 | 3527 | 2 | 2017-03-05 09:17:44 |
| 6745 | 3528 | 2 | 2017-03-05 09:21:23 |
| 6746 | 3525 | 3 | 2017-03-05 09:23:27 |
| 6747 | 3526 | 2 | 2017-03-05 09:29:27 |
| 6748 | 3528 | 3 | 2017-03-05 09:47:57 |
| 6749 | 3527 | 3 | 2017-03-05 09:54:55 |
| 6750 | 3526 | 3 | 2017-03-05 10:08:01 |
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;