Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,226–15,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15226 | 7499 | 3 | 2019-03-15 15:45:21 |
| 15227 | 7477 | 3 | 2019-03-15 15:45:23 |
| 15228 | 7519 | 3 | 2019-03-15 15:47:47 |
| 15229 | 7524 | 3 | 2019-03-15 15:51:57 |
| 15230 | 7521 | 3 | 2019-03-15 15:56:37 |
| 15231 | 7513 | 3 | 2019-03-15 15:57:32 |
| 15232 | 7484 | 3 | 2019-03-15 15:58:09 |
| 15233 | 7516 | 3 | 2019-03-15 16:05:03 |
| 15234 | 7490 | 3 | 2019-03-15 16:06:51 |
| 15235 | 7498 | 3 | 2019-03-15 16:06:53 |
| 15236 | 7497 | 3 | 2019-03-15 16:15:05 |
| 15237 | 7523 | 3 | 2019-03-15 16:17:54 |
| 15238 | 7482 | 3 | 2019-03-15 16:19:18 |
| 15239 | 7520 | 3 | 2019-03-15 16:20:12 |
| 15240 | 7479 | 3 | 2019-03-15 16:25:48 |
| 15241 | 7478 | 3 | 2019-03-15 16:28:50 |
| 15242 | 7779 | 2 | 2019-03-15 17:03:46 |
| 15243 | 7777 | 2 | 2019-03-15 17:03:55 |
| 15244 | 7775 | 2 | 2019-03-15 17:04:24 |
| 15245 | 7778 | 2 | 2019-03-15 17:08:46 |
| 15246 | 7776 | 2 | 2019-03-15 17:16:56 |
| 15247 | 7779 | 3 | 2019-03-15 17:35:36 |
| 15248 | 7722 | 2 | 2019-03-17 10:42:02 |
| 15249 | 7723 | 2 | 2019-03-17 10:46:32 |
| 15250 | 7750 | 2 | 2019-03-17 16:26: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;