Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,026–6,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6026 | 2948 | 2 | 2016-11-26 11:17:02 |
| 6027 | 2946 | 2 | 2016-11-26 11:17:25 |
| 6028 | 2946 | 3 | 2016-11-26 11:50:54 |
| 6029 | 2948 | 3 | 2016-11-26 12:15:53 |
| 6030 | 2949 | 3 | 2016-11-26 12:23:24 |
| 6031 | 3064 | 1 | 2016-11-27 09:37:28 |
| 6032 | 3065 | 1 | 2016-11-27 09:40:07 |
| 6033 | 3063 | 1 | 2016-11-27 09:49:42 |
| 6034 | 3066 | 3 | 2016-11-27 09:53:01 |
| 6035 | 3066 | 2 | 2016-11-27 10:22:51 |
| 6036 | 3066 | 3 | 2016-11-27 11:08:35 |
| 6037 | 3062 | 2 | 2016-11-27 11:52:33 |
| 6038 | 3061 | 2 | 2016-11-27 11:53:54 |
| 6039 | 3056 | 2 | 2016-11-27 15:54:04 |
| 6040 | 3055 | 2 | 2016-11-27 15:54:39 |
| 6041 | 3057 | 2 | 2016-11-27 15:57:12 |
| 6042 | 3058 | 2 | 2016-11-27 15:57:35 |
| 6043 | 3055 | 1 | 2016-11-27 16:25:45 |
| 6044 | 3058 | 1 | 2016-11-27 16:52:29 |
| 6045 | 3056 | 1 | 2016-11-27 17:01:35 |
| 6046 | 3057 | 1 | 2016-11-27 17:25:17 |
| 6047 | 3068 | 2 | 2016-11-29 10:29:26 |
| 6048 | 3068 | 3 | 2016-11-29 12:03:17 |
| 6049 | 3068 | 1 | 2016-11-29 13:09:17 |
| 6050 | 3073 | 3 | 2016-11-30 16:42:32 |
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;