Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,051–6,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6051 | 3074 | 3 | 2016-11-30 16:49:02 |
| 6052 | 3073 | 2 | 2016-11-30 17:18:43 |
| 6053 | 3074 | 1 | 2016-11-30 17:30:19 |
| 6054 | 3048 | 2 | 2016-12-01 10:36:02 |
| 6055 | 3048 | 3 | 2016-12-01 11:31:53 |
| 6056 | 3067 | 2 | 2016-12-02 13:45:01 |
| 6057 | 3137 | 2 | 2016-12-03 12:12:14 |
| 6058 | 3144 | 3 | 2016-12-04 14:07:58 |
| 6059 | 3144 | 2 | 2016-12-04 14:58:38 |
| 6060 | 3144 | 3 | 2016-12-04 16:18:31 |
| 6061 | 3150 | 3 | 2016-12-07 10:35:22 |
| 6062 | 3075 | 1 | 2016-12-07 11:00:25 |
| 6063 | 3077 | 1 | 2016-12-07 11:02:09 |
| 6064 | 3150 | 2 | 2016-12-07 11:04:22 |
| 6065 | 3076 | 1 | 2016-12-07 11:05:01 |
| 6066 | 3075 | 2 | 2016-12-07 11:34:30 |
| 6067 | 3077 | 2 | 2016-12-07 11:53:47 |
| 6068 | 3076 | 2 | 2016-12-07 12:29:01 |
| 6069 | 3072 | 2 | 2016-12-08 11:13:06 |
| 6070 | 3070 | 2 | 2016-12-08 11:20:58 |
| 6071 | 3071 | 2 | 2016-12-08 11:21:15 |
| 6072 | 3069 | 2 | 2016-12-08 11:28:14 |
| 6073 | 3070 | 1 | 2016-12-08 11:58:29 |
| 6074 | 3072 | 3 | 2016-12-08 12:01:56 |
| 6075 | 3070 | 2 | 2016-12-08 12:33:03 |
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;