Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,326–19,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19326 | 9723 | 1 | 2020-01-29 11:30:19 |
| 19327 | 9745 | 2 | 2020-01-29 12:37:35 |
| 19328 | 9738 | 3 | 2020-01-29 13:09:01 |
| 19329 | 9737 | 3 | 2020-01-29 13:09:37 |
| 19330 | 9739 | 3 | 2020-01-29 13:14:39 |
| 19331 | 9716 | 2 | 2020-01-29 14:10:16 |
| 19332 | 9716 | 1 | 2020-01-29 14:39:32 |
| 19333 | 9741 | 2 | 2020-01-31 12:49:07 |
| 19334 | 9753 | 2 | 2020-02-01 11:34:51 |
| 19335 | 9752 | 2 | 2020-02-01 11:38:59 |
| 19336 | 9707 | 2 | 2020-02-01 11:41:34 |
| 19337 | 9708 | 2 | 2020-02-01 11:43:14 |
| 19338 | 9752 | 3 | 2020-02-01 12:18:53 |
| 19339 | 9753 | 3 | 2020-02-01 12:23:24 |
| 19340 | 9757 | 3 | 2020-02-01 12:48:43 |
| 19341 | 9756 | 3 | 2020-02-01 12:53:11 |
| 19342 | 9707 | 3 | 2020-02-01 13:13:57 |
| 19343 | 9708 | 3 | 2020-02-01 13:14:03 |
| 19344 | 9757 | 1 | 2020-02-01 13:50:05 |
| 19345 | 9757 | 3 | 2020-02-01 14:17:39 |
| 19346 | 9756 | 1 | 2020-02-01 14:25:34 |
| 19347 | 9756 | 3 | 2020-02-01 14:56:22 |
| 19348 | 9757 | 1 | 2020-02-01 15:36:28 |
| 19349 | 9756 | 1 | 2020-02-01 15:53:48 |
| 19350 | 9760 | 2 | 2020-02-02 10:59:24 |
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;