Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,676–18,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18676 | 8969 | 2 | 2019-12-15 12:15:57 |
| 18677 | 8972 | 2 | 2019-12-15 12:17:28 |
| 18678 | 8985 | 2 | 2019-12-15 12:17:31 |
| 18679 | 8999 | 2 | 2019-12-15 12:17:46 |
| 18680 | 8968 | 2 | 2019-12-15 12:19:04 |
| 18681 | 8962 | 2 | 2019-12-15 12:23:08 |
| 18682 | 8976 | 2 | 2019-12-15 12:23:16 |
| 18683 | 8961 | 2 | 2019-12-15 12:24:35 |
| 18684 | 8990 | 1 | 2019-12-15 12:24:51 |
| 18685 | 9002 | 1 | 2019-12-15 12:27:42 |
| 18686 | 9004 | 2 | 2019-12-15 12:30:31 |
| 18687 | 8978 | 2 | 2019-12-15 12:31:02 |
| 18688 | 8965 | 2 | 2019-12-15 12:32:10 |
| 18689 | 8996 | 1 | 2019-12-15 12:40:36 |
| 18690 | 8981 | 2 | 2019-12-15 12:41:31 |
| 18691 | 8977 | 1 | 2019-12-15 12:41:43 |
| 18692 | 9000 | 2 | 2019-12-15 12:42:34 |
| 18693 | 8966 | 2 | 2019-12-15 12:43:20 |
| 18694 | 8998 | 2 | 2019-12-15 12:46:07 |
| 18695 | 8960 | 2 | 2019-12-15 12:46:31 |
| 18696 | 8984 | 2 | 2019-12-15 12:47:22 |
| 18697 | 8997 | 2 | 2019-12-15 12:47:38 |
| 18698 | 8983 | 1 | 2019-12-15 12:47:40 |
| 18699 | 8967 | 1 | 2019-12-15 12:48:48 |
| 18700 | 9005 | 1 | 2019-12-15 12:49:33 |
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;