Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,601–15,625 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15601 | 7864 | 1 | 2019-04-15 12:19:27 |
| 15602 | 7868 | 1 | 2019-04-15 12:19:47 |
| 15603 | 7831 | 1 | 2019-04-15 12:20:24 |
| 15604 | 7861 | 1 | 2019-04-15 12:20:25 |
| 15605 | 7869 | 1 | 2019-04-15 12:20:29 |
| 15606 | 7839 | 1 | 2019-04-15 12:20:37 |
| 15607 | 7872 | 1 | 2019-04-15 12:20:42 |
| 15608 | 7848 | 1 | 2019-04-15 12:20:46 |
| 15609 | 7871 | 1 | 2019-04-15 12:20:55 |
| 15610 | 7843 | 1 | 2019-04-15 12:21:51 |
| 15611 | 7832 | 1 | 2019-04-15 12:21:54 |
| 15612 | 7835 | 1 | 2019-04-15 12:22:04 |
| 15613 | 7837 | 1 | 2019-04-15 12:22:34 |
| 15614 | 7825 | 1 | 2019-04-15 12:23:06 |
| 15615 | 7867 | 1 | 2019-04-15 12:23:25 |
| 15616 | 7851 | 1 | 2019-04-15 12:23:34 |
| 15617 | 7859 | 1 | 2019-04-15 12:23:34 |
| 15618 | 7828 | 1 | 2019-04-15 12:23:37 |
| 15619 | 7850 | 1 | 2019-04-15 12:24:11 |
| 15620 | 7846 | 1 | 2019-04-15 12:26:21 |
| 15621 | 7836 | 1 | 2019-04-15 12:26:30 |
| 15622 | 7854 | 1 | 2019-04-15 12:26:57 |
| 15623 | 7830 | 1 | 2019-04-15 12:27:24 |
| 15624 | 7829 | 1 | 2019-04-15 12:27:43 |
| 15625 | 7845 | 1 | 2019-04-15 12:27:57 |
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;