Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,076–17,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17076 | 8640 | 3 | 2019-07-29 15:11:58 |
| 17077 | 8640 | 2 | 2019-07-29 16:07:59 |
| 17078 | 8663 | 2 | 2019-07-30 11:32:41 |
| 17079 | 8664 | 2 | 2019-07-30 11:45:43 |
| 17080 | 8664 | 3 | 2019-07-30 12:23:00 |
| 17081 | 8664 | 1 | 2019-07-30 13:18:30 |
| 17082 | 8535 | 1 | 2019-07-30 13:25:27 |
| 17083 | 8536 | 2 | 2019-07-30 13:30:11 |
| 17084 | 8538 | 1 | 2019-07-30 13:36:21 |
| 17085 | 8534 | 1 | 2019-07-30 13:36:58 |
| 17086 | 8537 | 1 | 2019-07-30 13:40:25 |
| 17087 | 8537 | 3 | 2019-07-30 14:07:49 |
| 17088 | 8534 | 3 | 2019-07-30 14:14:37 |
| 17089 | 8664 | 2 | 2019-07-30 14:46:23 |
| 17090 | 8535 | 3 | 2019-07-30 15:01:14 |
| 17091 | 8538 | 3 | 2019-07-30 15:11:11 |
| 17092 | 8669 | 2 | 2019-08-01 14:04:28 |
| 17093 | 8677 | 2 | 2019-08-02 09:24:34 |
| 17094 | 8675 | 2 | 2019-08-02 09:25:24 |
| 17095 | 8681 | 3 | 2019-08-02 09:33:03 |
| 17096 | 8676 | 1 | 2019-08-02 09:33:04 |
| 17097 | 8674 | 2 | 2019-08-02 09:35:44 |
| 17098 | 8678 | 3 | 2019-08-02 09:36:42 |
| 17099 | 8682 | 3 | 2019-08-02 09:39:41 |
| 17100 | 8679 | 3 | 2019-08-02 09:42:24 |
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;