Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,126–6,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6126 | 3140 | 1 | 2016-12-15 11:34:38 |
| 6127 | 3142 | 2 | 2016-12-15 11:41:50 |
| 6128 | 3138 | 1 | 2016-12-15 11:42:05 |
| 6129 | 3140 | 2 | 2016-12-15 12:12:38 |
| 6130 | 3161 | 2 | 2016-12-15 12:14:27 |
| 6131 | 3162 | 3 | 2016-12-15 12:19:06 |
| 6132 | 3141 | 3 | 2016-12-15 12:27:47 |
| 6133 | 3140 | 3 | 2016-12-15 12:53:31 |
| 6134 | 3138 | 3 | 2016-12-15 13:03:37 |
| 6135 | 3139 | 3 | 2016-12-15 13:06:48 |
| 6136 | 3142 | 3 | 2016-12-15 13:16:00 |
| 6137 | 3162 | 2 | 2016-12-15 13:26:22 |
| 6138 | 3138 | 2 | 2016-12-15 14:31:43 |
| 6139 | 3179 | 3 | 2016-12-15 15:51:08 |
| 6140 | 3179 | 1 | 2016-12-15 16:23:43 |
| 6141 | 3182 | 2 | 2016-12-16 14:47:11 |
| 6142 | 3183 | 2 | 2016-12-18 12:03:31 |
| 6143 | 3185 | 3 | 2016-12-18 12:04:39 |
| 6144 | 3184 | 2 | 2016-12-18 12:06:47 |
| 6145 | 3184 | 1 | 2016-12-18 12:41:16 |
| 6146 | 3183 | 1 | 2016-12-18 12:46:40 |
| 6147 | 3184 | 3 | 2016-12-18 14:01:10 |
| 6148 | 3183 | 3 | 2016-12-18 14:16:16 |
| 6149 | 3239 | 1 | 2016-12-19 13:39:00 |
| 6150 | 3239 | 3 | 2016-12-19 14:37:34 |
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;