Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,476–8,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8476 | 4394 | 3 | 2017-08-15 11:34:39 |
| 8477 | 4394 | 1 | 2017-08-15 12:17:25 |
| 8478 | 4394 | 2 | 2017-08-15 13:06:53 |
| 8479 | 4394 | 3 | 2017-08-15 13:41:50 |
| 8480 | 4344 | 2 | 2017-08-16 09:42:27 |
| 8481 | 4345 | 2 | 2017-08-16 09:43:19 |
| 8482 | 4400 | 2 | 2017-08-16 09:43:42 |
| 8483 | 4400 | 1 | 2017-08-16 10:38:11 |
| 8484 | 4308 | 2 | 2017-08-16 14:49:39 |
| 8485 | 4405 | 3 | 2017-08-17 11:43:44 |
| 8486 | 4404 | 3 | 2017-08-17 11:44:50 |
| 8487 | 4406 | 1 | 2017-08-17 11:54:08 |
| 8488 | 4403 | 3 | 2017-08-17 11:55:06 |
| 8489 | 4314 | 3 | 2017-08-17 12:57:25 |
| 8490 | 4315 | 3 | 2017-08-17 13:06:24 |
| 8491 | 4315 | 1 | 2017-08-17 13:53:51 |
| 8492 | 4314 | 1 | 2017-08-17 14:04:53 |
| 8493 | 4407 | 2 | 2017-08-17 14:28:04 |
| 8494 | 4410 | 1 | 2017-08-18 12:23:34 |
| 8495 | 4409 | 1 | 2017-08-18 12:40:12 |
| 8496 | 4410 | 2 | 2017-08-18 13:08:07 |
| 8497 | 4410 | 3 | 2017-08-18 13:37:47 |
| 8498 | 4409 | 2 | 2017-08-18 13:56:19 |
| 8499 | 4409 | 3 | 2017-08-18 14:50:43 |
| 8500 | 4363 | 2 | 2017-08-19 09:35: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;