Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,276–17,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17276 | 8739 | 3 | 2019-08-12 13:13:11 |
| 17277 | 8671 | 2 | 2019-08-12 13:20:12 |
| 17278 | 8757 | 2 | 2019-08-13 09:53:55 |
| 17279 | 8757 | 1 | 2019-08-13 10:24:47 |
| 17280 | 8760 | 2 | 2019-08-14 13:29:59 |
| 17281 | 8721 | 2 | 2019-08-14 14:08:38 |
| 17282 | 8719 | 2 | 2019-08-14 14:10:04 |
| 17283 | 8720 | 2 | 2019-08-14 14:16:51 |
| 17284 | 8760 | 3 | 2019-08-14 14:45:02 |
| 17285 | 8721 | 1 | 2019-08-14 14:50:19 |
| 17286 | 8720 | 1 | 2019-08-14 15:04:05 |
| 17287 | 8719 | 1 | 2019-08-14 15:34:43 |
| 17288 | 8721 | 2 | 2019-08-14 15:56:25 |
| 17289 | 8760 | 1 | 2019-08-14 15:58:28 |
| 17290 | 8720 | 2 | 2019-08-14 16:16:08 |
| 17291 | 8719 | 2 | 2019-08-14 16:25:48 |
| 17292 | 8721 | 3 | 2019-08-14 16:29:19 |
| 17293 | 8720 | 3 | 2019-08-14 16:43:13 |
| 17294 | 8719 | 3 | 2019-08-14 17:43:03 |
| 17295 | 8508 | 1 | 2019-08-15 10:00:32 |
| 17296 | 8508 | 3 | 2019-08-15 10:47:07 |
| 17297 | 8508 | 1 | 2019-08-15 11:48:13 |
| 17298 | 8758 | 1 | 2019-08-15 11:49:34 |
| 17299 | 8508 | 2 | 2019-08-15 12:27:31 |
| 17300 | 8508 | 3 | 2019-08-15 13:16:39 |
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;