Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,126–13,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13126 | 6736 | 1 | 2018-09-19 14:08:14 |
| 13127 | 6734 | 1 | 2018-09-19 14:18:22 |
| 13128 | 6735 | 1 | 2018-09-19 14:57:35 |
| 13129 | 6737 | 2 | 2018-09-20 11:40:16 |
| 13130 | 6738 | 2 | 2018-09-20 11:45:23 |
| 13131 | 6737 | 3 | 2018-09-20 12:31:49 |
| 13132 | 6738 | 3 | 2018-09-20 12:49:15 |
| 13133 | 6737 | 2 | 2018-09-20 13:13:04 |
| 13134 | 6738 | 2 | 2018-09-20 13:31:02 |
| 13135 | 6484 | 1 | 2018-09-20 14:11:26 |
| 13136 | 6737 | 1 | 2018-09-20 14:39:34 |
| 13137 | 6738 | 1 | 2018-09-20 14:56:33 |
| 13138 | 6484 | 2 | 2018-09-20 15:01:29 |
| 13139 | 6740 | 3 | 2018-09-21 09:13:14 |
| 13140 | 6741 | 3 | 2018-09-21 09:17:59 |
| 13141 | 6740 | 1 | 2018-09-21 10:22:55 |
| 13142 | 6741 | 1 | 2018-09-21 10:28:42 |
| 13143 | 6692 | 2 | 2018-09-23 14:04:55 |
| 13144 | 6748 | 3 | 2018-09-23 14:12:01 |
| 13145 | 6746 | 3 | 2018-09-23 14:14:58 |
| 13146 | 6747 | 2 | 2018-09-23 14:15:36 |
| 13147 | 6747 | 1 | 2018-09-23 15:17:10 |
| 13148 | 6692 | 3 | 2018-09-23 15:31:24 |
| 13149 | 6748 | 2 | 2018-09-23 15:33:42 |
| 13150 | 6746 | 1 | 2018-09-23 15:35:59 |
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;