Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,276–9,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9276 | 4830 | 1 | 2017-10-30 11:12:16 |
| 9277 | 4831 | 1 | 2017-10-30 11:40:37 |
| 9278 | 4829 | 1 | 2017-10-30 11:48:08 |
| 9279 | 4781 | 1 | 2017-10-30 11:53:39 |
| 9280 | 4828 | 1 | 2017-10-30 11:59:00 |
| 9281 | 4830 | 2 | 2017-10-30 12:26:44 |
| 9282 | 4829 | 2 | 2017-10-30 12:30:25 |
| 9283 | 4781 | 3 | 2017-10-30 12:57:50 |
| 9284 | 4831 | 2 | 2017-10-30 13:03:37 |
| 9285 | 4828 | 2 | 2017-10-30 13:24:43 |
| 9286 | 4834 | 2 | 2017-10-31 10:40:38 |
| 9287 | 4833 | 2 | 2017-10-31 10:41:32 |
| 9288 | 4832 | 2 | 2017-10-31 10:51:00 |
| 9289 | 4834 | 3 | 2017-10-31 11:27:42 |
| 9290 | 4833 | 3 | 2017-10-31 11:32:38 |
| 9291 | 4832 | 3 | 2017-10-31 12:05:38 |
| 9292 | 4822 | 2 | 2017-11-02 11:02:15 |
| 9293 | 4823 | 2 | 2017-11-02 11:10:48 |
| 9294 | 4823 | 1 | 2017-11-02 11:37:22 |
| 9295 | 4822 | 1 | 2017-11-02 12:31:01 |
| 9296 | 4816 | 2 | 2017-11-04 10:14:26 |
| 9297 | 4815 | 2 | 2017-11-04 10:22:46 |
| 9298 | 4816 | 3 | 2017-11-04 11:17:45 |
| 9299 | 4815 | 1 | 2017-11-04 11:47:57 |
| 9300 | 4816 | 2 | 2017-11-04 12:07:49 |
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;