Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,626–8,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8626 | 4517 | 1 | 2017-08-27 13:26:25 |
| 8627 | 4515 | 3 | 2017-08-27 13:30:41 |
| 8628 | 4516 | 2 | 2017-08-27 13:49:33 |
| 8629 | 4518 | 2 | 2017-08-27 14:24:19 |
| 8630 | 4519 | 2 | 2017-08-27 14:39:33 |
| 8631 | 4515 | 2 | 2017-08-27 15:04:30 |
| 8632 | 4520 | 2 | 2017-08-27 15:25:54 |
| 8633 | 4500 | 2 | 2017-08-27 16:12:26 |
| 8634 | 4499 | 2 | 2017-08-27 16:21:32 |
| 8635 | 4520 | 3 | 2017-08-27 16:41:31 |
| 8636 | 4500 | 1 | 2017-08-27 17:00:02 |
| 8637 | 4499 | 3 | 2017-08-27 17:01:35 |
| 8638 | 4509 | 3 | 2017-08-28 11:38:10 |
| 8639 | 4507 | 1 | 2017-08-28 11:39:35 |
| 8640 | 4508 | 1 | 2017-08-28 11:54:45 |
| 8641 | 4511 | 1 | 2017-08-28 11:55:13 |
| 8642 | 4510 | 1 | 2017-08-28 11:55:14 |
| 8643 | 4508 | 2 | 2017-08-28 12:34:06 |
| 8644 | 4507 | 2 | 2017-08-28 12:46:01 |
| 8645 | 4510 | 2 | 2017-08-28 13:08:01 |
| 8646 | 4511 | 2 | 2017-08-28 13:27:33 |
| 8647 | 4375 | 2 | 2017-08-29 11:47:00 |
| 8648 | 4486 | 2 | 2017-08-29 12:47:13 |
| 8649 | 4485 | 2 | 2017-08-29 12:47:53 |
| 8650 | 4375 | 3 | 2017-08-29 13:10:53 |
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;