Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,576–17,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17576 | 8808 | 1 | 2019-09-04 17:06:26 |
| 17577 | 8881 | 3 | 2019-09-04 17:10:06 |
| 17578 | 8880 | 3 | 2019-09-04 17:12:38 |
| 17579 | 8879 | 3 | 2019-09-04 17:25:32 |
| 17580 | 8882 | 3 | 2019-09-04 17:33:21 |
| 17581 | 8799 | 3 | 2019-09-05 12:21:56 |
| 17582 | 8800 | 3 | 2019-09-05 12:24:14 |
| 17583 | 8800 | 2 | 2019-09-05 13:25:57 |
| 17584 | 8799 | 2 | 2019-09-05 13:41:20 |
| 17585 | 8890 | 2 | 2019-09-06 10:30:16 |
| 17586 | 8890 | 1 | 2019-09-06 11:33:11 |
| 17587 | 8752 | 2 | 2019-09-06 12:48:49 |
| 17588 | 8753 | 2 | 2019-09-06 12:57:32 |
| 17589 | 8890 | 3 | 2019-09-06 13:00:11 |
| 17590 | 8752 | 1 | 2019-09-06 13:41:10 |
| 17591 | 8753 | 1 | 2019-09-06 14:06:21 |
| 17592 | 8890 | 1 | 2019-09-06 14:10:53 |
| 17593 | 8816 | 3 | 2019-09-08 10:48:45 |
| 17594 | 8815 | 1 | 2019-09-08 10:59:39 |
| 17595 | 8816 | 2 | 2019-09-08 12:13:54 |
| 17596 | 8900 | 2 | 2019-09-08 13:40:13 |
| 17597 | 8883 | 2 | 2019-09-08 13:47:05 |
| 17598 | 8884 | 2 | 2019-09-08 13:53:10 |
| 17599 | 8900 | 1 | 2019-09-08 15:09:50 |
| 17600 | 8888 | 3 | 2019-09-10 10:25:30 |
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;