Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,676–11,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11676 | 6171 | 1 | 2018-07-06 14:35:09 |
| 11677 | 6171 | 2 | 2018-07-06 15:02:10 |
| 11678 | 6186 | 2 | 2018-07-07 09:09:36 |
| 11679 | 6187 | 2 | 2018-07-07 09:12:37 |
| 11680 | 6188 | 2 | 2018-07-07 09:14:00 |
| 11681 | 6189 | 2 | 2018-07-07 09:16:32 |
| 11682 | 6188 | 3 | 2018-07-07 09:49:42 |
| 11683 | 6186 | 3 | 2018-07-07 10:25:27 |
| 11684 | 6187 | 3 | 2018-07-07 10:26:36 |
| 11685 | 6189 | 3 | 2018-07-07 10:33:13 |
| 11686 | 6094 | 2 | 2018-07-07 10:33:20 |
| 11687 | 6093 | 1 | 2018-07-07 10:33:29 |
| 11688 | 6095 | 1 | 2018-07-07 10:34:51 |
| 11689 | 5940 | 2 | 2018-07-07 10:39:39 |
| 11690 | 5941 | 2 | 2018-07-07 10:41:00 |
| 11691 | 5941 | 1 | 2018-07-07 11:19:53 |
| 11692 | 5940 | 1 | 2018-07-07 11:33:10 |
| 11693 | 5940 | 3 | 2018-07-07 12:35:51 |
| 11694 | 5941 | 3 | 2018-07-07 12:48:55 |
| 11695 | 6190 | 3 | 2018-07-08 10:41:00 |
| 11696 | 6191 | 3 | 2018-07-08 10:45:25 |
| 11697 | 6051 | 3 | 2018-07-08 10:53:10 |
| 11698 | 6050 | 3 | 2018-07-08 11:03:51 |
| 11699 | 6190 | 2 | 2018-07-08 11:41:55 |
| 11700 | 6191 | 2 | 2018-07-08 11:59:34 |
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;