Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,626–9,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9626 | 4913 | 3 | 2017-12-06 13:01:10 |
| 9627 | 4912 | 2 | 2017-12-06 13:26:34 |
| 9628 | 4913 | 2 | 2017-12-06 14:21:44 |
| 9629 | 4912 | 3 | 2017-12-06 14:39:55 |
| 9630 | 4913 | 3 | 2017-12-06 15:29:06 |
| 9631 | 4919 | 2 | 2017-12-07 09:22:40 |
| 9632 | 4920 | 2 | 2017-12-07 09:36:47 |
| 9633 | 4923 | 2 | 2017-12-08 11:58:58 |
| 9634 | 4922 | 2 | 2017-12-08 12:02:08 |
| 9635 | 4921 | 2 | 2017-12-08 12:05:05 |
| 9636 | 4921 | 3 | 2017-12-08 12:47:01 |
| 9637 | 4922 | 3 | 2017-12-08 13:29:04 |
| 9638 | 4923 | 3 | 2017-12-08 13:30:54 |
| 9639 | 4921 | 1 | 2017-12-08 14:01:40 |
| 9640 | 4922 | 1 | 2017-12-08 14:07:59 |
| 9641 | 4923 | 1 | 2017-12-08 14:44:07 |
| 9642 | 4911 | 1 | 2017-12-09 10:35:04 |
| 9643 | 4911 | 3 | 2017-12-09 11:24:02 |
| 9644 | 4863 | 3 | 2017-12-09 12:04:18 |
| 9645 | 4864 | 3 | 2017-12-09 12:09:16 |
| 9646 | 4865 | 3 | 2017-12-09 12:11:19 |
| 9647 | 4911 | 2 | 2017-12-09 12:31:09 |
| 9648 | 4863 | 1 | 2017-12-09 12:34:05 |
| 9649 | 4864 | 1 | 2017-12-09 12:34:59 |
| 9650 | 4911 | 3 | 2017-12-09 13:04:33 |
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;