Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,201–19,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19201 | 9685 | 2 | 2020-01-15 14:43:31 |
| 19202 | 9684 | 2 | 2020-01-15 14:57:21 |
| 19203 | 9653 | 1 | 2020-01-16 09:41:35 |
| 19204 | 9653 | 2 | 2020-01-16 10:18:36 |
| 19205 | 9653 | 3 | 2020-01-16 10:58:06 |
| 19206 | 9554 | 3 | 2020-01-16 15:20:22 |
| 19207 | 9555 | 3 | 2020-01-16 15:33:44 |
| 19208 | 9554 | 2 | 2020-01-16 15:56:55 |
| 19209 | 9555 | 2 | 2020-01-16 16:02:00 |
| 19210 | 9555 | 3 | 2020-01-16 16:39:23 |
| 19211 | 9554 | 3 | 2020-01-16 16:40:13 |
| 19212 | 9555 | 1 | 2020-01-16 17:12:48 |
| 19213 | 9554 | 1 | 2020-01-16 17:35:54 |
| 19214 | 9672 | 2 | 2020-01-17 14:34:11 |
| 19215 | 9669 | 2 | 2020-01-17 14:38:38 |
| 19216 | 9671 | 2 | 2020-01-17 14:45:26 |
| 19217 | 9670 | 2 | 2020-01-17 14:47:18 |
| 19218 | 9671 | 1 | 2020-01-17 15:13:59 |
| 19219 | 9672 | 1 | 2020-01-17 15:16:30 |
| 19220 | 9672 | 3 | 2020-01-17 16:01:34 |
| 19221 | 9669 | 1 | 2020-01-17 16:08:19 |
| 19222 | 9670 | 1 | 2020-01-17 16:15:53 |
| 19223 | 9671 | 3 | 2020-01-17 16:38:48 |
| 19224 | 9670 | 3 | 2020-01-17 16:52:35 |
| 19225 | 9672 | 1 | 2020-01-17 17:10:27 |
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;