Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,176–15,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15176 | 7493 | 2 | 2019-03-15 14:39:43 |
| 15177 | 7497 | 2 | 2019-03-15 14:40:13 |
| 15178 | 7525 | 2 | 2019-03-15 14:40:25 |
| 15179 | 7485 | 3 | 2019-03-15 14:40:55 |
| 15180 | 7516 | 2 | 2019-03-15 14:41:23 |
| 15181 | 7502 | 3 | 2019-03-15 14:41:59 |
| 15182 | 7522 | 2 | 2019-03-15 14:42:52 |
| 15183 | 7510 | 2 | 2019-03-15 14:43:04 |
| 15184 | 7488 | 3 | 2019-03-15 14:45:26 |
| 15185 | 7511 | 2 | 2019-03-15 14:47:07 |
| 15186 | 7491 | 3 | 2019-03-15 14:47:21 |
| 15187 | 7500 | 3 | 2019-03-15 14:47:53 |
| 15188 | 7508 | 2 | 2019-03-15 14:48:46 |
| 15189 | 7498 | 2 | 2019-03-15 14:49:25 |
| 15190 | 7504 | 3 | 2019-03-15 14:50:11 |
| 15191 | 7489 | 3 | 2019-03-15 14:50:12 |
| 15192 | 7518 | 3 | 2019-03-15 14:50:27 |
| 15193 | 7490 | 2 | 2019-03-15 14:50:45 |
| 15194 | 7494 | 3 | 2019-03-15 14:50:56 |
| 15195 | 7519 | 2 | 2019-03-15 14:51:51 |
| 15196 | 7486 | 3 | 2019-03-15 14:52:04 |
| 15197 | 7523 | 2 | 2019-03-15 14:52:25 |
| 15198 | 7503 | 2 | 2019-03-15 14:53:24 |
| 15199 | 7495 | 3 | 2019-03-15 14:54:22 |
| 15200 | 7479 | 2 | 2019-03-15 14:55:30 |
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;