Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,651–7,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7651 | 3871 | 1 | 2017-05-27 16:40:30 |
| 7652 | 3871 | 2 | 2017-05-27 17:25:40 |
| 7653 | 3870 | 1 | 2017-05-27 17:47:49 |
| 7654 | 3951 | 1 | 2017-05-28 09:34:30 |
| 7655 | 3950 | 1 | 2017-05-28 09:40:35 |
| 7656 | 3962 | 2 | 2017-05-28 10:06:15 |
| 7657 | 3963 | 2 | 2017-05-28 10:06:46 |
| 7658 | 3964 | 2 | 2017-05-28 10:10:29 |
| 7659 | 3951 | 2 | 2017-05-28 10:28:28 |
| 7660 | 3950 | 2 | 2017-05-28 10:32:21 |
| 7661 | 3964 | 1 | 2017-05-28 11:08:37 |
| 7662 | 3962 | 1 | 2017-05-28 11:13:15 |
| 7663 | 3972 | 1 | 2017-05-28 11:16:31 |
| 7664 | 3973 | 1 | 2017-05-28 11:22:10 |
| 7665 | 3963 | 1 | 2017-05-28 11:37:12 |
| 7666 | 3974 | 2 | 2017-05-28 11:46:11 |
| 7667 | 3950 | 3 | 2017-05-28 11:48:15 |
| 7668 | 3951 | 3 | 2017-05-28 11:55:54 |
| 7669 | 3973 | 3 | 2017-05-28 11:57:10 |
| 7670 | 3972 | 3 | 2017-05-28 12:02:55 |
| 7671 | 3962 | 2 | 2017-05-28 12:14:55 |
| 7672 | 3975 | 1 | 2017-05-28 12:17:30 |
| 7673 | 3950 | 2 | 2017-05-28 12:18:09 |
| 7674 | 3964 | 2 | 2017-05-28 12:32:55 |
| 7675 | 3973 | 1 | 2017-05-28 12:34:49 |
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;