Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,126–19,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19126 | 9638 | 2 | 2020-01-06 13:16:39 |
| 19127 | 9639 | 3 | 2020-01-06 13:36:45 |
| 19128 | 9633 | 2 | 2020-01-06 15:07:24 |
| 19129 | 9632 | 1 | 2020-01-06 15:09:16 |
| 19130 | 9633 | 3 | 2020-01-06 15:35:17 |
| 19131 | 9633 | 1 | 2020-01-06 16:36:01 |
| 19132 | 9646 | 2 | 2020-01-07 10:40:13 |
| 19133 | 9615 | 2 | 2020-01-07 10:40:38 |
| 19134 | 9614 | 1 | 2020-01-07 10:44:03 |
| 19135 | 9616 | 1 | 2020-01-07 10:50:38 |
| 19136 | 9614 | 2 | 2020-01-07 11:25:46 |
| 19137 | 9616 | 2 | 2020-01-07 11:26:14 |
| 19138 | 9647 | 1 | 2020-01-07 11:51:29 |
| 19139 | 9647 | 3 | 2020-01-07 12:26:21 |
| 19140 | 9647 | 1 | 2020-01-07 13:40:00 |
| 19141 | 9634 | 2 | 2020-01-08 10:37:20 |
| 19142 | 9637 | 2 | 2020-01-08 10:38:05 |
| 19143 | 9635 | 2 | 2020-01-08 10:48:08 |
| 19144 | 9636 | 2 | 2020-01-08 10:48:51 |
| 19145 | 9652 | 2 | 2020-01-08 11:15:55 |
| 19146 | 9636 | 3 | 2020-01-08 11:52:16 |
| 19147 | 9637 | 3 | 2020-01-08 11:56:18 |
| 19148 | 9635 | 3 | 2020-01-08 12:08:42 |
| 19149 | 9634 | 3 | 2020-01-08 12:10:29 |
| 19150 | 9652 | 3 | 2020-01-08 12:43:03 |
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;