Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,551–16,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16551 | 8404 | 3 | 2019-06-22 12:51:18 |
| 16552 | 8359 | 1 | 2019-06-22 13:23:33 |
| 16553 | 8358 | 1 | 2019-06-22 13:30:17 |
| 16554 | 8403 | 2 | 2019-06-22 13:34:31 |
| 16555 | 8358 | 2 | 2019-06-22 14:02:44 |
| 16556 | 8358 | 3 | 2019-06-22 14:28:47 |
| 16557 | 8359 | 2 | 2019-06-22 14:51:46 |
| 16558 | 8359 | 3 | 2019-06-22 15:55:31 |
| 16559 | 8289 | 3 | 2019-06-23 16:56:32 |
| 16560 | 8291 | 3 | 2019-06-23 17:03:11 |
| 16561 | 8290 | 1 | 2019-06-23 17:04:54 |
| 16562 | 8368 | 2 | 2019-06-24 10:46:21 |
| 16563 | 8367 | 2 | 2019-06-24 10:49:11 |
| 16564 | 8367 | 3 | 2019-06-24 11:31:46 |
| 16565 | 8368 | 3 | 2019-06-24 11:38:32 |
| 16566 | 8390 | 2 | 2019-06-24 12:54:51 |
| 16567 | 8389 | 2 | 2019-06-24 13:00:29 |
| 16568 | 8388 | 2 | 2019-06-24 13:00:33 |
| 16569 | 8388 | 1 | 2019-06-24 13:27:11 |
| 16570 | 8389 | 3 | 2019-06-24 13:28:36 |
| 16571 | 8390 | 1 | 2019-06-24 13:59:42 |
| 16572 | 8389 | 1 | 2019-06-24 14:54:41 |
| 16573 | 8413 | 2 | 2019-06-25 10:27:38 |
| 16574 | 8414 | 2 | 2019-06-25 10:29:13 |
| 16575 | 8415 | 3 | 2019-06-25 10:31:11 |
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;