Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,076–6,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6076 | 3069 | 3 | 2016-12-08 12:50:47 |
| 6077 | 3071 | 3 | 2016-12-08 12:52:45 |
| 6078 | 3148 | 1 | 2016-12-08 13:16:48 |
| 6079 | 3145 | 2 | 2016-12-08 13:20:00 |
| 6080 | 3147 | 1 | 2016-12-08 13:20:39 |
| 6081 | 3146 | 1 | 2016-12-08 13:30:08 |
| 6082 | 3145 | 1 | 2016-12-08 13:56:08 |
| 6083 | 3145 | 2 | 2016-12-08 15:12:57 |
| 6084 | 3151 | 3 | 2016-12-08 17:07:54 |
| 6085 | 3143 | 3 | 2016-12-09 10:11:12 |
| 6086 | 3156 | 3 | 2016-12-10 16:45:21 |
| 6087 | 3164 | 2 | 2016-12-11 13:56:19 |
| 6088 | 3165 | 2 | 2016-12-11 13:58:19 |
| 6089 | 3166 | 3 | 2016-12-11 14:23:17 |
| 6090 | 3165 | 1 | 2016-12-11 14:56:22 |
| 6091 | 3164 | 3 | 2016-12-11 15:16:45 |
| 6092 | 3166 | 1 | 2016-12-11 15:20:14 |
| 6093 | 3167 | 2 | 2016-12-12 16:56:33 |
| 6094 | 3167 | 1 | 2016-12-12 17:39:47 |
| 6095 | 3159 | 1 | 2016-12-13 14:42:24 |
| 6096 | 3157 | 3 | 2016-12-13 14:46:23 |
| 6097 | 3160 | 2 | 2016-12-13 14:53:15 |
| 6098 | 3158 | 2 | 2016-12-13 14:56:50 |
| 6099 | 3158 | 3 | 2016-12-13 16:12:12 |
| 6100 | 3170 | 2 | 2016-12-13 16:37:12 |
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;