Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,501–10,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10501 | 5154 | 2 | 2018-03-23 12:28:08 |
| 10502 | 5157 | 2 | 2018-03-23 12:28:11 |
| 10503 | 5169 | 2 | 2018-03-23 12:29:09 |
| 10504 | 5198 | 2 | 2018-03-23 12:29:41 |
| 10505 | 5193 | 2 | 2018-03-23 12:30:28 |
| 10506 | 5199 | 2 | 2018-03-23 12:30:53 |
| 10507 | 5188 | 2 | 2018-03-23 12:31:34 |
| 10508 | 5156 | 3 | 2018-03-23 12:40:13 |
| 10509 | 5178 | 3 | 2018-03-23 12:47:30 |
| 10510 | 5171 | 3 | 2018-03-23 12:51:13 |
| 10511 | 5164 | 3 | 2018-03-23 12:51:43 |
| 10512 | 5158 | 3 | 2018-03-23 12:52:35 |
| 10513 | 5196 | 3 | 2018-03-23 12:53:25 |
| 10514 | 5169 | 3 | 2018-03-23 12:56:58 |
| 10515 | 5153 | 3 | 2018-03-23 12:58:44 |
| 10516 | 5176 | 3 | 2018-03-23 12:59:23 |
| 10517 | 5193 | 3 | 2018-03-23 12:59:46 |
| 10518 | 5180 | 3 | 2018-03-23 13:00:48 |
| 10519 | 5182 | 3 | 2018-03-23 13:02:21 |
| 10520 | 5192 | 3 | 2018-03-23 13:04:10 |
| 10521 | 5197 | 3 | 2018-03-23 13:04:39 |
| 10522 | 5189 | 3 | 2018-03-23 13:06:10 |
| 10523 | 5194 | 3 | 2018-03-23 13:10:13 |
| 10524 | 5165 | 3 | 2018-03-23 13:12:05 |
| 10525 | 5199 | 3 | 2018-03-23 13:15:42 |
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;