Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,151–19,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19151 | 9652 | 1 | 2020-01-08 13:51:17 |
| 19152 | 9652 | 2 | 2020-01-08 15:06:45 |
| 19153 | 9654 | 1 | 2020-01-09 10:36:19 |
| 19154 | 9655 | 1 | 2020-01-09 10:36:34 |
| 19155 | 9589 | 1 | 2020-01-09 11:06:51 |
| 19156 | 9588 | 1 | 2020-01-09 11:10:14 |
| 19157 | 9655 | 3 | 2020-01-09 11:33:21 |
| 19158 | 9654 | 3 | 2020-01-09 11:41:05 |
| 19159 | 9657 | 3 | 2020-01-09 12:03:26 |
| 19160 | 9656 | 2 | 2020-01-09 12:03:35 |
| 19161 | 9655 | 1 | 2020-01-09 12:04:20 |
| 19162 | 9656 | 3 | 2020-01-09 12:31:24 |
| 19163 | 9657 | 1 | 2020-01-09 12:43:01 |
| 19164 | 9655 | 2 | 2020-01-09 12:46:46 |
| 19165 | 9654 | 1 | 2020-01-09 12:52:46 |
| 19166 | 9654 | 2 | 2020-01-09 13:25:14 |
| 19167 | 9575 | 2 | 2020-01-09 13:30:54 |
| 19168 | 9574 | 2 | 2020-01-09 13:38:28 |
| 19169 | 9658 | 3 | 2020-01-09 13:53:18 |
| 19170 | 9649 | 2 | 2020-01-09 15:40:51 |
| 19171 | 9648 | 2 | 2020-01-09 15:55:45 |
| 19172 | 9648 | 1 | 2020-01-09 16:22:36 |
| 19173 | 9649 | 1 | 2020-01-09 16:50:00 |
| 19174 | 9648 | 2 | 2020-01-09 17:33:40 |
| 19175 | 9649 | 2 | 2020-01-09 17:35:41 |
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;