Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,026–1,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1026 | 657 | 2 | 2015-06-11 09:32:01 |
| 1027 | 658 | 2 | 2015-06-11 09:34:56 |
| 1028 | 658 | 3 | 2015-06-11 10:19:11 |
| 1029 | 657 | 3 | 2015-06-11 10:32:44 |
| 1030 | 632 | 3 | 2015-06-11 10:50:38 |
| 1031 | 657 | 1 | 2015-06-11 11:20:44 |
| 1032 | 632 | 1 | 2015-06-11 12:04:07 |
| 1033 | 661 | 2 | 2015-06-11 13:15:55 |
| 1034 | 660 | 2 | 2015-06-11 13:17:46 |
| 1035 | 662 | 2 | 2015-06-11 13:20:10 |
| 1036 | 659 | 2 | 2015-06-11 13:31:21 |
| 1037 | 661 | 3 | 2015-06-11 13:51:03 |
| 1038 | 660 | 1 | 2015-06-11 14:09:11 |
| 1039 | 662 | 3 | 2015-06-11 14:36:24 |
| 1040 | 660 | 2 | 2015-06-11 14:40:28 |
| 1041 | 659 | 3 | 2015-06-11 14:59:01 |
| 1042 | 661 | 1 | 2015-06-11 14:59:18 |
| 1043 | 662 | 1 | 2015-06-11 15:18:35 |
| 1044 | 661 | 3 | 2015-06-11 16:29:13 |
| 1045 | 659 | 1 | 2015-06-11 16:30:01 |
| 1046 | 662 | 3 | 2015-06-11 16:34:11 |
| 1047 | 659 | 3 | 2015-06-11 17:01:45 |
| 1048 | 654 | 3 | 2015-06-11 17:01:57 |
| 1049 | 655 | 2 | 2015-06-12 11:00:35 |
| 1050 | 664 | 2 | 2015-06-12 13:08:32 |
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;